Outlook email from Access

[Jay]

I am fairly new to Access & have set up a DB at work to log & track
customer enquiries.

However, I'd like to automate the sending of emails to staff about the
enquiries.

So, I have a table containing relevant fields: customer, enquiryID,
staff name, email address etc.

The emails will all have the same text other than the fields above. Can
Access automate the emails so that the email is produced containing the
fields above (as dictated by a form or query)?

If someone could refer me to a good on-line resource on how to do this,
or point me in the right direction I would really appreciate it.

Many thanks,

Jason

 

[Arvin Meyer [MVP]]

Have a look at my code to send email in Outlook:

http://www.datastrat.com/Code/OutlookEmail.txt

You can use it to send an attachment, or just write the data to the body of
the email:

..body = Me.Field1 & vbCrLf & Me.Field2 & vbCrLf & Me.Field3 ' etc
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com