Thread: Merge Query
View Single Post
  #2   Report Post  
Doug Robbins
 
Posts: n/a
Default

Insert a Skip Record If field that checks to see if the Address1 field is
blank. It's under the Insert Word Fields item.

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP
"KiwiBrian" wrote in message
...
I wonder if anyone can help? I am using Microsoft word and the Tools
Merging options.



I have merged a large number of documents and am editing each one now
individually. For the address block I merged Company Name | Address 1 |
Address 2 - however many of my database entries do not have an Address 1
entry, eg



Company: Adrian Architect

Address 1: 45 Rose Road

Address 2: Auckland



So I have many entries that have only appeared as perhaps:



Company : Adrian Architect

Address 1:

Address 2: Auckland



Consequently when I create the merge document the address appears as:



Adrian Architect

Auckland



Useless!!!



I don't want to go to the trouble to print these out as they are useless
merged letters and yet I don't want to have to spend the time sifting
through each entry and extracting all these entries manually.



Is there a way these entries can be extracted (or at least just marked) so
that I don't print them or can put them in a separate document/folder of
their own?



Thanks in advance for any help with this.

Brian Tozer