I have set up an Mail merge document. But, I have to manually click on
View Merge Data A Button to get values. I used the following macro
code to get execute mailmerge.

If ActiveDocument.MailMerge.State = wdMainAndDataSource Then
ActiveDocument.MailMerge.Execute
End If

Maybe you need:

If ActiveDocument.MailMerge.State = wdMainAndDataSource Then
ActiveDocument.MailMerge.Destination = wdSendToNewDocument
ActiveDocument.MailMerge.Execute
End If

I am not sure where it goes if you don't specify a destination.

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

"Crazy Macros" wrote in message
oups.com...
I have set up an Mail merge document. But, I have to manually click on
View Merge Data A Button to get values. I used the following macro
code to get execute mailmerge.

If ActiveDocument.MailMerge.State = wdMainAndDataSource Then
ActiveDocument.MailMerge.Execute
End If

It doesn't work. Is there a way to debug. I can't even display MsgBox.

Doug,

It doesn't work. Is there a way to debug this. I can't even use
MsgBox. Please advice.

I would suggest that you first get the merge working by executing it using
the user interface rather than jumping straight in with a macro.

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

"Crazy Macros" wrote in message
oups.com...
Doug,

It doesn't work. Is there a way to debug this. I can't even use
MsgBox. Please advice.

I got the merge working with UI. I need help to get it automated.

Can you get the msgbox function to work?

For example, if you run a macro with the command

msgbox "Hello World."

you should see a message box with that message in it.

You are going to have to sort that out before trying anything else.

Why do you want to automate the mailmerge? Are you trying to do it from
some other application?

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

"Crazy Macros" wrote in message
oups.com...
I got the merge working with UI. I need help to get it automated.