Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-09-2020, 03:16 AM
Trevor Mitchell Trevor Mitchell is offline Saving Mailmerge Template for future use Windows 10 Saving Mailmerge Template for future use Office 2016
Novice
Saving Mailmerge Template for future use
 
Join Date: Dec 2020
Location: Northern Ireland
Posts: 2
Trevor Mitchell is on a distinguished road
Default Saving Mailmerge Template for future use

I do a regular Mailmerge using the same label size/layout with an individual excel file but everytime I do it I have to start from scratch and set up the layout for the labels - insert merge field etc.

How can I save this once set up for future use so then all I have to do is go back in and decide if I want to print labels for the whole file of just a section ?
Reply With Quote
  #2  
Old 12-09-2020, 04:40 AM
macropod's Avatar
macropod macropod is offline Saving Mailmerge Template for future use Windows 10 Saving Mailmerge Template for future use Office 2010
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

So why don't you simply save the mailmerge main document once you've done all the set-up, including connecting to the data source? That's how it's normally done.

Having done that, you'll get an SQL prompt when you next open the document. Answer 'Yes' to that and it'll be ready to run the next merge.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving Mailmerge Template for future use Problem using a mailmerge template with new file JeffL Mail Merge 3 09-07-2020 04:32 PM
Saving Mailmerge Template for future use how to make a template with field and mailmerge to work together in protected mode pjkon Mail Merge 1 06-10-2019 04:35 PM
Saving Mailmerge Template for future use Mailmerge Excel with a Master Word Template (via VBA) stevenel Excel Programming 8 08-14-2018 03:05 PM
Saving Mailmerge Template for future use Template From MailMerge Document LouGibson Mail Merge 1 06-13-2016 03:14 PM
Saving Mailmerge Template for future use Automatic update of links in template - closing attached template without saving stefaan Word 2 11-02-2013 07:46 AM

Other Forums: Access Forums

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