 |
 | 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 2006Mailing Lists
I'm using Office 2003 Excel as my data source, and looking for an easy way to produce 2 mailing label lists for postage purposes. Would like to generate one list where the country = Canada, and the second list where the country =US. Right now my merge label looks like this: <<LastName>> <<FirstName>> <<Address1>> <<Address2>> <<City>> <<Prov>> <<PostalCode>> <<Country>>  SignatureRegards Michael Koerner In essence you should be able to use the Mail Merge recipients dialog box to select "Canada" for one merge and "US" for another. (Enable the Mail merge toolbar to get at the Edit Recipients button). Personally I'd probably output all my labels to a new document first just to ensure that each merge is doing the right thing before printing anything. Precisely how you organise that is up to you (make a merge main document, copy it, set up one for Canada and one for the US, or maybe just do one merge, change the selection filter, do another merge. However, if that is what you're asking about, let us know... Peter Jamieson > I'm using Office 2003 Excel as my data source, and looking for an easy way > to produce 2 mailing label lists for postage purposes. Would like to [quoted text clipped - 6 lines] > <<PostalCode>> > <<Country>> Thanks Peter that seems to do the job I thought I might need some sort of IF statement. I do run the merge to a new document all the time. Would what you suggested also work for a blank field. I often have to generate labels for people who do not have an email address. SignatureRegards Michael Koerner > In essence you should be able to use the Mail Merge recipients dialog box > to select "Canada" for one merge and "US" for another. (Enable the Mail [quoted text clipped - 20 lines] >> <<PostalCode>> >> <<Country>> It might, but the Edit recipients dialog does not always behave how you might hope, because Word sometimes generates the wrong SQL. (Typically you would either click on the header of the dropdown of the filed you want to filter, and either try to select the value you want, or select Advanced... and use the "Query Options" dialog to specify the filter. All I can suggest is that you try it and see, but AFAICR in this case the usual workaround of checking Word Tools|Options|General|"Confirm conversion at open", and reconnecting and selecting the DDE option probably works. Peter Jamieson > Thanks Peter that seems to do the job I thought I might need some sort of > IF statement. I do run the merge to a new document all the time. Would [quoted text clipped - 25 lines] >>> <<PostalCode>> >>> <<Country>> |
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.