Mail Merge with Attachements - Exchange server

[Ivan Woyno]

Hello,

I am currently trying to utilize the attached process to create a mail merge out of MS word with attachments.

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

I was able to finally get past the Outlook Object Library problem discussed here and the macro asks me for the table with e-mails and attachments, however, I do not receive an email warning message and after a few seconds the screens comes up with a text box that states:

Microsfot Word
0 Messages have been sent.

On the Directory (titled dir1) I have a table with three rows and two columns
Column one: email address
Column two: attachment path

Nothing appears to fail, it just doesn't seem to send out the e-mail.

Outlook is connected to the exchange server but I am not sure if this is a problem or if there is language that I should be adding to the macro in order to work from the exchange server.

Any feedback would be greatly appreciated, specially since this would save me countless hours of work, headaches and frustration..

Ivan

EggHeadCafe - Software Developer Portal of Choice
Excel Interactive Tab Selection And Display
http://www.eggheadcafe.com/tutorial...a-0bc1b957e707/excel-interactive-tab-sel.aspx

 

[Doug Robbins - Word MVP]

It sounds like you have failed to execute the merge of the document that is
to become the text in the body of each of the email messages. You must
execute the merge of that document to a New Document and then with that New
Document as the active document, you run the macro.

--
Hope this helps,

Doug Robbins - Word MVP

Please reply only to the newsgroups unless you wish to obtain my services on
a paid professional basis.
in message
news:[email protected]...

 

[Ivan Woyno]

Thank you Doug,

I knew I was missing a step but I could not figure out what it was.

After making the adjustment I ran the macro and sent out the individualized files without a problme!

You are the best Doug!

Thank you for your help!

Ivan



Doug Robbins - Word MVP wrote:

It sounds like you have failed to execute the merge of the document that isto
12-Nov-09

It sounds like you have failed to execute the merge of the document that i
to become the text in the body of each of the email messages. You mus
execute the merge of that document to a New Document and then with that Ne
Document as the active document, you run the macro

-
Hope this helps

Doug Robbins - Word MV

Please reply only to the newsgroups unless you wish to obtain my services o
a paid professional basis
in message

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
Binary Data With SQLite and its ADO.NET Provider
http://www.eggheadcafe.com/tutorial...5-ef5f14776faa/binary-data-with-sqlite-a.aspx