I initiated the recording of a new Macro in Word 2007 (recording the actions of the mouse) from the Developer Tab in an existing mail merge document with an Excel 2007 spreadsheet as its database source:
1. Replace the title text of the document
2. Select "Mailings" Tab
3. Select "Edit Recipient LIst"
4. Select "Filter"
5. Enter Query based on name field
6. OK
The Macro Recorder fails to record steps 2-6:
I looked up the macro in the Visual Basic editor and these commands are not listed in the macro. Only step one is listed.
I also tried reversing the order, doing all the mail merge steps first then the text change. I got the same result. The Macro recorder is ignoring all the steps involving the Mail Merge query commands.
The macro recorder in Word 2000 used to do this. Why can't I do this in Word 2007?
EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx