mungwap
asked on
Mail Merge with an Atthachment
Is it posible to do a mail merge with an attachment? If so, how would i go about doing it? I am using Outlook 2003...
I have an email that i needed to send about to alot of people and i want to attach a document to that email????
I have an email that i needed to send about to alot of people and i want to attach a document to that email????
shivsa
insert-> file in outlook toolbar will add the document
Insert-File will add the attachment for all emails.
If you want to add an attachment in code you would use
.attachments.add("C:\TEST.
If you want to add an attachment in code you would use
.attachments.add("C:\TEST.
Hi mungwap
This appears to be a good walkthrough: http://www.mvps.org/word/FAQs/MailMerge/MergeWithAttachments.htm
Or you may want to look here http://www.slipstick.com/addins/mail.htm#massmail for some third party tools.
This appears to be a good walkthrough: http://www.mvps.org/word/FAQs/MailMerge/MergeWithAttachments.htm
Or you may want to look here http://www.slipstick.com/addins/mail.htm#massmail for some third party tools.
ASKER
I said earlier that i am working in Outlook 2003...i am actually working in Word 2003.
If i say Insert-File it puts the document or picture into Word document that i am working in...what i actually want it to do is when i send the email it send that doc or picture as an attachment, i dont want it in the document i working in....i hope that makes sense!
Where would i add that code?
If i say Insert-File it puts the document or picture into Word document that i am working in...what i actually want it to do is when i send the email it send that doc or picture as an attachment, i dont want it in the document i working in....i hope that makes sense!
Where would i add that code?
You need to use VBA programming and the line I gave you to accomplish this.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.