[Doug Robbins - Word MVP]

From what you have written in earlier messages, you changed the mailmerge
that contains the information that you want to appear in the body or each
e-mail message into a Directory Type Mail Merge. I told you that you
should not do that and that that mailmerge MUST REMAIN AS A FORMLETTER TYPE.

You are going wrong because you do not read and follow the instructions
precisely.

--
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" wrote in message
...
Hi Robbins,

Thanks for replying back and for your patience with me.

But as I had mentioned in my last reply I have saved the macro in the
"Normal.Doc" file which is the default file to treat any macro as an
add-in.
Also I have ensured that the New doc which gets generated after using mail
merge is active. I have again tried it and I am still facing the same
problem.

I don't know where I am going wrong, I have read the article again and
again
to see if I have missed out any thing but there is nothing which i can
think
of.

--
Regards,
Pranay Shah


"Doug Robbins - Word MVP" wrote:

Please read my response to your message of yesterday. Also you need to
re-read the article and follow the steps exactly.

The macro should probably be stored in the normal.dot template or in a
template that you store in the Word Startup directory so that it is
treated
as an addin.

--
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" wrote in message
...
Hi,

I have been trying to use mail merge with attachment with the help of
the
macro given in the link as mentioned below:-

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

But everytime run this macro it is not copying the mail contents from
the
mail merge template which i have prepared instead it simply sends a
blank
mail with the attachment.

I have followed folowing steps, please let me know where am I going
wrong.
1. Create the mail merge template and save it.
2. Create a new word file with Email address and Attachment path
mentioned
in it and then close it after saving.
3. Write the entire macro in the mail merge template created earlier.
(I
have tried saving it in the "Normal.Doc" file also).
4. Add references for Outlook library.
5. Run pass the complete process of mail merge by selecting Email or
Directory option and create a new document with the individual mail in
each
page.
6. Now go to that new document and run the macro.
7. Click "Yes" everytime it asks for sednign out the mail.
8. Macro ends and all files are closed automatically except the file
which
has got the email and attachment details.

After doing all this the mail which is being sent is without any
content
and
only the attachement is attached.

It would be of great help if you can help me out with this as I have
send
lot's of mails with different attachements to different people.

Thanks in advance.

Regards,
Pranay Shah

"Pranay Shah" wrote:

Hi,

I have a very small doubt, exactly where do we save the macro, I mean
do
I
have to save the macro in the "Normal.Doc" file or in the mail merge
template
which i have prepared. Or is it that I have save it in some other file
altogether.

Thanks
--
Regards,
Pranay Shah


"Doug Robbins - Word MVP" wrote:

You have not followed the instructions. It would appear that you
have
execute the macro when you have the mail merge main document as the
active
document, rather than a document created by executing the merge of
that
main
document to a new document.

--
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" wrote in
message
...
Hi,

I tried the method mentioned in the article mentioned by you but
now
the
attachment is being mailed but with a blank email ie it doesnot
copy
the
contents of the mail merge document which i have prepared.

If can please let me know the steps to followed that would be of
gr8
help.

Thanks.
--
Regards,
Pranay Shah


"Graham Mayor" wrote:

See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm


--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


Pranay Shah wrote:
Hi All,

I am using mail merge to send emails to send a number of people
but I
am facing 2 problems :-

1. How to attach a Excel file for each of the mails.
2. How to add subject line while using mail merge.

Thanks.