Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pranay Shah Pranay Shah is offline
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default 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:
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.



  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pranay Shah Pranay Shah is offline
external usenet poster
 
Posts: 5
Default Attaching a Excel File in the mail merge and adding Sub. line

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.




  #4   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 and adding Sub. line

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.






  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pranay Shah Pranay Shah is offline
external usenet poster
 
Posts: 5
Default Attaching a Excel File in the mail merge and adding Sub. line

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.








  #6   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pranay Shah Pranay Shah is offline
external usenet poster
 
Posts: 5
Default Attaching a Excel File in the mail merge and adding Sub. line

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.






  #7   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 and adding Sub. line

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.








  #8   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Pranay Shah Pranay Shah is offline
external usenet poster
 
Posts: 5
Default Attaching a Excel File in the mail merge and adding Sub. line

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.









  #9   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 and adding Sub. line

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.











  #10   Report Post  
Posted to microsoft.public.word.mailmerge.fields
ashwini hande ashwini hande is offline
external usenet poster
 
Posts: 1
Default Attaching a Excel File in the mail merge

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


  #11   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Attaching a Excel File in the mail merge

The article you referenced gave the following link:


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


if you try to follow that, where do things go wrong?


Peter Jamieson

http://tips.pjmsn.me.uk

On 06/03/2010 08:16, ashwini hande wrote:
See the article prepared by fellow MVP Doug Robbins at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm

  #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


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Word/Excel Mail Merge drops every 21st line Sheri IS Mailmerge 2 July 11th 06 10:19 PM
Attaching different Excel files to emailed mail merge using merge. Pete Cuff Mailmerge 1 November 3rd 05 06:54 PM
attaching pdf file with main word document in mail merge Yadav Microsoft Word Help 2 August 13th 05 09:55 AM
Attaching PDF's (and more) for Word E-mail merge? IceTre Microsoft Word Help 2 July 27th 05 11:57 PM
attaching files with electronic mail merge Farida Mailmerge 1 April 6th 05 03:44 PM


All times are GMT +1. The time now is 05:15 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"