Microsoft Office Forums Word Mail Merge Envelope Addresses with Multiple Conditions

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-18-2019, 11:12 AM
Pedro007 Pedro007 is offline Word Mail Merge Envelope Addresses with Multiple Conditions Windows 10 Word Mail Merge Envelope Addresses with Multiple Conditions Office 2013
Novice
Word Mail Merge Envelope Addresses with Multiple Conditions
 
Join Date: Nov 2019
Posts: 2
Pedro007 is on a distinguished road
Default 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.
Reply With Quote
  #2  
Old 11-18-2019, 02:34 PM
macropod's Avatar
macropod macropod is online now Word Mail Merge Envelope Addresses with Multiple Conditions Windows 7 64bit Word Mail Merge Envelope Addresses with Multiple Conditions Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,637
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 11-19-2019, 07:25 AM
Pedro007 Pedro007 is offline Word Mail Merge Envelope Addresses with Multiple Conditions Windows 10 Word Mail Merge Envelope Addresses with Multiple Conditions Office 2013
Novice
Word Mail Merge Envelope Addresses with Multiple Conditions
 
Join Date: Nov 2019
Posts: 2
Pedro007 is on a distinguished road
Smile 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
Reply With Quote
Reply

Tags
condition statement, envelope address, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mail Merge Envelope Addresses with Multiple Conditions 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
Word Mail Merge Envelope Addresses with Multiple Conditions add a message to envelope in mail merge cessna310 Mail Merge 3 02-09-2015 02:37 PM
Word Mail Merge Envelope Addresses with Multiple Conditions How to Use Mail Merge with conditions to show some features raiya Mail Merge 11 10-16-2012 11:04 PM


All times are GMT -7. The time now is 01:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft