Email Merge with Attachments Being Overwritten

[Gixxer750]

I've been successfully using Doug Robbin's macro to send email merges with
attachments, but I've run into a problem when I send more than 1 attachment.
It looks like only the last attachment gets sent -- almost like my Word
document isn't set up properly and the first attachment is being overwritten.

Has anyone ever had this issue before, and can you suggest a fix -- thanks.

 

[Doug Robbins - Word MVP]

I have used the method to send multiple attachments. Are you sure that the
file path\names are correct (INDENTICAL)?

What is the layout of the catalog or directory type merge document that
contains the email addresses in the first column and needs to include a
column for each attachment.?

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

 

[Gixxer750]

The filenames/path were different and correct.

After more testing, I found when I changed my email preference to HTML from
Rich Text, both files were indeed being sent out. For some reason, I could
not see both attachments in my "Sent Items" log under Rich Text format.

Thank you for the prompt reply and great macro. It's a huge time saver.