Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-07-2020, 02:40 AM
Jacqueline Jacqueline is offline Excel to Word Using Mail Merge Windows 10 Excel to Word Using Mail Merge Office 2016
Novice
Excel to Word Using Mail Merge
 
Join Date: Oct 2020
Posts: 1
Jacqueline is on a distinguished road
Default Excel to Word Using Mail Merge

Hi, I have a few problems when using Mail Merge to open Word from Excel. As I am unable to automate the process and save the format I use for the labels, I need to select the format after every use.

I have an Excel worksheet filled with shipping details that I need to format into labels.

I want to write a code for the following:
1. Have a button in excel where it will automatically generate the shipping labels through mail merge
2. Ensure that the format of the shipping labels are identical to the preset formatting (E.g. size and alignment)

I have attached the excel and word.



Courier's Template.xlsm

Label Format.docx
Reply With Quote
  #2  
Old 10-07-2020, 04:12 AM
gmayor's Avatar
gmayor gmayor is offline Excel to Word Using Mail Merge Windows 10 Excel to Word Using Mail Merge Office 2016
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

Your preset formatting is not a standard label format. It has rows of differing heights and they differ because the text will not fit the 2.54cm row height and you have the row height set to at least 2.54 rather than exactly 2.54.

In order for this to stand a chance of working you are going to have to use a smaller font with reduced spacing between the paragraphs (say 9 pt Calibri) or you are going to need a bigger label stock.

I assume that you will want different numbers of each label according to the records, in which case the easiest way to handle that and avoid a lot of programming, would be to add the requisite number of records. You can then run a simple mailmerge using your label document as the merge document.



__________________
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
Excel to Word Using Mail Merge Excel to Word Table via Mail Merge ged147 Mail Merge 4 11-28-2018 02:52 AM
Excel to word Mail Merge problem mark_kofi Mail Merge 4 07-17-2018 03:49 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA RMerckling Mail Merge 16 05-17-2018 05:19 PM
Excel to Word Using Mail Merge Word Mail Merge with Excel Graph s.unsworth Mail Merge 2 11-21-2014 05:57 PM
Mail merge table from Excel to Word krezumica Mail Merge 2 03-06-2014 10:26 PM

Other Forums: Access Forums

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