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
|