 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / April 2005Mail 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? 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 >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 [quoted text clipped - 4 lines] > into > the document is incorrect. Where am I going wrong please? 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 > What kind of "incorrect" / Is it data from a completely different source, or > are sorts/filters not working how you hope/expect? [quoted text clipped - 12 lines] > > into > > the document is incorrect. Where am I going wrong please? 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 > 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 [quoted text clipped - 21 lines] >> > into >> > the document is incorrect. Where am I going wrong please? 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 > What sort of filter are you using? (in particular, is it a filter on a date > item)? [quoted text clipped - 29 lines] > >> > into > >> > the document is incorrect. Where am I going wrong please? To add to my porevious reply - yes one of the filters is a date field - what particular problems does this bring? susieb > What sort of filter are you using? (in particular, is it a filter on a date > item)? [quoted text clipped - 29 lines] > >> > into > >> > the document is incorrect. Where am I going wrong please? 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 > To add to my porevious reply - yes one of the filters is a date field - > what [quoted text clipped - 40 lines] >> >> > into >> >> > the document is incorrect. Where am I going wrong please? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.