Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge email w/ attachment
I need to use mail merge in Word to send an email with an attachment. I want
the text from Word to show up in the body of the email plus attach another document to the email. I have done this in Word 2003 but cannot figure out how to attach another file in Word 2007 ... how do i do this? Thanks |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge email w/ attachment
See the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JG" wrote in message ... I need to use mail merge in Word to send an email with an attachment. I want the text from Word to show up in the body of the email plus attach another document to the email. I have done this in Word 2003 but cannot figure out how to attach another file in Word 2007 ... how do i do this? Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge email w/ attachment
Hi,
I''ve tried to follow your instructions, but when I run the macro I get the message "compile error - user defined type not defined". I've made sure to check the outlook office library box in references. I'm pretty new to macros and I'd appreciate any help you could give me. Thanks, Jessi "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JG" wrote in message ... I need to use mail merge in Word to send an email with an attachment. I want the text from Word to show up in the body of the email plus attach another document to the email. I have done this in Word 2003 but cannot figure out how to attach another file in Word 2007 ... how do i do this? Thanks |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge email w/ attachment
Recheck again whether the Outlook Object Library still has a checkmark
against it. Almost certainly, that is the cause of the problem. When you click on Debug in the error message, what line of code is highlighted in yellow? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "jessi" wrote in message ... Hi, I''ve tried to follow your instructions, but when I run the macro I get the message "compile error - user defined type not defined". I've made sure to check the outlook office library box in references. I'm pretty new to macros and I'd appreciate any help you could give me. Thanks, Jessi "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JG" wrote in message ... I need to use mail merge in Word to send an email with an attachment. I want the text from Word to show up in the body of the email plus attach another document to the email. I have done this in Word 2003 but cannot figure out how to attach another file in Word 2007 ... how do i do this? Thanks |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge email w/ attachment
I'm attempting to run this macro, and I'm having a problem I can't figure
out, though, and I wondered if anyone could help me figure out what was wrong. Everything appears to run correctly. I set the data source to send 10 test messages to my e-mail address but with 10 different attachments - in other words, the data source has 10 rows of data, with one of my seven email addresses in that column for every row, and a different PDF file in the attachment column for every row. I went through the process of creating a 1-row table Directory mail merge to get the data, and then merged to a new document, which created (properly) a 10-row table. I saved this. I merged the original document to a new document and then ran the macro on that, and selected the 10-row table document I created earlier. But it's sending 20 messages instead of 10. It sends the first email message to the first address with the first PDF attached, and then a blank email to the second address with the second PDF attached. And then the 2nd message to the 3rd address with the 3rd PDF attached, and then a blank message to the 4th address with the 4th PDF attached. And so on and so forth, so that the last 11 messages (some blank, some with the mail merge text) all have the 10th PDF attached to them (and are also being sent to whatever the last e-mail is in the list), even if the text of the email doesn't correspond to the PDF/email address in my original data source. I've gone back and re-read the instructions about 10 times now, tweaking the data, doing the process over again from scratch, making sure I have done everything exactly right, and it seems to me that I have. Does anyone have any insight into what the problem might be? I'm using Office 2003. Thanks so much, Jen Ms. Jennifer Alluisi M.A.Ed. Program Director Director of Education Custom Management Group www.custommanagement.com "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JG" wrote in message ... I need to use mail merge in Word to send an email with an attachment. I want the text from Word to show up in the body of the email plus attach another document to the email. I have done this in Word 2003 but cannot figure out how to attach another file in Word 2007 ... how do i do this? Thanks |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge email w/ attachment
It sounds like you may have a superfluous Section Break in the mail merge
main document which is merged to create the text that appear in the email messages -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "jalluisi" wrote in message ... I'm attempting to run this macro, and I'm having a problem I can't figure out, though, and I wondered if anyone could help me figure out what was wrong. Everything appears to run correctly. I set the data source to send 10 test messages to my e-mail address but with 10 different attachments - in other words, the data source has 10 rows of data, with one of my seven email addresses in that column for every row, and a different PDF file in the attachment column for every row. I went through the process of creating a 1-row table Directory mail merge to get the data, and then merged to a new document, which created (properly) a 10-row table. I saved this. I merged the original document to a new document and then ran the macro on that, and selected the 10-row table document I created earlier. But it's sending 20 messages instead of 10. It sends the first email message to the first address with the first PDF attached, and then a blank email to the second address with the second PDF attached. And then the 2nd message to the 3rd address with the 3rd PDF attached, and then a blank message to the 4th address with the 4th PDF attached. And so on and so forth, so that the last 11 messages (some blank, some with the mail merge text) all have the 10th attached to them (and are also being sent to whatever the last e-mail is in the list), even if the text of the email doesn't correspond to the PDF/email address in my original data source. I've gone back and re-read the instructions about 10 times now, tweaking the data, doing the process over again from scratch, making sure I have done everything exactly right, and it seems to me that I have. Does anyone have any insight into what the problem might be? I'm using Office 2003. Thanks so much, Jen Ms. Jennifer Alluisi M.A.Ed. Program Director Director of Education Custom Management Group www.custommanagement.com "Doug Robbins - Word MVP" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "JG" wrote in message ... I need to use mail merge in Word to send an email with an attachment. I want the text from Word to show up in the body of the email plus attach another document to the email. I have done this in Word 2003 but cannot figure out how to attach another file in Word 2007 ... how do i do this? Thanks |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you add an attachment to a mail merge email? | Mailmerge | |||
How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
mail merge to email with attachment | Mailmerge | |||
How do I mail merge an email without loosing the attachment? | Mailmerge | |||
mail merge email attachment problems | Mailmerge |