View Single Post
  #12   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Attaching a Excel File in the mail merge

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, originally posted via msnews.microsoft.com

"ashwini hande" wrote in message ...
how to attach excel file in mail marge pls give me staps



PranaySha wrote:

Attaching a Excel File in the mail merge and adding Sub. line in E
22-Aug-07

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.
--
Regards,
Pranay Shah

Previous Posts In This Thread:

On Wednesday, August 22, 2007 3:40 AM
PranaySha wrote:

Attaching a Excel File in the mail merge and adding Sub. line in E
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.
--
Regards,
Pranay Shah

On Wednesday, August 22, 2007 4:07 AM
Graham Mayor wrote:

Attaching a Excel File in the mail merge and adding Sub. line in E
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:

On Wednesday, August 22, 2007 7:52 AM
PranaySha wrote:

Hi,I tried the method mentioned in the article mentioned by you but now
the
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:

On Wednesday, August 22, 2007 3:39 PM
Doug Robbins - Word MVP wrote:

You have not followed the instructions.
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
...

On Thursday, August 23, 2007 2:20 AM
PranaySha wrote:

Hi,I have a very small doubt, exactly where do we save the macro, I mean
do I
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:

On Thursday, August 23, 2007 4:54 AM
PranaySha wrote:

Hi, I have been trying to use mail merge with attachment with the help of
the
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:

On Thursday, August 23, 2007 5:00 AM
Doug Robbins - Word MVP wrote:

Please read my response to your message of yesterday.
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
...

On Thursday, August 23, 2007 6:12 AM
PranaySha wrote:

Hi Robbins,Thanks for replying back and for your patience with me.
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:

On Thursday, August 23, 2007 3:22 PM
Doug Robbins - Word MVP wrote:

From what you have written in earlier messages, you changed the mailmerge
that
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
...


Submitted via EggHeadCafe - Software Developer Portal of Choice
DataContractSerializer Basics
http://www.eggheadcafe.com/tutorials...alizer-ba.aspx