Microsoft Office Forums Grouping multiple excel records in to a single letter

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-03-2018, 04:52 PM
lmjb1964 lmjb1964 is offline Grouping multiple excel records in to a single letter Mac OS X Grouping multiple excel records in to a single letter Office 2016 for Mac
Novice
Grouping multiple excel records in to a single letter
 
Join Date: Apr 2018
Posts: 3
lmjb1964 is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 04-03-2018, 05:01 PM
macropod's Avatar
macropod macropod is online now Grouping multiple excel records in to a single letter Windows 7 64bit Grouping multiple excel records in to a single letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-04-2018, 10:25 AM
lmjb1964 lmjb1964 is offline Grouping multiple excel records in to a single letter Mac OS X Grouping multiple excel records in to a single letter Office 2016 for Mac
Novice
Grouping multiple excel records in to a single letter
 
Join Date: Apr 2018
Posts: 3
lmjb1964 is on a distinguished road
Default 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
Attached Files
File Type: docx sample-Merge.docx (16.3 KB, 5 views)
File Type: xlsx sample-data.xlsx (15.3 KB, 4 views)
File Type: pdf sample-letter.pdf (49.1 KB, 8 views)
Reply With Quote
  #4  
Old 04-04-2018, 02:52 PM
macropod's Avatar
macropod macropod is online now Grouping multiple excel records in to a single letter Windows 7 64bit Grouping multiple excel records in to a single letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,487
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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).
Attached Files
File Type: docx sample-Merge.docx (18.8 KB, 9 views)
File Type: xlsx sample-data.xlsx (14.3 KB, 5 views)
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #5  
Old 04-04-2018, 03:33 PM
lmjb1964 lmjb1964 is offline Grouping multiple excel records in to a single letter Mac OS X Grouping multiple excel records in to a single letter Office 2016 for Mac
Novice
Grouping multiple excel records in to a single letter
 
Join Date: Apr 2018
Posts: 3
lmjb1964 is on a distinguished road
Default

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!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping multiple excel records in to a single letter Merging multiple excel records in to a single word doc? dns_to Mail Merge 1 10-20-2017 01:22 PM
Grouping multiple excel records in to a single letter Grouping records by supplier Franci Mail Merge 2 07-19-2016 10:25 PM
Grouping multiple excel records in to a single letter Merging multiple fields within a Word letter from Excel LindsayV Mail Merge 2 04-08-2016 07:17 AM
Grouping multiple excel records in to a single letter 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


All times are GMT -7. The time now is 03:31 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft