 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / February 2008Mail Merge
Im working in Access03 and im trying to do a simple mail merge. I have a contact database set up of investors, each investor has interest in certain properties, which are catergorized in the properties field, some have only one some have more than one. for example John Smith has "Stone" "Fir" and "Cyp" in his properties field reflecting his interests. I can run a filter to show only those with interest in one property but I CAN'T take the results of that filter and complete a mail merge with MS word. I've tried saving it, but it never saves the results of the filter only the filter itself. Ive tried doing the filter in Word through the merge wizard but it always comes up blank. Can anyone help? Try using a query with the same criteria as your filter. If the query doesn't show up in your list of "mergeable" objects, you can build a temp table and use 2 queries, 1 to delete the data, and the second to append data. Tables always show up in Word merge lists.  SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > Im working in Access03 and im trying to do a simple mail merge. > [quoted text clipped - 11 lines] > it > always comes up blank. Can anyone help? the feild that I filter out of is a multiple entry field, so I cant use a query, because I still need to filter the query. > Try using a query with the same criteria as your filter. If the query > doesn't show up in your list of "mergeable" objects, you can build a temp [quoted text clipped - 15 lines] > > it > > always comes up blank. Can anyone help? That is one of the why you should never use multiple values in a single field, Microsoft provides that for compatibility with Sharepoint, but the truth is that every field must never hold data which can be decomposed. I suggest that you redesign your data structure to be aligned with relational data principles as outlined in every book on good database design. You could build an IN clause in code to handle multiple results, and use code to build a table, but that it far more complex. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com > the feild that I filter out of is a multiple entry field, so I cant use a > query, because I still need to filter the query. [quoted text clipped - 25 lines] >> > it >> > always comes up blank. Can anyone help? > the feild that I filter out of is a multiple entry field, so I cant use a > query, because I still need to filter the query. You might try using the ID from the form to put the data into a temporary table. Since I don't use multi-value fields I am unsure if it will work but you should be able to write the contents of the form to the table. SignatureArvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com |
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.