I use the following code to make my database send users and email when they enter a record. However, the emails come out as one block of unformatted text. I have tried using HTML code eg <P> and <B> but this doesnt work, it just puts those symbols into the email.

Strto is used to get the begining of the email address.

Any advice would be appreciated!

DoCmd.SendObject , , , strto & "@hotmail.com", , , "Your Metrology Request: Job Number " & Me![job number:] & " has been received.", "Your request will be completed as soon as possible and you will be notified by email when it is completed. Please quote the job number in all correspondance with the Metrology Department. N:B: PLEASE DON'T FORGET TO TAKE THE PART TO BE MEASURED TO THE METROLOGY OFFICE! REQUESTS WITHOUT PARTS WILL BE DELETED.", False

Hi Julie

Thankyou for your question

Could you clarify the following please.

Is the text of your message held in a table within the database, or is it created fresh each time the code runs. If the former, could you advise what the format of the data is; ie text or memo?

Regards

Stephen

The text is held in the code that opens the email as its usually the same every time. The only difference is a unique reference number which is picked up from the current record (again in the code).

The code looks like this:

DoCmd.SendObject , , , strto & "@companyname.com", , , "Your Metrology Request: Job Number " & Me![Job number:] & " has been received.", "Your request will be completed as soon as possible and you will be notified by email when it is completed. Please quote the job number in all correspondance with the Metrology Department.", False