Mail merge - edit recipients list using macro

I have a mailmerge document and have tried to record a macro doing the following in word 2007

1. Select Mailings tab
2. Click Edit Recipitent list
3. Click filter
4. Change a value on one of my existing field filters which is from email to print.

Unfortunately when I use the record macro and do these steps nothing is being recorded?

Be grateful for some advice or how I can add this into my VBA code

There's a lot you can do in Office via dialogues for which there's no VBA equivalent or, even if there is, there's no VBA recording mechanism. In this case, there's no VBA equivalent.

What you're trying to do is not to edit the data source, but to apply a filter. That's ordinarily done via defining an appropriate query string, which you can do via the:
• MailMerge.OpenDataSource Method; or the
• MailMergeDataSource.QueryString Property
Using either of these entails writing your own SQL statement. An alternative is to use the:
• MailMergeDataSource.Included Property
which you can use inside an If test, for example, so that you don't need to understand SQL. Yet another alternative is to use a SKIPIF field in the mailmerge main document itself. For example, a SKIPIF field coded as per the following text representation prompts for the record range to process, based on a simple record count. With this coding, the user will be prompted to supply the first and last record #s to merge. Any records outside this range will be excluded.
{SKIPIF{=({MERGEREC}< {FILLIN "First Record #" \d 1 \o})+({MERGEREC}> {FILLIN "Last Record #" \d 999 \o})}= 1}

Similarly, a SKIPIF field coded as per the following prompts for the record range to process, based on dates in a ‘DbDate’ field in the source data. With this coding, the user will be prompted to supply the first and last dates to merge. Any records outside this date range will be excluded.
{SKIPIF{={IF{MERGEFIELD DbDate \@ YYYYMMDD}<{FILLIN "First Date to include." \@ YYYYMMDD \o} 1 0}*{IF{MERGEFIELD DbDate \@ YYYYMMDD}>{FILLIN "Last Date to include." \@ YYYYMMDD \o} 1 0}}= 1}

A SKIPIF field coded as per the following first prompts for the item to include/exclude, then solicits input for the inclusion/exlusion rule.
{SKIPIF{IF{FILLIN "Contract to include/exclude." \o }={MERGEFIELD CONTRACT} 0 1}= {FILLIN "1: include. 0: exclude." \o}}

In a generalised sense, the SKIPIF field can be used to apply AND and OR filters for multiple conditions, using coding like:
(AND) - {SKIPIF{={IF{MERGEFIELD Field1}= Y 1 0}*{IF{MERGEFIELD Field2}= "" 1 0}}= 1}
(OR) - {SKIPIF{={IF{MERGEFIELD Field1}= Y 1 0}+{IF{MERGEFIELD Field2}= "" 1 0}}> 0}
(AND) - {SKIPIF{={IF{MERGEFIELD Field1}= Y 1 0}*{IF{MERGEFIELD Field2}= "" 1 0}*{IF{MERGEFIELD Field3}= "" 1 0}}= 1}
(OR) - {SKIPIF{={IF{MERGEFIELD Field1}= Y 1 0}+{IF{MERGEFIELD Field2}= "" 1 0}+{IF{MERGEFIELD Field3}= "" 1 0}}> 0}

Note: The field brace pairs (i.e. '{ }') for the above examples are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues.

No, it just means you have to take a different approach. You could, for example, use an InputBox to provide the SQL statement (good luck typing that in correctly every time you run the macro) or you could programmatically add the necessary SKIPIF field code to the mailmerge main document, so the user gets prompted for the appropriate filter criteria when the merge is executed.