Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / July 2006

Tip: Looking for answers? Try searching our database.

Problems with Mail Merge with Attachments

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tutley - 19 Jul 2006 15:49 GMT
I am trying to Mail Merge with Attachment.  I followed the instructions on
http://word.mvps.org/FAQS/MailMerge/MergeWithAttachments.htm.  

I set up the Excel Data Source page.  I have several columns (email,
attachment, name, contact, notes).  I use Word to create a template.  I use
Mail Merge to input the name and contact into the template.  I complete and
execute the mail merge.  I run the Macro and Word starts sending out the
emails with the attachments.  Looks like it is going great, but here is the
problem.

The name/contact and actual attachment do not match up.  In addition, the
last email does not have any text in the email, just an attachment.  It seems
like all the attachments are off by one (if that makes sense).  

Has anyone experienced this problem or have any suggestions on how I can fix
this?
Doug Robbins - Word MVP - 19 Jul 2006 19:45 GMT
You do not mention anywhere about creating the catalog or directory type
mail merge that is required by the procedure.  That catalog or directory
merge must be created from the same data source as the formletter type merge
that is used by the macro to obtain the text that is to appear in the body
of each email message.

If it is not working correctly for you, there is something that you have
done that is not one hundred percent correct.  There is no near enough is
good enough in this situation.

Signature

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

>I am trying to Mail Merge with Attachment.  I followed the instructions on
> http://word.mvps.org/FAQS/MailMerge/MergeWithAttachments.htm.
[quoted text clipped - 17 lines]
> fix
> this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.