E-Mailing Attachments Office/Word 2007

Office 2007 up to date

Concerning your VBA on MVPS : http://www.word.mvps.org/FAQs/Mailmerge/mergewithattachments.htm

Your text states:

"Save that file and close it. When you run the macro that is provided below, you will be asked to
open that document, so remember the name that you have given to it and where you saved it.

Then execute to a new document the mail merge that you want to send out by email with the
attachments and with the result of the execution of that mail merge on the screen, run a macro
containing the following code. (This code is designed to be pasted into the VBA Editor: it is much
easier to read if you do that!)"

I have installed the macro in Word VBA editor.

I start in Word - the document I wish to email.
Then I merge above with my original Source data document (all is well at this point)
If I run your macro at this point it fails ( -0- Emails sent)

Would you please be a bit more explicit about exactly when to run the macro?

Specifically the phrase: "Then execute to a new document the mail merge that you want to send out by
email with the attachments and with the result of the execution of that mail merge on the screen"

Obviously, I have the sequence or the objects wrong.

I assume that the document-I-wish-to-email is to be open and merged (?) and that the macro opens up
the Directory file created previously (?)

All that said I get -0- and no alert warning message is displayed.

Can you help?

TIA EagleOne




"Doug Robbins - Word MVP" <dkr RemoveThis @REMOVECAPSmvps.org> wrote:

>See http://support.microsoft.com/default.aspx/kb/918792

Execute the merge of the Directory type mail merge main document to a new
document. Then save and close that document, which for reference purposes
we will call Document 1. You then need to open the mailmerge main document
that contains the text that will become the body of the email messages. You
must then execute that merge of that document to a new document, which we
will call Document 2. Document 2 will contain as many copies of the text
for the body of the email messages as you have records in your data source.
With Document 2 as the active document (i.e. on the screen), you then
execute the macro. The macro will display a dialog that allows you to
select and open Document 1. When you do that, the rest of the code in the
macro will run and provided that you have followed the instructions to the
letter, the email messages will be sent with the attachments that you listed
for each message in Document 1.

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

<EagleOne RemoveThis @discussions.microsoft.com> wrote in message
news:tg94o4htsf0m2n1dmk51m6pbrhp66n6kui@4ax.com...
> Office 2007 up to date
>
> Concerning your VBA on MVPS :
> http://www.word.mvps.org/FAQs/Mailmerge/mergewithattachments.htm
>
> Your text states:
>
> "Save that file and close it. When you run the macro that is provided
> below, you will be asked to
> open that document, so remember the name that you have given to it and
> where you saved it.
>
> Then execute to a new document the mail merge that you want to send out by
> email with the
> attachments and with the result of the execution of that mail merge on the
> screen, run a macro
> containing the following code. (This code is designed to be pasted into
> the VBA Editor: it is much
> easier to read if you do that!)"
>
> I have installed the macro in Word VBA editor.
>
> I start in Word - the document I wish to email.
> Then I merge above with my original Source data document (all is well at
> this point)
> If I run your macro at this point it fails ( -0- Emails sent)
>
> Would you please be a bit more explicit about exactly when to run the
> macro?
>
> Specifically the phrase: "Then execute to a new document the mail merge
> that you want to send out by
> email with the attachments and with the result of the execution of that
> mail merge on the screen"
>
> Obviously, I have the sequence or the objects wrong.
>
> I assume that the document-I-wish-to-email is to be open and merged (?)
> and that the macro opens up
> the Directory file created previously (?)
>
> All that said I get -0- and no alert warning message is displayed.
>
> Can you help?
>
> TIA EagleOne
>
>
>
>
> "Doug Robbins - Word MVP" <dkr RemoveThis @REMOVECAPSmvps.org> wrote:
>
>>See http://support.microsoft.com/default.aspx/kb/918792