Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-25-2022, 11:15 PM
Caerleon Caerleon is offline Filename and seperating docs Windows 10 Filename and seperating docs Office 2021
Novice
Filename and seperating docs
 
Join Date: Sep 2015
Location: London UK
Posts: 5
Caerleon is on a distinguished road
Default Filename and seperating docs

I am using a excel sheet to export rows of data. I have created a template with all the fields and it works as a 'letter'! When I go to preview - I have one doc shown correctly, then I go to merge docs of about 20 in the excel sheet and it creates the first doc then adds all the other 20 docs within the same output doc?




I want obviously for it to seperate each by line and secondly, how do i save it with the reference from within the excel as the file name?


I have searched and cannot find a clear explanation of what is going wrong.


Any help is appriciated.
Reply With Quote
  #2  
Old 11-26-2022, 04:42 AM
macropod's Avatar
macropod macropod is offline Filename and seperating docs Windows 10 Filename and seperating docs Office 2016
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

See:
Send Mailmerge Output to Individual Files; and
Run a Mailmerge from Excel, Sending the Output to Individual Files,
in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum (https://www.msofficeforums.com/mail-...ps-tricks.html).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
filename field not displaying correct filename when that name starts with # plrsmith Word 1 07-06-2018 03:10 AM
Filename and seperating docs Filename UnlimitedPower Word VBA 1 08-19-2016 12:22 AM
Seperating Excel from Pivot KevinD Excel 3 11-12-2014 08:13 AM
Filename and seperating docs Seperating Microsoft Word documents into seperate documents nanders8 Word VBA 2 08-28-2014 09:37 PM
Filename and seperating docs Seperating text data philb Excel 4 10-31-2013 10:37 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:39 PM.


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