98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » ms+access+course/ - Format emails
ms+access+course/ - Format emails
Resolved · Low Priority · Version Standard
Mon 26 Nov 2007, 14:48Delegate Julie said...
Julie has attended:
Access Advanced course
Access VBA course
Format emails
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
Thu 13 Dec 2007, 17:17Trainer Stephen said...
RE: Format emails
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
Thu 28 Feb 2008, 11:10Delegate Julie said...
RE: Format emails
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Combo box for finding recordsYou can use a combo box in a form to look up a record. If you place the comb box in the Form header, by then selcting they a field type from the drop down loist, you will see the record for it |
