Add attachment to e-mail Mail merge

Thanks a lot Doug,

I will try this today!



"Doug Robbins - Word MVP" wrote:

> See the article "Mail Merge to E-mail with Attachments" at
>
> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.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
>
> "Lion" <Lion RemoveThis @discussions.microsoft.com> wrote in message
> news:17E041F3-5543-43E6-9E6B-C32CA76B43D0@microsoft.com...
> > Hello,
> > Does anybody know how to add an attachment to a mail merge e-mail from
> > Word
> > (2007)? I have to send a message to about 45 recipients, giving them a
> > personalized username/password and at the same time I want to add a manual
> > as
> > a (.pdf) attachment.
> > The username, password and email address are found in a (excel)file.
> > When I complete the mail merge, I don't have the opportunity to add an
> > attachment.
> > If this is not possible from Word, do you know a way to work around this?
> > (To me this looks like something that is done more often).
> > Thanks in advance.
>
>
>

Lion;

Did this work? I have the same problem exactly as you have described. I
sent out a personalized letter each week to over 300 people and would like to
add a PDF file as an attachment, but 2007 gives no option to do so. Please
advise.
--
George Mancuso
President
Gman Business Resources


"Lion" wrote:

> Hello,
> Does anybody know how to add an attachment to a mail merge e-mail from Word
> (2007)? I have to send a message to about 45 recipients, giving them a
> personalized username/password and at the same time I want to add a manual as
> a (.pdf) attachment.
> The username, password and email address are found in a (excel)file.
> When I complete the mail merge, I don't have the opportunity to add an
> attachment.
> If this is not possible from Word, do you know a way to work around this?
> (To me this looks like something that is done more often).
> Thanks in advance.

See the article "Mail Merge to E-mail with Attachments" at

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

It works with Word 2007 as well.

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

"George Mancuso" <GeorgeMancuso.RemoveThis@discussions.microsoft.com> wrote in message
news:88C28B1B-77B8-4537-9457-99A7CD01CE1E@microsoft.com...
> Lion;
>
> Did this work? I have the same problem exactly as you have described. I
> sent out a personalized letter each week to over 300 people and would like
> to
> add a PDF file as an attachment, but 2007 gives no option to do so.
> Please
> advise.
> --
> George Mancuso
> President
> Gman Business Resources
>
>
> "Lion" wrote:
>
>> Hello,
>> Does anybody know how to add an attachment to a mail merge e-mail from
>> Word
>> (2007)? I have to send a message to about 45 recipients, giving them a
>> personalized username/password and at the same time I want to add a
>> manual as
>> a (.pdf) attachment.
>> The username, password and email address are found in a (excel)file.
>> When I complete the mail merge, I don't have the opportunity to add an
>> attachment.
>> If this is not possible from Word, do you know a way to work around this?
>> (To me this looks like something that is done more often).
>> Thanks in advance.

Hello George,

I have not yet followed the procedure as described in the link.
Out of lack of time, I sent 2 seperate emails (one with the username /
password and the other with the attachment).
As soon as I have tryed it, I'll let you know!


"George Mancuso" wrote:

> Lion;
>
> Did this work? I have the same problem exactly as you have described. I
> sent out a personalized letter each week to over 300 people and would like to
> add a PDF file as an attachment, but 2007 gives no option to do so. Please
> advise.
> --
> George Mancuso
> President
> Gman Business Resources
>
>
> "Lion" wrote:
>
> > Hello,
> > Does anybody know how to add an attachment to a mail merge e-mail from Word
> > (2007)? I have to send a message to about 45 recipients, giving them a
> > personalized username/password and at the same time I want to add a manual as
> > a (.pdf) attachment.
> > The username, password and email address are found in a (excel)file.
> > When I complete the mail merge, I don't have the opportunity to add an
> > attachment.
> > If this is not possible from Word, do you know a way to work around this?
> > (To me this looks like something that is done more often).
> > Thanks in advance.

Doug --

I've tried your Macro.

I can see where it would work if the email being sent to folks is identical,
but we're wanting to send individualized emails out to folks all with the
same attachment.

When I tried following your instructions and completed my merge on the
second document then executed the macro, it successfully sent the first email
with attachment but all other recipients received a blank email with the
attachment.

What am I doing wrong?

Thanks,

Paul


"Doug Robbins - Word MVP" wrote:

> See the article "Mail Merge to E-mail with Attachments" at
>
> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.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
>
> "Lion" <Lion.RemoveThis@discussions.microsoft.com> wrote in message
> news:17E041F3-5543-43E6-9E6B-C32CA76B43D0@microsoft.com...
> > Hello,
> > Does anybody know how to add an attachment to a mail merge e-mail from
> > Word
> > (2007)? I have to send a message to about 45 recipients, giving them a
> > personalized username/password and at the same time I want to add a manual
> > as
> > a (.pdf) attachment.
> > The username, password and email address are found in a (excel)file.
> > When I complete the mail merge, I don't have the opportunity to add an
> > attachment.
> > If this is not possible from Word, do you know a way to work around this?
> > (To me this looks like something that is done more often).
> > Thanks in advance.
>
>
>

The mail merge that produces the individualised letters must be executed
with the destination being a new document and then the macro must be run
when that new document (the one containing each of the individual letters)
is the active document. It sounds like you have run the macro when you are
perhaps previewing the results of the mail merge and have not actually
executed it.

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

"Paul Williford" <Paul Williford.RemoveThis@discussions.microsoft.com> wrote in message
news:11FC8947-6A59-47CC-809D-EF7A6EE86A4F@microsoft.com...
> Doug --
>
> I've tried your Macro.
>
> I can see where it would work if the email being sent to folks is
> identical,
> but we're wanting to send individualized emails out to folks all with the
> same attachment.
>
> When I tried following your instructions and completed my merge on the
> second document then executed the macro, it successfully sent the first
> email
> with attachment but all other recipients received a blank email with the
> attachment.
>
> What am I doing wrong?
>
> Thanks,
>
> Paul
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> See the article "Mail Merge to E-mail with Attachments" at
>>
>> http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.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
>>
>> "Lion" <Lion.RemoveThis@discussions.microsoft.com> wrote in message
>> news:17E041F3-5543-43E6-9E6B-C32CA76B43D0@microsoft.com...
>> > Hello,
>> > Does anybody know how to add an attachment to a mail merge e-mail from
>> > Word
>> > (2007)? I have to send a message to about 45 recipients, giving them a
>> > personalized username/password and at the same time I want to add a
>> > manual
>> > as
>> > a (.pdf) attachment.
>> > The username, password and email address are found in a (excel)file.
>> > When I complete the mail merge, I don't have the opportunity to add an
>> > attachment.
>> > If this is not possible from Word, do you know a way to work around
>> > this?
>> > (To me this looks like something that is done more often).
>> > Thanks in advance.
>>
>>
>>