Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2020, 04:24 AM
kathleen.lehnigk kathleen.lehnigk is offline Help with 2nd grouping - mail merge directory Windows 10 Help with 2nd grouping - mail merge directory Office 2019
Novice
Help with 2nd grouping - mail merge directory
 
Join Date: Nov 2020
Posts: 4
kathleen.lehnigk is on a distinguished road
Default

Thanks so much for your quick reply on this, Paul. Much appreciated

The hyperlinks in my initial document are surviving for me they are just not visually displayed with the blue colour. But thanks for showing me also an alternative way of producing these.

I've tested your version, but each job now appears on a new page and the Region is still displayed multiple times whenever there is a new school.

Thanks
Kathleen
Reply With Quote
  #2  
Old 11-25-2020, 12:58 PM
macropod's Avatar
macropod macropod is offline Help with 2nd grouping - mail merge directory Windows 10 Help with 2nd grouping - mail merge directory Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
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

Quote:
Originally Posted by kathleen.lehnigk View Post
I've tested your version, but each job now appears on a new page and the Region is still displayed multiple times whenever there is a new school.
That's because you haven't configured the mailmerge main document for a Directory merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-26-2020, 12:52 AM
kathleen.lehnigk kathleen.lehnigk is offline Help with 2nd grouping - mail merge directory Windows 10 Help with 2nd grouping - mail merge directory Office 2019
Novice
Help with 2nd grouping - mail merge directory
 
Join Date: Nov 2020
Posts: 4
kathleen.lehnigk is on a distinguished road
Default

Oh yes, I aplogise. That moved them all to one page.

You are brilliant, Paul

Your code worked perfectly, just added some line spaces, where necessary. Here my final version of your example: Mail merge template - amended version Paul.docm

Your code also helped me modifying my version as my colleague did not want to have the hyperlinks shown with the hyperlink colour. So, here my version, which does not require a macro: Mail merge template - jobs.docx

Thanks sooo much for your help. Really appreciated and I owe you one :-).

Best wishes
Kathleen
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with 2nd grouping - mail merge directory Mail Merge Grouping Catherine.DeMayo Mail Merge 2 09-30-2019 09:39 PM
Total formula for mail merge grouping jackmp3 Mail Merge 3 10-22-2018 12:40 PM
Help with 2nd grouping - mail merge directory Mail Merge Grouping Multiple Records into 1 Output DeniseStafiej Mail Merge 1 08-03-2018 03:41 PM
Help with 2nd grouping - mail merge directory mail merge multiple rows within a grouping tracygleghorn Mail Merge 12 11-12-2015 06:43 AM
Help with 2nd grouping - mail merge directory Grouping list in Mail Merge AlexTeslin Mail Merge 1 03-08-2013 09:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:13 AM.


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