View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Please help me with this email from excel

Hi Alvin,

Is this any better:

msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn _
& Chr(9) & Chr(13)
msg = msg & Chr(9) & "Booking Date: " & Chr(9) & _
Format(Date, "dd/mm/yyyy") & Chr(9)

---
Regards,
Norman



"Alvin Hansen" wrote in message
...
Hi!!
I send a email from excel its working allright
but i can't make it look good
I use chr(9) to tab
like this
msg = msg & Chr(9) & "Booking Name:" & Chr(9) & navn & Chr(13)
msg = msg & Chr(9) & "Booking Date: " & Chr(9) & Format(Date,
"dd/mm/yyyy")
& Chr(13)

but it don't get so good with the second CHR(9) how can i make this nice.

reagrds

Alvin