#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
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 |