Missing Field in Merge

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Donna F - 16 Jul 2007 14:44 GMT

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?

Reply to this Message

Doug Robbins - Word MVP - 17 Jul 2007 05:50 GMT

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

Signature

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

>I have a macro that merges several documents and then combines the
>documents
[quoted text clipped - 8 lines]
> error
> message and have any missing fields automatically removed. Any ideas?

Reply to this Message

Donna F - 17 Jul 2007 16:08 GMT

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.

> Wouldn't it be easier the ensure that the datasource always contains the
> field, even if it contains no data?
[quoted text clipped - 11 lines]
> > error
> > message and have any missing fields automatically removed. Any ideas?

Reply to this Message