Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
K. Walker[_2_] K. Walker[_2_] is offline
external usenet poster
 
Posts: 2
Default Mail Merge to Email with Attachments. Help with D. Robbins' artic

I have reviewed the different responses to the issue of including attachments
in a mail merge and have tried the steps in Doug Robbins article. I never
get the table mentioned in the article. These are the steps Ive taken:

1. In VBA, I chose Tools References... Then I clicked Microsoft Outlook
12.0 Object Library. I went back to make sure there was still a check mark
and of course there was.

2. Then I started my merge document and choose "Directory" as the type. I
continued creating the merge document as usual and never saw the table, even
after merging to the directory document.

If I understand correctly I don't run the Macro until after step two. I
never get to this step because I never get the table. What am I doing wrong?
I've tried it with Office 2002 and 2007.

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default Mail Merge to Email with Attachments. Help with D. Robbins' artic

2. Then I started my merge document and choose "Directory" as the type. I
continued creating the merge document as usual and never saw the table,
even
after merging to the directory document.


Suppose you want the same attachment for each merge. Then in your mail merge
main document in the "Setup" phase, you need to create a one-row, two column
table (i.e. so you have two cells).

In the first cell, put the mergefield that gets the e-mail address from the
data source.

In the second cell, put the pathname of the attachment.

Don't put anything else in the mail merge main document (no extra paragraph
marks before or after the table).

Do the merge, and you should end up with a table.

Your case may be more complicated if you have variable attachments or more
attachments per merge, but that's the general idea.

Peter Jamieson
"K. Walker" wrote in message
...
I have reviewed the different responses to the issue of including
attachments
in a mail merge and have tried the steps in Doug Robbins article. I
never
get the table mentioned in the article. These are the steps Ive taken:

1. In VBA, I chose Tools References... Then I clicked Microsoft Outlook
12.0 Object Library. I went back to make sure there was still a check
mark
and of course there was.

2. Then I started my merge document and choose "Directory" as the type. I
continued creating the merge document as usual and never saw the table,
even
after merging to the directory document.

If I understand correctly I don't run the Macro until after step two. I
never get to this step because I never get the table. What am I doing
wrong?
I've tried it with Office 2002 and 2007.


  #3   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 Mail Merge to Email with Attachments. Help with D. Robbins' artic

And another piece of advice, you must follow the instructions exactly if you
want to achieve the desired result. Also, the filepath\name(s) that you
either have in your data source or enter directly in the the Directory type
mail merge main document if it is a fixed attachment MUST be match exactly
that of the file(s) that you want to attach. Just one extra space will
prevent the file from being attached.

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

"Peter Jamieson" wrote in message
...
2. Then I started my merge document and choose "Directory" as the type.
I
continued creating the merge document as usual and never saw the table,
even
after merging to the directory document.


Suppose you want the same attachment for each merge. Then in your mail
merge main document in the "Setup" phase, you need to create a one-row,
two column table (i.e. so you have two cells).

In the first cell, put the mergefield that gets the e-mail address from
the data source.

In the second cell, put the pathname of the attachment.

Don't put anything else in the mail merge main document (no extra
paragraph marks before or after the table).

Do the merge, and you should end up with a table.

Your case may be more complicated if you have variable attachments or more
attachments per merge, but that's the general idea.

Peter Jamieson
"K. Walker" wrote in message
...
I have reviewed the different responses to the issue of including
attachments
in a mail merge and have tried the steps in Doug Robbins' article. I
never
get the table mentioned in the article. These are the steps I've taken:

1. In VBA, I chose Tools References... Then I clicked Microsoft
Outlook
12.0 Object Library. I went back to make sure there was still a check
mark
and of course there was.

2. Then I started my merge document and choose "Directory" as the type.
I
continued creating the merge document as usual and never saw the table,
even
after merging to the directory document.

If I understand correctly I don't run the Macro until after step two. I
never get to this step because I never get the table. What am I doing
wrong?
I've tried it with Office 2002 and 2007.




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
Doug Robbins Merge with Attachments Theresa Pistochini Mailmerge 2 April 9th 07 10:54 PM
mail merge-email with attachments Michelle Hanan Mailmerge 1 February 16th 07 10:07 PM
ATTN: Doug Robbins Mail Merge with Attachments Brandon La Sage - VBA Programmer Microsoft Word Help 2 January 16th 07 08:31 PM
Mail Merge to Email with Attachments plus varied body text sjSQW Mailmerge 2 November 20th 06 02:34 PM
mail merge for email with attachments bwilli Mailmerge 3 March 20th 06 09:01 PM


All times are GMT +1. The time now is 09:00 PM.

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

About Us

"It's about Microsoft Word"