Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail merger helper not inserting correct data into word document
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? |
#2
|
|||
|
|||
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" wrote in message ... 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? |
#3
|
|||
|
|||
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" wrote in message ... 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? |
#4
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... I am working with Word and Access 2003 now. Have created the use of 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? |
#5
|
|||
|
|||
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" wrote in message ... 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" wrote in message ... I am working with Word and Access 2003 now. Have created the use of 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? |
#6
|
|||
|
|||
To add to my porevious reply - yes one of the filters is a date field - what
particular problems does this bring? 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" wrote in message ... 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" wrote in message ... I am working with Word and Access 2003 now. Have created the use of 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? |
#7
|
|||
|
|||
There are some problems with filters on date fields with some data sources,
or rather, with some sources when accessed through specific connection methods. For any data source, Word constructs an SQL query from the file or database name, the filter options, and the sort options. However, there are various different dialects of SQL and Word sometimes does not generate the correct syntax. Dates are particularly tricky because there are more variations between the dialects. In this case, it is almost certainly worth trying changing the connection method - check Word Tools|Options|General|"Confirm conversion at open", go through the connection process again, and choose one of the other methods - if you previously used Word 97 or 2000, the DDE method works in much the same way, but you may find that ODBC works too. Peter Jamieson "susieb" wrote in message ... To add to my porevious reply - yes one of the filters is a date field - what particular problems does this bring? 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" wrote in message ... 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" wrote in message ... I am working with Word and Access 2003 now. Have created the use of 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? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge data source problem | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |