Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2015, 07:26 AM
Formd Formd is offline Removing Return from Address field in Mailmerge Windows 7 32bit Removing Return from Address field in Mailmerge Office 2007
Advanced Beginner
Removing Return from Address field in Mailmerge
 
Join Date: Feb 2015
Location: TX
Posts: 46
Formd is on a distinguished road
Question

Hello everyone,
I need your help. I'm not sure if Word uses ASSIGN like Wordperfect does. I am trying to merge a legal document that includes an address from 2 merge fields. The first field has the Street Address plus the Suite or Apartment number. The second field has the City, State and Zip. So it looks like this after the merge:
123 Street Address
Suite 5678
Dallas, TX 75201



Because the address goes into the body of this document, I need the entire address to merge on the same line so it looks like this:
123 Street Address, Suite 5678, Dallas, TX 75201. How can I make this happen?

First field =
123 Street Address
Suite 5678

Second field =
Dallas, TX 75201

Thanks in advance for your kind assistance.
Reply With Quote
  #2  
Old 04-27-2015, 09:49 AM
Formd Formd is offline Removing Return from Address field in Mailmerge Windows 7 32bit Removing Return from Address field in Mailmerge Office 2007
Advanced Beginner
Removing Return from Address field in Mailmerge
 
Join Date: Feb 2015
Location: TX
Posts: 46
Formd is on a distinguished road
Default Removing Return from Address field in Mailmerge

Can anyone help me with this issue? Let me go a little further by adding the name to the fields to see if anyone can help.

First field = «Address1»
123 Street Address
Suite 5678

First field = «Address2»
Dallas, TX 75201

Does MSWord allow two fields to be assigned as a single field? (hope this makes sense). If so, how? I researched but could not find anything. I desperately need help my deadline to complete this legal document is fast approaching. Any suggestion on getting the entire address on a single line in a mail merge?
Reply With Quote
  #3  
Old 04-27-2015, 10:07 PM
gmayor's Avatar
gmayor gmayor is offline Removing Return from Address field in Mailmerge Windows 7 64bit Removing Return from Address field in Mailmerge Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You cannot insert part of a field in Word, so your first field, with the line break is the problem. You will always get that line break. The only practical answer is to add extra address columns to your data source and derive the parts of the address from the original field. This is straightforward in Excel. You can then merge the revised fields as required.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing 365 University and 365 Home from being on the same email address elmo1943 Office 0 12-22-2014 05:02 PM
Print return address on envelope MaineLady Excel 5 09-22-2014 04:50 PM
Return Address on envelope nannycheryl Word 0 05-06-2014 06:46 AM
Changing Return Address Angus.Crawford Outlook 0 04-04-2013 03:36 PM
Outlook using wrong return address asharx Outlook 2 10-12-2011 11:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:04 PM.


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