Entering additional line

[Tracey Rylatt]

Hi

Can you please help me. I am very new to access and trying to add a new line into a code in access.

I am creating an email template and although I have created the template, when it is given as an email all lines just follow on instead of each line being on a new line i.e.

Name:
Date:
Address:

the code is currently showing: Name: Date: Address

Thanking you in anticipation for your assistance.

Regards.

Tracey

 

[namliam]

adding " & VBNEWLINE " will enter a new line
offcourse without the quotes...

Good luck

 

[Tracey Rylatt]

Hi

Unfortunately this didn't work. This is my code and won't allow me to use it, keeps going yellow.

DoCmd.SendObject acSendNoObject, , , Me.RepEmail, , , "Order Confirmation", "Please find attached Order Acknowledgement for Oracles Sales Order number:" & vbNewLine & "Your Customer Purchase Order number: " & Me.Customer_PO_ & vbNewLine & "The relating reference is ISO:" & vbNewLine & "Your order will be sourced from:" & vbNewLine & vbNewLine & "Please check the configuration summary attached and advise within 24 hours should there be any problems."

I have tried to see if it is case sensitive and still won't allow the code.

Regards.

Tracey

 

[namliam]

What is the error message??

And I ussually do something like:
DoCmd.SendObject acSendNoObject, , , Me.RepEmail, , , "Order Confirmation", "Line1" & vbnewline & _
"Line2 and more info" & vbnewline & _
"Kind regards"

This allows you to see the layout better.

 

[khawar]

You can also use vbcrlf instead of VbNewLine