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