from Access, via Word to Outlook as attachment

[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

 

[pietlinden]

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

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.