This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

Word Mail Labels - Add a line & predefined text if missing from label - help

Question
0

Sign in to vote

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!

Tuesday, December 24, 2019 2:53 PM

All replies

0

Sign in to vote
Hi,

In my opinion, maybe you could try a workaround: Back up the document first, convert these labels back into Word Mail Merge data file, then recreate the labels and add the line.

1. To convert labels into Word Mail Merge data file, please refer to:

https://docs.microsoft.com/en-us/office/troubleshoot/excel/save-mail-merge-label-document-addresses

http://www.gmayor.com/convert_labels_into_mail_merge.htm

Please Note: Since the web site is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.

2. Then create labels via Mail Merge

To create labels, please refer to:

https://support.office.com/en-us/article/create-and-print-labels-82086c07-2afa-4982-9d7d-9c9141d5035b

If you have any updates, please feel free to let me know.

Best Regards,

Emily

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.
- Proposed as answer by Herb GuMicrosoft contingent staff Thursday, December 26, 2019 9:55 AM
Wednesday, December 25, 2019 9:32 AM
0

Sign in to vote
Cross-Posted at: https://www.msofficeforums.com/word/44104-word-mail-labels-add-line-predefined-text.html

Please answer the question I asked you there.

For cross-posting etiquette, please read: A Message to Forum Cross-Posters http://www.excelguru.ca/content.php?184

Charles Kenyon Madison, WI
- Edited by Charles Kenyon Wednesday, December 25, 2019 1:12 PM
Wednesday, December 25, 2019 1:11 PM
0

Sign in to vote

Yes, there is a way.

Add the line to your label definition (and use individual fields rather than the sketchy "address block."
Charles Kenyon Madison, WI

Sunday, December 29, 2019 2:29 AM
0

Sign in to vote

Hi,

I am checking the status of this issue. Do you have any update for it?

Anything unclear or any questions, feel free to post them back to let us know. I will be glad to follow up and help you.

Best Regards,

Emily

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnsf@microsoft.com.

Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

Monday, December 30, 2019 1:13 AM