Word Automation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MaxArk - 10 Apr 2008 20:58 GMT

I need to do two things with my merging ...

1) How can I disable the message that comes up before the merg
prompting the user to accept the criteria for recipient selection?

2) In an effort to automate, and not have to depend on the user knowin
which button to press, how can I have my merge go automatically to
document?

Jen

--
MaxArk

Reply to this Message

Doug Robbins - Word MVP - 11 Apr 2008 04:00 GMT

If by Item 1 you mean:

"Opening This Will Run the Following SQL Command" Message When You Open a
Word Document , see::

http://support.microsoft.com?kbid=825765

As getting that message would indicate that the merge main document already
has a data source attached to it, you could save it as a template and then
have an autonew macro in the template that contains the following code:

With Active Document.MailMerge
.Destination = wdSendToNewDocument
.Execute
End With

Signature

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

> I need to do two things with my merging ...
>
[quoted text clipped - 6 lines]
>
> Jenn

Reply to this Message

MaxArk - 11 Apr 2008 17:04 GMT

Thank you Doug!!!
Your solution for item #1 did the trick ...

Doug Robbins - Word MVP;2717927 Wrote:

> If by Item 1 you mean:
>
[quoted text clipped - 6 lines]
> .Execute
> End With

I' struggling a bit with this. I'm unfamiliar with Word coding ..
how/where do I place this code?

Jen

--
MaxArk

Reply to this Message