Access Email, one record in body of email

[Guest]

i'm using Access 2007 and we email an outside company when we have a customer
with a problem. i would like to streamline this process and have a link on my
form to open outlook (that part is easy) and insert the current record in the
body of the email (not an attachment, and not all the records just the record
in my split form that i'm currently viewing)

 

[Guest]

i'm using Access 2007 and we email an outside company when we have a customer
with a problem. i would like to streamline this process and have a link on my
form to open outlook (that part is easy) and insert the current record in the
body of the email (not an attachment, and not all the records just the record
in my split form that i'm currently viewing)

not that sure if it matters but we are using outlook 2003 with access 2007
apreciate any help

 

[Tony Toews [MVP]]

i'm using Access 2007 and we email an outside company when we have a customer
with a problem. i would like to streamline this process and have a link on my
form to open outlook (that part is easy) and insert the current record in the
body of the email (not an attachment, and not all the records just the record
in my split form that i'm currently viewing)

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.htm.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm