S
sinplicity
I am currently using Merge to Directory in Word 2003 to pick up details of
our staff vacancies from an Excel 2003 spreadsheet and place them in an
HTML-ready document. To date, I have been filtering for each division and
merging to the relevant document manually. I want to create a macro to do
them all automatically but, when I record a macro to do so, it does not
change the filtering of the source data and merely produces identical output
when I run it, even though doing it manually produces 4 different documents.
How do I include the filtering instructions to get output relevant to the
selected division?
our staff vacancies from an Excel 2003 spreadsheet and place them in an
HTML-ready document. To date, I have been filtering for each division and
merging to the relevant document manually. I want to create a macro to do
them all automatically but, when I record a macro to do so, it does not
change the filtering of the source data and merely produces identical output
when I run it, even though doing it manually produces 4 different documents.
How do I include the filtering instructions to get output relevant to the
selected division?