SendObject - TemplateFile AND "White Space in MessageText

  • Thread starter Thread starter ant1983
  • Start date Start date
A

ant1983

Hey!!

Right, i have a SendObject button that opens up an email that wilol be sent
to my client. (Its a confirmation voucher of their booking)

Anyway, so i have two questions:

1 - the TemplateFile "option" - Woiuld do i type here???? I tried putting
in the path name but thats not working (im a complete novice in case you were
wondering) :)

2 - I would like a personalised message in the body of the email so i've
pasted this in the MessageText piece of the code:

DoCmd.SendObject acReport, stDocName, acFormatSNP, "", "", "", "Confirmation
Voucher: EXP" & autBookingID, "Dear " & txtBookedBy & ", " & "Thank you for
choosing ABC Travel. Please find attached the confirmation voucher of
booking number EXP" & autBookingID & ". Regards, The ABC Travel-Team
(e-mail address removed)"

The problem is that the text in the email dont look so great in terms of
white space between paragraps - How do i do white space between paragraphs in
code?

Fanks!!!

Wayne
In the MessageText section i would like a
 
Try using vbCrLf every time you want a carriage return/line break:

DoCmd.SendObject acReport, stDocName, acFormatSNP, "", "", "", "Confirmation
Voucher: EXP" & autBookingID, "Dear " & txtBookedBy & ", " & vbCrLf & vbCrLf
& "Thank you for choosing ABC Travel. Please find attached the confirmation
voucher of booking number EXP" & autBookingID & "." & vbCrLf & vbCrLf &
"Regards, The ABC Travel-Team
(e-mail address removed)"
 
That works brilliantly! Thanks!!! Also, do you perhaps know how that
TemplateFile thing works?
 
Back
Top