Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-24-2019, 08:15 AM
wordquestions wordquestions is offline Word Mail Labels - Add a line & predefined text if missing from label - help Windows 10 Word Mail Labels - Add a line & predefined text if missing from label - help Office 2010
Novice
Word Mail Labels - Add a line & predefined text if missing from label - help
 
Join Date: Dec 2019
Posts: 3
wordquestions is on a distinguished road
Question Word Mail Labels - Add a line & predefined text if missing from label - help

Hello,

I have about 1200 labels with names and addresses in a word doc.

Example:

Mary Smith


123 Spring Lane
Anytown, NY 10001

The ideal outcome would for the labels to come out with the additional line and text italicized in the example below:

Mary Smith
Or Current Resident
123 Spring Lane
Anytown, NY 10001

Is there a way for word or mail merge to add this missing line & predefined text to all labels? I'm stuck looking for answers, and my last resort will be to C&P manually.

Thanks for your help/answers in advance and happy holidays!
Reply With Quote
  #2  
Old 12-24-2019, 09:52 AM
Charles Kenyon Charles Kenyon is offline Word Mail Labels - Add a line & predefined text if missing from label - help Windows 10 Word Mail Labels - Add a line & predefined text if missing from label - help Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I assume that you are using Mail Merge to produce your labels. Is that correct?
Mail merge using an Excel spreadsheet - Word
Reply With Quote
  #3  
Old 12-25-2019, 06:14 AM
Charles Kenyon Charles Kenyon is offline Word Mail Labels - Add a line & predefined text if missing from label - help Windows 10 Word Mail Labels - Add a line & predefined text if missing from label - help Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default


Cross-Posted at: Word Mail Labels - Add a line & predefined text if missing from label - help


For cross-posting etiquette, please read: A Message to Forum Cross-Posters
Reply With Quote
  #4  
Old 12-28-2019, 01:18 PM
wordquestions wordquestions is offline Word Mail Labels - Add a line & predefined text if missing from label - help Windows 10 Word Mail Labels - Add a line & predefined text if missing from label - help Office 2010
Novice
Word Mail Labels - Add a line & predefined text if missing from label - help
 
Join Date: Dec 2019
Posts: 3
wordquestions is on a distinguished road
Thumbs up

Quote:
Originally Posted by Charles Kenyon View Post
I assume that you are using Mail Merge to produce your labels. Is that correct?
Mail merge using an Excel spreadsheet - Word
Yes, you are correct. Let me post there -- Thanks!
Reply With Quote
Reply

Tags
labels, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Word Mail Labels - Add a line & predefined text if missing from label - help Mail Merging labels for paper rolls in Word 2007 blackystrat Mail Merge 1 12-24-2015 03:21 AM
Word Mail Labels - Add a line & predefined text if missing from label - help How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM
Create mail label template Word 2003 Jack33 Mail Merge 2 03-07-2014 08:35 PM
Word Mail Labels - Add a line & predefined text if missing from label - help Mail Merges Shifts Labels One Label per Page Reg1987 Mail Merge 3 12-03-2011 08:24 AM
word 2003 mail merge labels? JoeGrapes Mail Merge 0 04-20-2009 12:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:26 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