Add attachment to e-mail Mail merge

Hi,

I have also tried this macro and it is still not working let me know wher I
am going wrong, here are the steps followed by me:-

1. Open the word file and save the email address and the attachement path
against each name.
2. Close the file after saving it.
3. Open the template for mail merge and select the "Directory" Option
4. Apart from the save the macro in this file.
5. After going thru the entire mail merge process it creates a new doc with
each page representing each person in the database.
6. Run the macro
7. Select the word file where we have saved the email and path
8. Provide a subjetc line
9. Keep clicking "yes"

After doing this outlook does send a email but it is blank email with only
the attachement with it.

Please tell me where am I going wrong.

Thanks.
--
Regards,
Pranay Shah


"Doug Robbins - Word MVP" wrote:

> 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.DeleteThis@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.
>
>
>

It sounds like you have changed to type of the mail merge main document that
forms the message that will be sent to each recipient into a directory type
mail merge main document and then you have executed that merge to a new
document. That is not correct. That main document must remain as a
formletter type main document. You need to create a new Directory type mail
merge main document that uses the same data source and execute that to a new
document, then save and close it and then with the document created by
executing the Formletter type merge as the active document, you then run the
maco.

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

"Pranay Shah" <PranayShah.TakeThisOut@discussions.microsoft.com> wrote in message
news:66FD8F78-AD05-4DA1-89FF-49DA1674DB93@microsoft.com...
> Hi,
>
> I have also tried this macro and it is still not working let me know wher
> I
> am going wrong, here are the steps followed by me:-
>
> 1. Open the word file and save the email address and the attachement path
> against each name.
> 2. Close the file after saving it.
> 3. Open the template for mail merge and select the "Directory" Option
> 4. Apart from the save the macro in this file.
> 5. After going thru the entire mail merge process it creates a new doc
> with
> each page representing each person in the database.
> 6. Run the macro
> 7. Select the word file where we have saved the email and path
> 8. Provide a subjetc line
> 9. Keep clicking "yes"
>
> After doing this outlook does send a email but it is blank email with only
> the attachement with it.
>
> Please tell me where am I going wrong.
>
> Thanks.
> --
> Regards,
> Pranay Shah
>
>
> "Doug Robbins - Word MVP" wrote:
>
>> 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.TakeThisOut@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.
>>
>>
>>