Home |
Search |
Today's Posts |
#1
|
|||
|
|||
merging from access
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
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 -----Original Message----- 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" wrote in message ... 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 . |
#4
|
|||
|
|||
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 "Ilan" wrote in message ... 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 -----Original Message----- 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" wrote in message ... 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 . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging from Access Query with one to many rocords | Microsoft Word Help | |||
Opening Access from Word | Microsoft Word Help | |||
Mailmerge data source in an Access database will not open | Mailmerge | |||
Merging data from two consecutive access records in Word 2002 | Mailmerge | |||
Word mail merge with Access | Mailmerge |