Re: Mail merger helper not inserting correct data into word docume

Tech-Archive recommends: Fix windows errors by optimizing your registry

I am trying to put information into an existing mail merge word document. I
bring up the mail merge helper and using query options I then set the field -
comparison- compare to as required. Then OK then merge and then merge to new
document - it is at this stage that the information placed into the document
is incorrect. I cannot understand why it will not work it has always worked
in the earlier version.
susieb
"Peter Jamieson" wrote:

> What sort of filter are you using? (in particular, is it a filter on a date
> item)?
>
> Do you use the same data source and filter all the time? If so, are you in a
> position to add a query to the database (or can it be done for you) and use
> that as the data source?
>
> Peter Jamieson
> "susieb" <susieb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:0FE6855F-4933-44E3-84D8-1A49A0662241@xxxxxxxxxxxxxxxx
> > The data is from the correct source but the filter is not working as it
> > should. It would seem that the information placed into the document is
> > the
> > first record that was entered into the database.
> > Susie B
> > "Peter Jamieson" wrote:
> >
> >> What kind of "incorrect" / Is it data from a completely different source,
> >> or
> >> are sorts/filters not working how you hope/expect?
> >>
> >> If you use the Word 2003 Mail Merge recipients dialog, do you see the
> >> correct data or not?
> >>
> >> Peter Jamieson
> >>
> >> "susieb" <susieb@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> >> news:7A54E7BF-6301-4983-B50F-9DEB814FDD88@xxxxxxxxxxxxxxxx
> >> >I am working with Word and Access 2003 now. Have created the use of
> >> >mail
> >> > merger helper and made sure that the word document is attached to the
> >> > correct
> >> > database. However when I use mail merge helper / query options and
> >> > enter
> >> > the
> >> > appropriate information and then go to Merge - the information merged
> >> > into
> >> > the document is incorrect. Where am I going wrong please?
> >>
> >>
> >>
>
>
>
.

Relevant Pages

  • Word was unable to open the data source when connecting to SQL Exp
    ... Word document. ... > Create new SQL Server data source ... unable to open the data source", followed by "Could not ... without filter as mentioned above). ...
    (microsoft.public.word.application.errors)
  • Re: How do I save the data form for merge documents?
    ... Word has become very bad at retaining information about filter ... "Peter Jamieson" wrote: ... data source, you can't find/recognise the data source you created ... don't have to have Access to use these .mdb files. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Word Merge - All At One
    ... source to .xls) for every word document that i have ... Dim strSheetName As String ... Dim fDialog As FileDialog ... ' If you don't actually need to save the new data source do this ...
    (microsoft.public.word.docmanagement)
  • Re: How do I save the data form for merge documents?
    ... to re-enter all the variables to sort and filter every time you open the ... Helper out of "All Commands" to get it onto the Mail Merge toolbar.) ... "Peter Jamieson" wrote: ... data source, you can't find/recognise the data source you created ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Tips for using Excel as data file in Word merge doct?
    ... merge puts records one after another on the same page. ... > I want to merge Excel data from one column into a single Word Document. ... data source column. ...
    (microsoft.public.word.newusers)