Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-09-2014, 07:23 PM
crussell crussell is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 64bit
Novice
fill in blank information
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default fill in blank information

Hello:



I am going to try to explain this as much as possible as I can to make it sense. I have a form in word would like to merge the data from excel that I have created. In the data there are 3-different mailing addresses set in 3 different columns (mailing 1-plan type; mailing 2-address or attn.; mailing 3-address) then there is city, state, and zip have each it's own column as well. Mailing 3 column has few of the addresses are on this column because mailing 2 may have their attention name on it. When mailing 3 is pulled from the data to the form it is showing blank but what I wanted to do is pull/fill it in the next information which is the city, state, and zip. When the city, state, and zip are moved up to the mailing 3 line then the last line would be left blank. Can someone please help me. I hope this make sense. I have attached the form the way it is set up.
Attached Files
File Type: doc RTbilling.doc (37.5 KB, 9 views)
Reply With Quote
  #2  
Old 11-09-2014, 08:19 PM
macropod's Avatar
macropod macropod is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I suggest you read the 'Mailmerge Empty Line Suppression' topic in the 'Mailmerge Tips & Tricks' Sticky thread at the top of this forum:
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-10-2014, 07:59 PM
crussell crussell is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 64bit
Novice
fill in blank information
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

Hello Macropod
Thank you for responding. I am still having problems. I am not sure what I am doing wrong. Here is the field code that I input {MERGEFIELD Mailing_Address_3 \f "
"} is this correct?

I am not sure what I did one time that somehow it came out the way it's suppose to. I did not have to edit or insert any field codes. All I did is clicked on one of the rules. As far as I know that's all I have done. Can you please help!

Thanks
Reply With Quote
  #4  
Old 11-10-2014, 09:01 PM
macropod's Avatar
macropod macropod is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

How did you insert the field braces (i.e. {})? Have you executed the merge, or are you just previewing it?

PS: On looking at your mailmerge main document again, I see you have the mergefields in textboxes. You really shouldn't be doing that. Insert them directly into the document body.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 11-10-2014, 11:08 PM
crussell crussell is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 64bit
Novice
fill in blank information
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

I pressed shift+f9 to show the codes and I just added the \b or \f followed by " " with the line break inside the braces that was shown or given when pressed shift+f9. I preview the document before I do anything to make sure it comes out properly. I removed the textboxes and insert the merge fields directly in the document. Am I doing this incorrectly?
Reply With Quote
  #6  
Old 11-11-2014, 12:19 AM
macropod's Avatar
macropod macropod is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

What you've described is correct. Having the mergefields in the textboxes would prevent the lines they occupy closing up.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 11-11-2014, 08:05 AM
crussell crussell is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 64bit
Novice
fill in blank information
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

I am still not getting the results as I would like to be. I am not sure what I am doing wrong. I followed the field codes in the mailmerge tips and tricks but it seems to be not working. I am sorry to be in pain. All I wanted to do is when mailing address 3 has no information then the city state and zip would enter this information in mailing address 3 line. Then city state and zip would be left blank since this information is already been pulled in mailing address 3 line.
Reply With Quote
  #8  
Old 11-11-2014, 01:58 PM
macropod's Avatar
macropod macropod is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try the attached.
Attached Files
File Type: doc RTbillingMod.doc (34.0 KB, 11 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 11-11-2014, 02:59 PM
crussell crussell is offline fill in blank information Windows 7 64bit fill in blank information Office 2010 64bit
Novice
fill in blank information
 
Join Date: Nov 2014
Posts: 9
crussell is on a distinguished road
Default

Thank you thank you and thank you... It worked. Yay!!! It was driving me bananas and so sorry for being annoying.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a fill in the blank Powerpoint? BillionGoldfish PowerPoint 1 10-04-2014 12:17 AM
fill in blank information Nested if field that contains a fill-in field is not prompting for fill-in info Nccadm Mail Merge 2 04-02-2013 03:15 AM
fill in blank information I can see my TOC but no information Becabica Word 14 05-22-2012 08:29 AM
Page numberring 1 - blank - 2 - blank etc Intern PowerPoint 0 09-02-2011 01:16 AM
fill in blank information How to turn all blank lines into non-blank for legal forms sieler Word 3 04-12-2009 01:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:54 AM.


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