Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Recipient Filters
I am completing a label merge with the recipient list in Excel. I edit the
list based on my criteria using the Advanced filters. I get the proper data, however as soon as I go to preview my labels or complete the merge, Word somehow adds more filters to my criteria & the wrong amount of data is placed on my labels. I have started from a new document as well have copied & pasted my data to a new excel file as well. Anyone have any suggestions? Thanks! C |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Recipient Filters
There are problems in this area in some versions of Word (which version are
you using), because a. Word generatesan SQL query to get the data from Excel b. Word either adds stuff to the query that should not be there, or in some cases, the query does not actually work as it should Broadly speaking there are two ways you can work around it: a. you can try connecting via DDE, which will in most cases get the data you asked for, but only if it is in the first sheet in the workbook and does not contain non-ANSI Unicode characters b. you can use Word VBA and the OpenDataSource method to issue the query you really want (and to redo that, if necessary, each time you open the document. But let's only go into the details of that if necessary. Peter Jamieson "3C" wrote in message ... I am completing a label merge with the recipient list in Excel. I edit the list based on my criteria using the Advanced filters. I get the proper data, however as soon as I go to preview my labels or complete the merge, Word somehow adds more filters to my criteria & the wrong amount of data is placed on my labels. I have started from a new document as well have copied & pasted my data to a new excel file as well. Anyone have any suggestions? Thanks! C |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Recipient Filters
Thanks Peter! We are using 2003 however I believe the merge was created with
2000 & then converted over. For no apparent reason other than trying for 4 hours to make this work it is now working. If it decides to fail again I will definetly try your VBA suggestion. Thanks again! C "Peter Jamieson" wrote: There are problems in this area in some versions of Word (which version are you using), because a. Word generatesan SQL query to get the data from Excel b. Word either adds stuff to the query that should not be there, or in some cases, the query does not actually work as it should Broadly speaking there are two ways you can work around it: a. you can try connecting via DDE, which will in most cases get the data you asked for, but only if it is in the first sheet in the workbook and does not contain non-ANSI Unicode characters b. you can use Word VBA and the OpenDataSource method to issue the query you really want (and to redo that, if necessary, each time you open the document. But let's only go into the details of that if necessary. Peter Jamieson "3C" wrote in message ... I am completing a label merge with the recipient list in Excel. I edit the list based on my criteria using the Advanced filters. I get the proper data, however as soon as I go to preview my labels or complete the merge, Word somehow adds more filters to my criteria & the wrong amount of data is placed on my labels. I have started from a new document as well have copied & pasted my data to a new excel file as well. Anyone have any suggestions? Thanks! C |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MailMerge is changing my filters! | Mailmerge | |||
Mail Merge Filters | Mailmerge | |||
Corrupted graphics filters? | Microsoft Word Help | |||
How do i load search filters | Microsoft Word Help | |||
Word HTML filters | New Users |