mail merge

[dosima]

Hi

i have a query which shows customer names and address details. The query
also shows a balance for the customers. The balance in the query was created
from related tables with different fields, So the balance field is a
calculated field. an expression.

The problem is when i merge to a word document the customers name and
addresses works fine, but when i have that balance field to show in the word
document, it doesnt work. word cannot pick up the database.

Can somebody help me and tell me why it doesnt work. Is it because it is a
calculated field.

thanks in advance

 

[Jackie L]

Are you merging to an exported file or to your database? You can always
change your query to a Make Table and have the mail merge point to that new
table.

Hope this helps,
Jackie

 

[vbasean]

I don't have a problem running queries with function in mail merge.
I'm sure Jackie means well but it's not a good practice to make tables
for a mail merge. Your database will soon be cluttered with
unmeaningful tables and that can create quite a headache when deciding
what needs to go next clean up time and you'll forget whether the
table is connected to other objects such as queries, forms reports
etcetera. If anything export the query to a spreadsheet. That's
using brute force to solve the problem but it's not a long term
solution.