Missing Field in Merge

[Donna F]

I have a macro that merges several documents and then combines the documents
together. Sometimes there is a field missing from the data source because
there is no data for a particular project. This causes the macro to stop and
requires intervention from the user. You have to click on "Remove Field" and
then the merge continues. The error message is - "Invalid Merge Field". This
is a normal and ongoing thing. I would like to be able to bypass this error
message and have any missing fields automatically removed. Any ideas?

 

[Doug Robbins - Word MVP]

Wouldn't it be easier the ensure that the datasource always contains the
field, even if it contains no data?

--
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

 

[Donna F]

Unfortunately the data comes out of a crosstab query in MS Access and gets
dumped into an Excel spreadsheet. the crosstab only summarizes data that
exists.