from Access, via Word to Outlook as attachment

  • Thread starter Thread starter JohS
  • Start date Start date
J

JohS

Hi.

Anyone who has a link to a VBA code sample which from Access are doing:

sending field values into a Word.doc file (using bookmarks) and attach the
Word document into an Outlook Email (which then has filled in its email
address). (Have tried to search for code but always end up with either only
Access to Word or Word to Outlook). Thanks
 
Hi.

Anyone who has a link to a VBA code sample which from Access are doing:

sending field values into a Word.doc file (using bookmarks) and attach the
Word document into an Outlook Email (which then has filled in its email
address). (Have tried to search for code but always end up with either only
Access to Word or Word to Outlook). Thanks
Click to expand...

There are two separate processes going on here.
1. Access to Word - (filling in bookmarks with data from Access.
2. Attaching document to an Outlook Message.

msg.Attachments.Add("C:\someDir\MyFile.doc")

I'm pretty sure there's an example of sending attachments through
Outlook at www.amazecreations.com
Go to the development/database part, and it's in there.
 
Back
Top