#1
|
|||
|
|||
Word Mail Merge Envelope Addresses with Multiple Conditions
I have just joined the forum and I am trying to figure out how to create conditions in the Mail Merge envelope address. I am trying to send letters out using Mail Merge. The data fields are broken up to include: street number, street prefix (E., W., etc.), street name, street type (Rd., ST., BLVD., etc.), apartment number, city, state and zip code. My problem is that no every address has a street prefix, street type or apartment number. The fields for some of these records are blank.
I would like to create a custom address block that includes the basics but adds the additional fields when applicable. including a separate address line for the apartment number when there is one. I would greatly appreciate any help that anyone has to offer. Thank you. |
#2
|
||||
|
||||
Those issues are dealt with in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: Mailmerge Tips & Tricks
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Solution for Mail Merge Envelope Addresses with Multiple Conditions
Macropod,
It has taken me a while to go through the material contained in that post, but I did find exactly what I needed. I think that the suppress of the spaces and lines is a better method of dealing with this situation. I did not even know that was an option. Your post contains a wealth of knowledge. Thanks much! Pedro007 |
Tags |
condition statement, envelope address, mail merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge problem with greeting line and address block in envelope | JoemanNville | Mail Merge | 2 | 02-16-2019 05:44 PM |
Mail Merge Envelope Address Box | Rob S | Mail Merge | 1 | 06-05-2017 06:23 AM |
Envelope merge with specially formatted envelope not working. | Paul_L | Mail Merge | 5 | 05-13-2015 10:27 PM |
add a message to envelope in mail merge | cessna310 | Mail Merge | 3 | 02-09-2015 02:37 PM |
How to Use Mail Merge with conditions to show some features | raiya | Mail Merge | 11 | 10-16-2012 11:04 PM |