[Michelle Hanan]

I have a macro that is in an excel worksheet. The macro merges data from the
worksheet into word documents and then merges the finished product to the
printer. Right now I am trying to set up a new macro that instead of merging
it to the printer, it merges to email. The catchup is that I need to also
add a mergefield that adds attatchments to the email. I am stuck. I put a
mergefield in the word document and added the field to the worksheet, but
it's not pulling anything when I just go through the mail merge toolbar
buttons. Any help would be great. Thanks!

[Peter Jamieson]

Using the out-of-the-box facilities, you can merge to email using a plain
text or HTML body and no atttachments, or with a completely blank message
with an attachment, but not both.

For a method of e-mailing with attachments, see Doug Robbins' article at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

Peter Jamieson



"Michelle Hanan" wrote in message
...
I have a macro that is in an excel worksheet. The macro merges data from
the worksheet into word documents and then merges the finished product to
the printer. Right now I am trying to set up a new macro that instead of
merging it to the printer, it merges to email. The catchup is that I need
to also add a mergefield that adds attatchments to the email. I am stuck. I
put a mergefield in the word document and added the field to the worksheet,
but it's not pulling anything when I just go through the mail merge toolbar
buttons. Any help would be great. Thanks!

[Michelle Hanan]

So far I have an email field that sends the document fine....but is there
any way to stop the email before it is sent so I can add an attachment that
way?

"Peter Jamieson" wrote in message
...
Using the out-of-the-box facilities, you can merge to email using a plain
text or HTML body and no atttachments, or with a completely blank message
with an attachment, but not both.

For a method of e-mailing with attachments, see Doug Robbins' article at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

Peter Jamieson



"Michelle Hanan" wrote in message
...
I have a macro that is in an excel worksheet. The macro merges data from
the worksheet into word documents and then merges the finished product to
the printer. Right now I am trying to set up a new macro that instead of
merging it to the printer, it merges to email. The catchup is that I need
to also add a mergefield that adds attatchments to the email. I am stuck.
I put a mergefield in the word document and added the field to the
worksheet, but it's not pulling anything when I just go through the mail
merge toolbar buttons. Any help would be great. Thanks!

[Peter Jamieson]

The only way I know that's likely to work is to set Outlook so it does not
send, do the merge, open each e-mail in the Outbox, add the attachment, then
eventually re-enable Outlook so it sends. I don't know of a way that lets
you interrupt a merge to email - you would have to do /something along the
general lines/ of the code in Doug's article to do that.

Peter Jamieson


"Michelle Hanan" wrote in message
...
So far I have an email field that sends the document fine....but is there
any way to stop the email before it is sent so I can add an attachment
that way?

"Peter Jamieson" wrote in message
...
Using the out-of-the-box facilities, you can merge to email using a plain
text or HTML body and no atttachments, or with a completely blank message
with an attachment, but not both.

For a method of e-mailing with attachments, see Doug Robbins' article at

http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

Peter Jamieson



"Michelle Hanan" wrote in message
...
I have a macro that is in an excel worksheet. The macro merges data from
the worksheet into word documents and then merges the finished product to
the printer. Right now I am trying to set up a new macro that instead of
merging it to the printer, it merges to email. The catchup is that I need
to also add a mergefield that adds attatchments to the email. I am stuck.
I put a mergefield in the word document and added the field to the
worksheet, but it's not pulling anything when I just go through the mail
merge toolbar buttons. Any help would be great. Thanks!