Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Envelope Mail Merge with Multiple Addressees in Access Database
I have an access database which includes fields for potential several (9)
addressees in each record. I wold like to create a template for Word to perform a mail merge to print an envelope addressed to each. How do I do this for specific records? TIA! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Envelope Mail Merge with Multiple Addressees in Access Database
Hi ?B?c2ZfaG9tYnJl?=,
I have an access database which includes fields for potential several (9) addressees in each record. I wold like to create a template for Word to perform a mail merge to print an envelope addressed to each. How do I do this for specific records? Which version of Word do you have? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Envelope Mail Merge with Multiple Addressees in Access Databas
Cindy
I have Word 2003 and Access 2003 "Cindy M -WordMVP-" wrote: Hi ?B?c2ZfaG9tYnJl?=, I have an access database which includes fields for potential several (9) addressees in each record. I wold like to create a template for Word to perform a mail merge to print an envelope addressed to each. How do I do this for specific records? Which version of Word do you have? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Envelope Mail Merge with Multiple Addressees in Access Database
If you start off with a blank page, then form the Envelopes and Labels
dialog, select the type of envelope that you want to use and then click on add to document. Now, click on the ¶ button on the toolbar to show the section break that will appear on the envelop and switch to normal view. Then select everything down to and including the section break and copy and paste it as many times as necessary before the final ¶ in the document. Use FilePage layout to change the dimensions of the last page in the document to be the same as the envelopes and then select the last section break and the following ¶ and then press the delete button. Switch to Print Layout View and you should now see a whole series of envelopes. Insert each mergefield that contains address details into the Address Frame on each envelope. Note, if not all of the mergefields contain data, you will get blank envelopes. If you wanted to overcome this issue, you could use an If...then...Else field to insert some unique identified in place of the mergefield in each envelope if the mergefield was empty and then after executing the merge to a new document, you could run a macro that deleted from the document each section that contained that unique identifier. I think the above will do what you want. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "sf_hombre" wrote in message ... I have an access database which includes fields for potential several (9) addressees in each record. I wold like to create a template for Word to perform a mail merge to print an envelope addressed to each. How do I do this for specific records? TIA! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge - Parameter prompts twice... | Mailmerge | |||
Mail Merge to a secured Access database | Mailmerge | |||
mail merge - Access 2000 and Word 2000 | Mailmerge | |||
why word 2000 mail merge opens multiple instances of access table. | Mailmerge | |||
Word mail merge doesn't pick up the addresses in Access database. | Tables |