ATTN: Doug Robbins Mail Merge with Attachments

[Brandon La Sage - VBA Programmer]

Mr. Dough Robbins:

It has come to my attention that I am doing something terribly wrong,
or my machine is not compliant to my demands. Here's the case

I am using Outlook 2000 and I am using your instructions exactly as
they are stated in your MVP whitepages for Mail Merge Attachments. The
problem is that the attachment is not appearing at all. All I get is
the email with content sent to the correct people. The attachments are
bipassed. Is there something I am doing wrong. I am typing the full
path of the file. As far as the data source, I am referencing my
contacts list in outlook for the email addresses. Should I be
referencing the path's also; and if so, how do I go about that.

My procedure:
1) Open word and create table
2) Tools>>Mail Merge>>Catalog
3) Merge to New Document and Save and Close
4) Open up new Word Document
5) Create Mail Merge with email content
6) Save
7) Run emailmergewithattachments()
8) Get mad because attachments are not present but emails have been
delivered to proper recipients.

If you could please give me some suggestions as to what I should do to
ammend this problem, it would be greatly appreciated.

Thanks,
Brandon

 

[Doug Robbins - Word MVP]

Did you execute the merge of the document that you created in your step 5 to
a new document and was that document the active document when you executed
the macro.

Aside from that, are you one hundred percent sure that the path\file names
in the catalog merge document are correct. Just one additional space
somewhere will cause the attachment to be missed.

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

 

[Brandon La Sage - VBA Programmer]

As I've stated earlier your code works perfect. The way outlook is
setup through my company is a little different. I had to save the
module to the active document. Also, for some reason I was getting
double file extensions such as TEST.txt.txt and ATAR.pdf.pdf. Thank
you! This makes my life so much easier.

Thank you!
Have a nice day!

-->Brandon