#1
|
|||
|
|||
Grouping multiple excel records in to a single letter
Hi. I'm using the MailMerge tutorial macropod created (http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip), thank you so much! Its been really helpful. However, in the merged document, I can't get the column spacing right. I was trying to do it with tabs, but if one of the class titles is shorter than the others, the next column is not in the right place. Your columns all line up so neatly, but I can't see the magic coding you used to get it that way. Thanks! |
#2
|
||||
|
||||
I'd need to see both your mailmerge main document and a another document with the desired layout before I could help with that; otherwise I'd just be guessing at what you want to achieve.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Formatting output in Mailmerge
That was an amazingly fast response, thank you! I've attached the merge document with the code, some sample data, and a PDF of the output. I would very much appreciate any advice you can give.
Laura |
#4
|
||||
|
||||
The problem with your mailmerge main document is that you're trying to use spaces and multiple tabs between the 'columns' to achieve the desired alignment instead of single tabs with appropriately-positioned tab-stops. This is basic document formatting. See attached update. I've also added the necessary logic to suppress the output of all the in-use empty rows your workbook has below the actual data, plus, I deleted the extraneous line-break after 'College' in the workbook (which was messing with the 'College' field name).
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
OK, I feel silly. It didn't occur to me that if I set tabs or other formatting in the merge document, those would carry over to the final document; I thought the new document would have just your default formatting. That makes sense, and makes things so much simpler! I have a footer that I want to use also, and now I realize I can just add that into the merge document too.
The data that I sent was not the actual file that I'll be using, just didn't want to send actual personal information, so there shouldn't be any extra rows, but I will check that code out as well. Thank you so much. I've been working so hard to figure out the coding, I wasn't thinking about the basics! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging multiple excel records in to a single word doc? | dns_to | Mail Merge | 1 | 10-20-2017 01:22 PM |
Grouping records by supplier | Franci | Mail Merge | 2 | 07-19-2016 10:25 PM |
Merging multiple fields within a Word letter from Excel | LindsayV | Mail Merge | 2 | 04-08-2016 07:17 AM |
How to combine several records in a single letter in Word 2010 | May | Mail Merge | 3 | 03-25-2015 03:36 AM |
Excel 2007-How to merge multiple records into one | mag | Excel Programming | 1 | 11-21-2012 12:11 AM |