Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-01-2022, 04:10 PM
Karen615 Karen615 is offline Mail Merge label that has been split into four sections Windows 7 64bit Mail Merge label that has been split into four sections Office 2010 64bit
Competent Performer
Mail Merge label that has been split into four sections
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default Mail Merge label that has been split into four sections

Using Word/Excel 365



I have a label (Avery 5866) that I am using in a mail merge. I have split the label into four sections by using the "draw table" function. When I attempt to mail merge, I get the message, "In order to apply the selected label options, Word must delete the current contents of "Label 5866.docx"

Is there a workaround for this so I can use this existing document?

See attached for both documents.

Your help is greatly appreciated.

Thank you,
Karen
Attached Files
File Type: docx Label 5866.docx (15.6 KB, 9 views)
File Type: xlsx Mail Merge Spreadsheet.xlsx (11.0 KB, 6 views)
Reply With Quote
  #2  
Old 06-02-2022, 05:47 AM
macropod's Avatar
macropod macropod is offline Mail Merge label that has been split into four sections Windows 10 Mail Merge label that has been split into four sections Office 2016
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

Word can't use what you have for a label merge.

What you could do is delete all except the first cell you modified, format the document as having a two-column page layout, minimise & hide the paragraph following the table, then use a Directory/Catalog merge.

See attached. You may yet need to adjust the intra-column spacing.
Attached Files
File Type: docx Label 5866.docx (12.6 KB, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 06-05-2022, 05:14 PM
Karen615 Karen615 is offline Mail Merge label that has been split into four sections Windows 7 64bit Mail Merge label that has been split into four sections Office 2010 64bit
Competent Performer
Mail Merge label that has been split into four sections
 
Join Date: Jun 2011
Location: Chicago
Posts: 112
Karen615 is on a distinguished road
Default

Thank you so much for your recommendation.

I'm not familiar with directory/catalog merge, but I will research it and get back to you to see if I can figure it out.

Thank you!
Reply With Quote
  #4  
Old 06-06-2022, 12:30 AM
gmayor's Avatar
gmayor gmayor is offline Mail Merge label that has been split into four sections Windows 10 Mail Merge label that has been split into four sections Office 2019
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

Why split the cells? You could simply use a right aligned tab and appropriate paragraph spacing, then merge to labels.
Attached Files
File Type: docx Label 5866_A.docx (15.4 KB, 8 views)
__________________
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
Mail Merge label that has been split into four sections Mail Merge is appending blank label to every legit label Involute Mail Merge 2 12-11-2020 08:52 PM
Mail Merge label that has been split into four sections Mail Merge - split merged documents and rename each split document based on text in header FuriousD Word VBA 1 05-12-2019 04:06 AM
Mail Merge label that has been split into four sections Label Mail Merge Costco25 Mail Merge 1 12-01-2016 03:25 PM
Mail Merge label that has been split into four sections Editing a mail merge label Colonel Biggs Word 6 03-22-2015 07:09 AM
Mail Merge label that has been split into four sections How to start a label mail merge at a specific label? DHKaplan Mail Merge 2 04-17-2014 07:33 PM

Other Forums: Access Forums

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