merging from access

[Ilan]

Hello,
I have a table in access which stores my customer
information. It allows the customer to enter in a
billing address and a shipping address (if different than
the billing address). There is a check box which is
checked if there is a different shipping address. I
would like to merge to word to print out my customer
information, however i would like all of the shipping
addresses to be printed out. How do i get word to
recognize the check box and only print out the shipping
addresses?

Thanks in advance for your help. I'm also going to ask
access people too since my problem encompasses both
programs.

Ilan

 

[Doug Robbins - Word MVP]

While this certainly can be done through the use of an If...then...else
field in the Mailmerge main document, I would suggest that you use a query
in Access that makes used of the IIF() function to return the desired
address based on the value in the checkbox field. Then use that query as
the data source for your mailmerge.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

 

[Ilan]

I tried running it through a query, however, i sort my
data in three ways. first by last name, then first, then
middle in order to have the exact alpha order. If i use
a query, i cannot sort in these three ways it will only
allow me to sort in one way. How would i go about using
either or the methods you suggested?

Thanks,
Ilan

 

[Doug Robbins - Word MVP]

In the Access query, arrange the fields in the QBE grid in the order in
which you want them sorted. That is last name on the left, first name next
and then middle on the right. Set the sort order for each of these fields
to ascending and your data will be sorted in the way in which you want.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP