Jegajothy vythilingam
asked on
Word 2007 - mail merge - attaching a MP3 file
My OS is win 7 prof 64 bit and i use office 2007. i am doing a word document, using the mail merge feature to send an email to all reciepients from an Access database, thru an Access query. It is being sent thru Outlook 2007.
The Q is in the Word document that is being merged, how does one attach a file, like a MP3. If this is possible, and if yes, can the Experts please show me how. Thank u.
The Q is in the Word document that is being merged, how does one attach a file, like a MP3. If this is possible, and if yes, can the Experts please show me how. Thank u.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In response to finalword, thank u for your input, which is really very clever - gosh, a cute way of doing things.
But in the documentation i am stuck on how to do "run the script, 'outlook mail merge attachment.vbs' " which adds the attachment to all emails in the outbox.
I am sorry hope u could please help me in this, as this is the only missing link. Thank u.
But in the documentation i am stuck on how to do "run the script, 'outlook mail merge attachment.vbs' " which adds the attachment to all emails in the outbox.
I am sorry hope u could please help me in this, as this is the only missing link. Thank u.
ASKER
a genius solution, thank u. it works.
You should be able to just double click the .vbs file and it should run. Here is a link to site the gives you mulitple ways to run it though:
http://www.visualbasicscri pt.com/Som e-methods- to-run-you r-script-m 62787.aspx
Happy I could help!
http://www.visualbasicscri
Happy I could help!
http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm
but it's going to depend on where the attachment/s is/are and whether you want to send the same one or a different one to each recipient.