Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field Validation
I have a large mail merge in MS Word 2007. Is there a way to validate that
all fields are filled out for each address (other than doing a manual review)? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field Validation
Hi mdvespa,
You should test the data source for this. Whatever app you're using to create the data source should have the necessary tools. -- Cheers macropod [MVP - Microsoft Word] "mdvespa" wrote in message ... I have a large mail merge in MS Word 2007. Is there a way to validate that all fields are filled out for each address (other than doing a manual review)? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field Validation
Unfortunately, my data source does not provide with functionality. Is there
any way to perform this in MS Word? mdvespa "macropod" wrote: Hi mdvespa, You should test the data source for this. Whatever app you're using to create the data source should have the necessary tools. -- Cheers macropod [MVP - Microsoft Word] "mdvespa" wrote in message ... I have a large mail merge in MS Word 2007. Is there a way to validate that all fields are filled out for each address (other than doing a manual review)? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field Validation
Create a single row Word table with as many columns as you have fields. Put
a field in each column. Attach your data source and set the document type to directory. Merge to a new document. Sort the table in that document by each column in turn. Any empty fields in that column will be at the top of the table. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org mdvespa wrote: Unfortunately, my data source does not provide with functionality. Is there any way to perform this in MS Word? mdvespa "macropod" wrote: Hi mdvespa, You should test the data source for this. Whatever app you're using to create the data source should have the necessary tools. -- Cheers macropod [MVP - Microsoft Word] "mdvespa" wrote in message ... I have a large mail merge in MS Word 2007. Is there a way to validate that all fields are filled out for each address (other than doing a manual review)? |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field Validation
I'd go with Graham's suggestion (or if the number of records is small
enough to fit in the recipients dialog box, you could try sorting/filtering in there - I'd do it one column at a time). There are a couple of other variations on these approaches. But what is the data source? Peer Jamieson http://tips.pjmsn.me.uk mdvespa wrote: Unfortunately, my data source does not provide with functionality. Is there any way to perform this in MS Word? mdvespa "macropod" wrote: Hi mdvespa, You should test the data source for this. Whatever app you're using to create the data source should have the necessary tools. -- Cheers macropod [MVP - Microsoft Word] "mdvespa" wrote in message ... I have a large mail merge in MS Word 2007. Is there a way to validate that all fields are filled out for each address (other than doing a manual review)? |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge Field Validation
Hi mdvespa,
Have you considered using Excel for. It sounds to me as if the auto-filter option will take you where you want to go. Again, I guess it depends on the nature of your source, but Excel is a very flexible tool for importing, verifying, cleaning and exporting data. Regards, Shinano "mdvespa" wrote: Unfortunately, my data source does not provide with functionality. Is there any way to perform this in MS Word? mdvespa "macropod" wrote: Hi mdvespa, You should test the data source for this. Whatever app you're using to create the data source should have the necessary tools. -- Cheers macropod [MVP - Microsoft Word] "mdvespa" wrote in message ... I have a large mail merge in MS Word 2007. Is there a way to validate that all fields are filled out for each address (other than doing a manual review)? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form Field Validation | Microsoft Word Help | |||
Adding a validation | Microsoft Word Help | |||
Mail Merge Outcome Validation | Mailmerge | |||
Data Validation | Microsoft Word Help | |||
validation help | New Users |