[Doug Robbins - Word MVP]

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
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