Mail Merge

[Kady]

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?

 

[Arvin Meyer [MVP]]

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.

 

[Kady]

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.

 

[Arvin Meyer [MVP]]

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arvin Meyer [MVP]]

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.