I cannot get the Mailings| Edit Recipients List menu to show using VBA. When I record a macro and click on the Edit Recipients List icon, the menu/deselect table pops up, but the macro recorder records no commands.
I have a MailMerge macro where I set the data source to an excel workbook using the ActiveDocument.MailMerge.OpenDataSource command. I further refine the data by setting the SQL statement with the SQLStatement command.
I would then like to be prompted with the Mail Merge Recipients Menu to manually deselect certain recipients.
As it is, I have one macro that sets the data source and ends. I then manually click on the Edit Recipients List icon to invoke the recipient table to deselect certain data. (It is this table/menu which I wish to invoke with VBA.) I then run another macro which completes the merge.
If I could cause my macro to display the Edit Recipients Menu, I could use only one macro to do this task which would be more streamlined and elegant.
Thanks.
Bookmarks