Problems with Mail Merge with Attachments

[tutley]

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]

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.

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