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:
[Quoted Text] > 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" <3C[ at ]discussions.microsoft.com> wrote in message
> news:A4949254-A280-4F09-B82E-9F1E690DCF0D[ at ]microsoft.com...
> >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
>
|