Hello.

I am using the Visual Basic and the Microsoft Word 11.0 Object Library to
automate mail merge and send the output via email. I have almost everything
working. I used Microsoft's examples to figure out how to do this. I ran
the following example code right from
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:

With Documents("FormLetter.doc").MailMerge
.MailAddressFieldName = "Email"
.MailSubject = "Amazing offer"
.Destination = wdSendToEmail
.Execute
End With

...having filled in all the merge fields appropriately. Upon the .Execute
call, I get the following prompt:

"A program is trying to automatically send e-mail on your behalf.
Do you want to allow this? If this is unexpected, it may be a virus and you
should choose "No"."

I click "Yes" to allow the email. It APPEARS that it's working, but no
email is ever sent or received by any of the recipients. I assume that it's
using Outlook to send the email, and none of the messages ever appear in the
out box or in sent messages, and none are ever received.

Am I missing something?

Thanks for sitting there and reading this long email!

John

Re: Automating Mail Merge/Sending to Email by Jezebel

Jezebel
Tue Aug 23 17:49:55 CDT 2005

You need to clear the Outlook message cache before calling the mail
function. Insert this line immediately before the MailMerge statement:

Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"




"JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
> Hello.
>
> I am using the Visual Basic and the Microsoft Word 11.0 Object Library to
> automate mail merge and send the output via email. I have almost
> everything
> working. I used Microsoft's examples to figure out how to do this. I ran
> the following example code right from
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
>
> With Documents("FormLetter.doc").MailMerge
> .MailAddressFieldName = "Email"
> .MailSubject = "Amazing offer"
> .Destination = wdSendToEmail
> .Execute
> End With
>
> ...having filled in all the merge fields appropriately. Upon the .Execute
> call, I get the following prompt:
>
> "A program is trying to automatically send e-mail on your behalf.
> Do you want to allow this? If this is unexpected, it may be a virus and
> you
> should choose "No"."
>
> I click "Yes" to allow the email. It APPEARS that it's working, but no
> email is ever sent or received by any of the recipients. I assume that
> it's
> using Outlook to send the email, and none of the messages ever appear in
> the
> out box or in sent messages, and none are ever received.
>
> Am I missing something?
>
> Thanks for sitting there and reading this long email!
>
> John



Re: Automating Mail Merge/Sending to Email by JohnJohn

JohnJohn
Tue Aug 23 18:01:03 CDT 2005

Ummm...that's where a lot of application extensions, and WINWORD.EXE are,
among many other important files. You sure you got the right directory or
are you yanking my chain? :)

John

"Jezebel" wrote:

> You need to clear the Outlook message cache before calling the mail
> function. Insert this line immediately before the MailMerge statement:
>
> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
>
>
>
>
> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
> > Hello.
> >
> > I am using the Visual Basic and the Microsoft Word 11.0 Object Library to
> > automate mail merge and send the output via email. I have almost
> > everything
> > working. I used Microsoft's examples to figure out how to do this. I ran
> > the following example code right from
> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
> >
> > With Documents("FormLetter.doc").MailMerge
> > .MailAddressFieldName = "Email"
> > .MailSubject = "Amazing offer"
> > .Destination = wdSendToEmail
> > .Execute
> > End With
> >
> > ...having filled in all the merge fields appropriately. Upon the .Execute
> > call, I get the following prompt:
> >
> > "A program is trying to automatically send e-mail on your behalf.
> > Do you want to allow this? If this is unexpected, it may be a virus and
> > you
> > should choose "No"."
> >
> > I click "Yes" to allow the email. It APPEARS that it's working, but no
> > email is ever sent or received by any of the recipients. I assume that
> > it's
> > using Outlook to send the email, and none of the messages ever appear in
> > the
> > out box or in sent messages, and none are ever received.
> >
> > Am I missing something?
> >
> > Thanks for sitting there and reading this long email!
> >
> > John
>
>
>

Re: Automating Mail Merge/Sending to Email by Jezebel

Jezebel
Tue Aug 23 19:03:59 CDT 2005

Just try it. You'll be fine.



"JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
news:897994F1-9F41-45CD-A62A-DBE9B6F54011@microsoft.com...
> Ummm...that's where a lot of application extensions, and WINWORD.EXE are,
> among many other important files. You sure you got the right directory or
> are you yanking my chain? :)
>
> John
>
> "Jezebel" wrote:
>
>> You need to clear the Outlook message cache before calling the mail
>> function. Insert this line immediately before the MailMerge statement:
>>
>> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
>>
>>
>>
>>
>> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
>> > Hello.
>> >
>> > I am using the Visual Basic and the Microsoft Word 11.0 Object Library
>> > to
>> > automate mail merge and send the output via email. I have almost
>> > everything
>> > working. I used Microsoft's examples to figure out how to do this. I
>> > ran
>> > the following example code right from
>> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
>> >
>> > With Documents("FormLetter.doc").MailMerge
>> > .MailAddressFieldName = "Email"
>> > .MailSubject = "Amazing offer"
>> > .Destination = wdSendToEmail
>> > .Execute
>> > End With
>> >
>> > ...having filled in all the merge fields appropriately. Upon the
>> > .Execute
>> > call, I get the following prompt:
>> >
>> > "A program is trying to automatically send e-mail on your behalf.
>> > Do you want to allow this? If this is unexpected, it may be a virus and
>> > you
>> > should choose "No"."
>> >
>> > I click "Yes" to allow the email. It APPEARS that it's working, but no
>> > email is ever sent or received by any of the recipients. I assume that
>> > it's
>> > using Outlook to send the email, and none of the messages ever appear
>> > in
>> > the
>> > out box or in sent messages, and none are ever received.
>> >
>> > Am I missing something?
>> >
>> > Thanks for sitting there and reading this long email!
>> >
>> > John
>>
>>
>>



Re: Automating Mail Merge/Sending to Email by JohnJohn

JohnJohn
Wed Aug 24 09:17:07 CDT 2005

Anyone have any *helpful* advice as opposed to *malicious*. Good thing most
of us in here are smarter than you, Jezebel.

"Jezebel" wrote:

> Just try it. You'll be fine.
>
>
>
> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> news:897994F1-9F41-45CD-A62A-DBE9B6F54011@microsoft.com...
> > Ummm...that's where a lot of application extensions, and WINWORD.EXE are,
> > among many other important files. You sure you got the right directory or
> > are you yanking my chain? :)
> >
> > John
> >
> > "Jezebel" wrote:
> >
> >> You need to clear the Outlook message cache before calling the mail
> >> function. Insert this line immediately before the MailMerge statement:
> >>
> >> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
> >>
> >>
> >>
> >>
> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> >> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
> >> > Hello.
> >> >
> >> > I am using the Visual Basic and the Microsoft Word 11.0 Object Library
> >> > to
> >> > automate mail merge and send the output via email. I have almost
> >> > everything
> >> > working. I used Microsoft's examples to figure out how to do this. I
> >> > ran
> >> > the following example code right from
> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
> >> >
> >> > With Documents("FormLetter.doc").MailMerge
> >> > .MailAddressFieldName = "Email"
> >> > .MailSubject = "Amazing offer"
> >> > .Destination = wdSendToEmail
> >> > .Execute
> >> > End With
> >> >
> >> > ...having filled in all the merge fields appropriately. Upon the
> >> > .Execute
> >> > call, I get the following prompt:
> >> >
> >> > "A program is trying to automatically send e-mail on your behalf.
> >> > Do you want to allow this? If this is unexpected, it may be a virus and
> >> > you
> >> > should choose "No"."
> >> >
> >> > I click "Yes" to allow the email. It APPEARS that it's working, but no
> >> > email is ever sent or received by any of the recipients. I assume that
> >> > it's
> >> > using Outlook to send the email, and none of the messages ever appear
> >> > in
> >> > the
> >> > out box or in sent messages, and none are ever received.
> >> >
> >> > Am I missing something?
> >> >
> >> > Thanks for sitting there and reading this long email!
> >> >
> >> > John
> >>
> >>
> >>
>
>
>

Re: Automating Mail Merge/Sending to Email by Doug

Doug
Wed Aug 24 15:23:50 CDT 2005

Jezebel is a knowledgable and frequent poster to these newsgroups and is not
known for providing *malicious* advice as opposed to *helpful* advice.

I can't pass any comment on what he suggested you try other than, provided
you do not have any unsaved work at the time that you try it, it can't do
any harm.



--
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
"JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
news:3F909CB0-A265-4027-8078-B2CF2180942F@microsoft.com...
> Anyone have any *helpful* advice as opposed to *malicious*. Good thing
> most
> of us in here are smarter than you, Jezebel.
>
> "Jezebel" wrote:
>
>> Just try it. You'll be fine.
>>
>>
>>
>> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>> news:897994F1-9F41-45CD-A62A-DBE9B6F54011@microsoft.com...
>> > Ummm...that's where a lot of application extensions, and WINWORD.EXE
>> > are,
>> > among many other important files. You sure you got the right directory
>> > or
>> > are you yanking my chain? :)
>> >
>> > John
>> >
>> > "Jezebel" wrote:
>> >
>> >> You need to clear the Outlook message cache before calling the mail
>> >> function. Insert this line immediately before the MailMerge statement:
>> >>
>> >> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
>> >>
>> >>
>> >>
>> >>
>> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>> >> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
>> >> > Hello.
>> >> >
>> >> > I am using the Visual Basic and the Microsoft Word 11.0 Object
>> >> > Library
>> >> > to
>> >> > automate mail merge and send the output via email. I have almost
>> >> > everything
>> >> > working. I used Microsoft's examples to figure out how to do this.
>> >> > I
>> >> > ran
>> >> > the following example code right from
>> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
>> >> >
>> >> > With Documents("FormLetter.doc").MailMerge
>> >> > .MailAddressFieldName = "Email"
>> >> > .MailSubject = "Amazing offer"
>> >> > .Destination = wdSendToEmail
>> >> > .Execute
>> >> > End With
>> >> >
>> >> > ...having filled in all the merge fields appropriately. Upon the
>> >> > .Execute
>> >> > call, I get the following prompt:
>> >> >
>> >> > "A program is trying to automatically send e-mail on your behalf.
>> >> > Do you want to allow this? If this is unexpected, it may be a virus
>> >> > and
>> >> > you
>> >> > should choose "No"."
>> >> >
>> >> > I click "Yes" to allow the email. It APPEARS that it's working, but
>> >> > no
>> >> > email is ever sent or received by any of the recipients. I assume
>> >> > that
>> >> > it's
>> >> > using Outlook to send the email, and none of the messages ever
>> >> > appear
>> >> > in
>> >> > the
>> >> > out box or in sent messages, and none are ever received.
>> >> >
>> >> > Am I missing something?
>> >> >
>> >> > Thanks for sitting there and reading this long email!
>> >> >
>> >> > John
>> >>
>> >>
>> >>
>>
>>
>>



Re: Automating Mail Merge/Sending to Email by JohnJohn

JohnJohn
Wed Aug 24 16:16:04 CDT 2005

Uh. No. You guys are nuts if you want me to delete Microsoft Word and all
its supporting DLLs and other extensions in order to make mail merge work.
lol

"Doug Robbins" wrote:

> Jezebel is a knowledgable and frequent poster to these newsgroups and is not
> known for providing *malicious* advice as opposed to *helpful* advice.
>
> I can't pass any comment on what he suggested you try other than, provided
> you do not have any unsaved work at the time that you try it, it can't do
> any harm.
>
>
>
> --
> 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
> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> news:3F909CB0-A265-4027-8078-B2CF2180942F@microsoft.com...
> > Anyone have any *helpful* advice as opposed to *malicious*. Good thing
> > most
> > of us in here are smarter than you, Jezebel.
> >
> > "Jezebel" wrote:
> >
> >> Just try it. You'll be fine.
> >>
> >>
> >>
> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> >> news:897994F1-9F41-45CD-A62A-DBE9B6F54011@microsoft.com...
> >> > Ummm...that's where a lot of application extensions, and WINWORD.EXE
> >> > are,
> >> > among many other important files. You sure you got the right directory
> >> > or
> >> > are you yanking my chain? :)
> >> >
> >> > John
> >> >
> >> > "Jezebel" wrote:
> >> >
> >> >> You need to clear the Outlook message cache before calling the mail
> >> >> function. Insert this line immediately before the MailMerge statement:
> >> >>
> >> >> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> >> >> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
> >> >> > Hello.
> >> >> >
> >> >> > I am using the Visual Basic and the Microsoft Word 11.0 Object
> >> >> > Library
> >> >> > to
> >> >> > automate mail merge and send the output via email. I have almost
> >> >> > everything
> >> >> > working. I used Microsoft's examples to figure out how to do this.
> >> >> > I
> >> >> > ran
> >> >> > the following example code right from
> >> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
> >> >> >
> >> >> > With Documents("FormLetter.doc").MailMerge
> >> >> > .MailAddressFieldName = "Email"
> >> >> > .MailSubject = "Amazing offer"
> >> >> > .Destination = wdSendToEmail
> >> >> > .Execute
> >> >> > End With
> >> >> >
> >> >> > ...having filled in all the merge fields appropriately. Upon the
> >> >> > .Execute
> >> >> > call, I get the following prompt:
> >> >> >
> >> >> > "A program is trying to automatically send e-mail on your behalf.
> >> >> > Do you want to allow this? If this is unexpected, it may be a virus
> >> >> > and
> >> >> > you
> >> >> > should choose "No"."
> >> >> >
> >> >> > I click "Yes" to allow the email. It APPEARS that it's working, but
> >> >> > no
> >> >> > email is ever sent or received by any of the recipients. I assume
> >> >> > that
> >> >> > it's
> >> >> > using Outlook to send the email, and none of the messages ever
> >> >> > appear
> >> >> > in
> >> >> > the
> >> >> > out box or in sent messages, and none are ever received.
> >> >> >
> >> >> > Am I missing something?
> >> >> >
> >> >> > Thanks for sitting there and reading this long email!
> >> >> >
> >> >> > John
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Re: Automating Mail Merge/Sending to Email by Jezebel

Jezebel
Wed Aug 24 17:28:20 CDT 2005

As perhaps you've worked out by now, the consensus is that someone who wants
to send bulk emails with a subject line 'amazing offer' is the very dregs of
humanity.

May your haemorrhoids hang like grapes!




"JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
news:62CABFC6-4835-4EAE-AE5C-F02B31921A10@microsoft.com...
> Uh. No. You guys are nuts if you want me to delete Microsoft Word and
> all
> its supporting DLLs and other extensions in order to make mail merge work.
> lol
>
> "Doug Robbins" wrote:
>
>> Jezebel is a knowledgable and frequent poster to these newsgroups and is
>> not
>> known for providing *malicious* advice as opposed to *helpful* advice.
>>
>> I can't pass any comment on what he suggested you try other than,
>> provided
>> you do not have any unsaved work at the time that you try it, it can't do
>> any harm.
>>
>>
>>
>> --
>> 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
>> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>> news:3F909CB0-A265-4027-8078-B2CF2180942F@microsoft.com...
>> > Anyone have any *helpful* advice as opposed to *malicious*. Good thing
>> > most
>> > of us in here are smarter than you, Jezebel.
>> >
>> > "Jezebel" wrote:
>> >
>> >> Just try it. You'll be fine.
>> >>
>> >>
>> >>
>> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>> >> news:897994F1-9F41-45CD-A62A-DBE9B6F54011@microsoft.com...
>> >> > Ummm...that's where a lot of application extensions, and WINWORD.EXE
>> >> > are,
>> >> > among many other important files. You sure you got the right
>> >> > directory
>> >> > or
>> >> > are you yanking my chain? :)
>> >> >
>> >> > John
>> >> >
>> >> > "Jezebel" wrote:
>> >> >
>> >> >> You need to clear the Outlook message cache before calling the mail
>> >> >> function. Insert this line immediately before the MailMerge
>> >> >> statement:
>> >> >>
>> >> >> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>> >> >> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
>> >> >> > Hello.
>> >> >> >
>> >> >> > I am using the Visual Basic and the Microsoft Word 11.0 Object
>> >> >> > Library
>> >> >> > to
>> >> >> > automate mail merge and send the output via email. I have almost
>> >> >> > everything
>> >> >> > working. I used Microsoft's examples to figure out how to do
>> >> >> > this.
>> >> >> > I
>> >> >> > ran
>> >> >> > the following example code right from
>> >> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
>> >> >> >
>> >> >> > With Documents("FormLetter.doc").MailMerge
>> >> >> > .MailAddressFieldName = "Email"
>> >> >> > .MailSubject = "Amazing offer"
>> >> >> > .Destination = wdSendToEmail
>> >> >> > .Execute
>> >> >> > End With
>> >> >> >
>> >> >> > ...having filled in all the merge fields appropriately. Upon the
>> >> >> > .Execute
>> >> >> > call, I get the following prompt:
>> >> >> >
>> >> >> > "A program is trying to automatically send e-mail on your behalf.
>> >> >> > Do you want to allow this? If this is unexpected, it may be a
>> >> >> > virus
>> >> >> > and
>> >> >> > you
>> >> >> > should choose "No"."
>> >> >> >
>> >> >> > I click "Yes" to allow the email. It APPEARS that it's working,
>> >> >> > but
>> >> >> > no
>> >> >> > email is ever sent or received by any of the recipients. I
>> >> >> > assume
>> >> >> > that
>> >> >> > it's
>> >> >> > using Outlook to send the email, and none of the messages ever
>> >> >> > appear
>> >> >> > in
>> >> >> > the
>> >> >> > out box or in sent messages, and none are ever received.
>> >> >> >
>> >> >> > Am I missing something?
>> >> >> >
>> >> >> > Thanks for sitting there and reading this long email!
>> >> >> >
>> >> >> > John
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>



Re: Automating Mail Merge/Sending to Email by John

John
Fri Sep 09 19:48:51 CDT 2005

PMFJI, and so late at that, but, Jezebel, I think you might owe the OP an
apology.

The code he quotes is from the page he pointed at. Word for word.



"Jezebel" <warcrimes@whitehouse.gov> wrote in message
news:eORtisPqFHA.2072@TK2MSFTNGP14.phx.gbl...
> As perhaps you've worked out by now, the consensus is that someone who
> wants to send bulk emails with a subject line 'amazing offer' is the very
> dregs of humanity.
>
> May your haemorrhoids hang like grapes!
>
>
>
>
> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
> news:62CABFC6-4835-4EAE-AE5C-F02B31921A10@microsoft.com...
>> Uh. No. You guys are nuts if you want me to delete Microsoft Word and
>> all
>> its supporting DLLs and other extensions in order to make mail merge
>> work.
>> lol
>>
>> "Doug Robbins" wrote:
>>
>>> Jezebel is a knowledgable and frequent poster to these newsgroups and is
>>> not
>>> known for providing *malicious* advice as opposed to *helpful* advice.
>>>
>>> I can't pass any comment on what he suggested you try other than,
>>> provided
>>> you do not have any unsaved work at the time that you try it, it can't
>>> do
>>> any harm.
>>>
>>>
>>>
>>> --
>>> 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
>>> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>>> news:3F909CB0-A265-4027-8078-B2CF2180942F@microsoft.com...
>>> > Anyone have any *helpful* advice as opposed to *malicious*. Good
>>> > thing
>>> > most
>>> > of us in here are smarter than you, Jezebel.
>>> >
>>> > "Jezebel" wrote:
>>> >
>>> >> Just try it. You'll be fine.
>>> >>
>>> >>
>>> >>
>>> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>>> >> news:897994F1-9F41-45CD-A62A-DBE9B6F54011@microsoft.com...
>>> >> > Ummm...that's where a lot of application extensions, and
>>> >> > WINWORD.EXE
>>> >> > are,
>>> >> > among many other important files. You sure you got the right
>>> >> > directory
>>> >> > or
>>> >> > are you yanking my chain? :)
>>> >> >
>>> >> > John
>>> >> >
>>> >> > "Jezebel" wrote:
>>> >> >
>>> >> >> You need to clear the Outlook message cache before calling the
>>> >> >> mail
>>> >> >> function. Insert this line immediately before the MailMerge
>>> >> >> statement:
>>> >> >>
>>> >> >> Kill "C:\Program Files\Microsoft Office\OFFICE11\*.*"
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >>
>>> >> >> "JohnJohn" <JohnJohn@discussions.microsoft.com> wrote in message
>>> >> >> news:5C69033D-3D62-4822-A524-6F307A93A282@microsoft.com...
>>> >> >> > Hello.
>>> >> >> >
>>> >> >> > I am using the Visual Basic and the Microsoft Word 11.0 Object
>>> >> >> > Library
>>> >> >> > to
>>> >> >> > automate mail merge and send the output via email. I have
>>> >> >> > almost
>>> >> >> > everything
>>> >> >> > working. I used Microsoft's examples to figure out how to do
>>> >> >> > this.
>>> >> >> > I
>>> >> >> > ran
>>> >> >> > the following example code right from
>>> >> >> > http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbawd11/html/woproMailAddressFieldName1_HV05211939.asp:
>>> >> >> >
>>> >> >> > With Documents("FormLetter.doc").MailMerge
>>> >> >> > .MailAddressFieldName = "Email"
>>> >> >> > .MailSubject = "Amazing offer"
>>> >> >> > .Destination = wdSendToEmail
>>> >> >> > .Execute
>>> >> >> > End With
>>> >> >> >
>>> >> >> > ...having filled in all the merge fields appropriately. Upon
>>> >> >> > the
>>> >> >> > .Execute
>>> >> >> > call, I get the following prompt:
>>> >> >> >
>>> >> >> > "A program is trying to automatically send e-mail on your
>>> >> >> > behalf.
>>> >> >> > Do you want to allow this? If this is unexpected, it may be a
>>> >> >> > virus
>>> >> >> > and
>>> >> >> > you
>>> >> >> > should choose "No"."
>>> >> >> >
>>> >> >> > I click "Yes" to allow the email. It APPEARS that it's working,
>>> >> >> > but
>>> >> >> > no
>>> >> >> > email is ever sent or received by any of the recipients. I
>>> >> >> > assume
>>> >> >> > that
>>> >> >> > it's
>>> >> >> > using Outlook to send the email, and none of the messages ever
>>> >> >> > appear
>>> >> >> > in
>>> >> >> > the
>>> >> >> > out box or in sent messages, and none are ever received.
>>> >> >> >
>>> >> >> > Am I missing something?
>>> >> >> >
>>> >> >> > Thanks for sitting there and reading this long email!
>>> >> >> >
>>> >> >> > John
>>> >> >>
>>> >> >>
>>> >> >>
>>> >>
>>> >>
>>> >>
>>>
>>>
>>>
>
>