 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2004merging 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 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.  SignaturePlease 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 > Hello, > I have a table in access which stores my customer [quoted text clipped - 13 lines] > > 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 >-----Original Message----- >While this certainly can be done through the use of an If...then...else [quoted text clipped - 22 lines] > >. 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. SignaturePlease 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 >I tried running it through a query, however, i sort my > data in three ways. first by last name, then first, then [quoted text clipped - 47 lines] >> >>.
|
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.