Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Word doc email attachments from Access

Status
Not open for further replies.

Legion6789

Programmer
Jun 11, 2007
2
I'm generating a series of emails and sending them in outlook from access. The emails will be blank but have a word doc for an attachment with some data from the access db. I know how to create a word doc, and I know how to create an email and attach a file. What I'm wondering is, is there a way to create the word doc attachment on the fly without saving it to the hard drive and attach it to the email. Basically, when I send out say 300 emails to people listed in the database, I don't want to have 300 word docs sitting on my hard drive afterward. Is there a way to do this?
 
Why not include the data in the email? It is less likely to be blocked by mail servers. I cannot see anyway to send a word attachment without saving it. You can delete the file after sending (Kill) or you can use Word to automate a mailmerge.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top