View Single Post
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Updating data source with VBA

Using:

With ActiveDocument
If .MailMerge.State = wdMainAndDataSource Then
Dialogs(wdDialogMailMergeRecipients).Show
End If
End With

I can select the datasource and then click on the Edit button and the Edit
Data Source dialog appears allowing me to Edit or Add new entries.

--
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, originally posted via msnews.microsoft.com

"Alan" wrote in message
...
I am using XP SP3 and Word 7. Using the normal ribbon commands, I get the
following:
On Mailing Ribbon click on "Edit Recipient List", this shows a window
"Mail Merge Recipient"
Click on the displayed Data Source
Select "Edit"
A pop-up window appears called "Data Form" to input details.

When I run this from a Macro, using the macro:
"Dialogs(wdDialogMailMergeRecipients).Show" the window "Mail Merge
Recipient" shows, but when I select the Data Source and click on "Edit",
the pop-up window does not appear, although the existing windows flash
once off and back on.

How can I get the window to show?