Email Template with access details

[stu_c]

Hi all
try and explain, I have got a Email template with a table and also a Access form with details that I want to be emailed off to certain people, the access form details must be in the body of the Email and not a attachment any suggestions on how to do this?

 

[sxschech]

If the data you want to put in the email is directly shown on the form, then you can refer to the text box in your email template in the vba.

stBody = "Hello " & me.txtFirstName & ",<br><br>" & _
                 "Here are the results for " & me.txtRegion & ". As you can see, for " & me.txtCity & " we had " & me.txtQuantity & " in storage..... " & _
                 "...... <br><br>" & _
                 "If you have any questions, please let me know.<br><br> " & _
                 "Thank you,<br>"

If you are doing multiple emails, then you would use a recordset and loop through it to populate the email text

 

[stu_c]

might be easier way, can everything that is displayed on a the report layout be show in the body of an Email including tables etc rather than a attachment?