Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2015, 02:35 PM
commissarmo commissarmo is offline Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Windows 8 Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Office 2013
Novice
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?
 
Join Date: Mar 2015
Posts: 3
commissarmo is on a distinguished road
Default Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?

Hi I have no experience with VBA. Office 2013



I have a task at work that is very tedious which I want to automate.

1. I use MailMerge to create say 400 pages of addressed letters.

2. I need to save EACH letter into a separate word document for each person, and then name the file automatically. (Using the first line to automatically name the file is ok, as I've already set it up that the first line of the document is the desired file naming format).

3. There IS I am quite sure, a way to do this. This link shows someone contributing code that seems to do just this.

http://answers.microsoft.com/en-us/o...0eb834a?page=3

4. Unfortunately, and perhaps it is because I am not using it correctly given my zero skill with macros, the code in that link DOES NOT work for me.

5. I'm hoping someone can help?

Thanks
Reply With Quote
  #2  
Old 03-13-2015, 03:57 PM
commissarmo commissarmo is offline Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Windows 8 Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Office 2013
Novice
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?
 
Join Date: Mar 2015
Posts: 3
commissarmo is on a distinguished road
Default

Ok basically I solved this problem.

I didn't learn how to use a Macro to do it... but someone basically wrote an entire Word Add-on that does all of this for you automatically with a lot of good features too.

http://www.gmayor.com/individual_merge_letters.htm

I recommend just using this. I tried it and its great. The instructions are QUITE tedious and hard to follow, but make sure you just slog through it top to bottom before installing it. You don't need to go into the Word Startup folder apparently despite what the instructions say - the program has a self-extracting installer which auto installs itself. MAKE SURE WORD IS CLOSED BEFORE INSTALLING OR IT WON'T WORK.

Learning to write Macros is cool but... given this person did so much work on this free addon, I'm just going to use this. I recommend donating to him if you use it. It should come built in to Word at this point in time of the program's history.
Reply With Quote
  #3  
Old 03-13-2015, 04:06 PM
commissarmo commissarmo is offline Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Windows 8 Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Office 2013
Novice
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line?
 
Join Date: Mar 2015
Posts: 3
commissarmo is on a distinguished road
Default

Ok basically I solved this problem.

I didn't learn how to use a Macro to do it... but someone basically wrote an entire Word Add-on that does all of this for you automatically with a lot of good features too.

http://www.gmayor.com/individual_merge_letters.htm

I recommend just using this. I tried it and its great. The instructions are QUITE tedious and hard to follow, but make sure you just slog through it top to bottom before installing it. You don't need to go into the Word Startup folder apparently despite what the instructions say - the program has a self-extracting installer which auto installs itself. MAKE SURE WORD IS CLOSED BEFORE INSTALLING OR IT WON'T WORK.

Learning to write Macros is cool but... given this person did so much work on this free addon, I'm just going to use this. I recommend donating to him if you use it. It should come built in to Word at this point in time of the program's history.
Reply With Quote
  #4  
Old 03-14-2015, 12:53 AM
gmayor's Avatar
gmayor gmayor is offline Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Windows 7 64bit Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Thanks for the plug.

The add-in is supplied in two forms - a self extracting zip file and the bare template. Some users prefer manual installation so this allows that option.

As for the instructions. This is a complex add-in with lots of features that required documenting. If you think that tedious, just wait until you try http://www.gmayor.com/ManyToOne.htm. Now that IS complicated.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? Copying a part of a docx file as a separate file officeboy09 Word 6 09-26-2014 05:15 PM
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? How to convert a text file to an Excel file with the data format automatically? mradmin Excel 6 10-16-2013 10:34 AM
How to have a heading 1 file automatically appear in each header of any page? expert4knowledge Word 2 09-16-2012 10:38 AM
How to save the current page in a new file with all the page settings (header, footer Jamal NUMAN Word 6 03-15-2012 03:27 PM
Auto Save Every Page(s) as a separate file, and name each new file automatically by the first line? How to copy automatically data from Excel file to Word file? fuchsd Word 6 10-25-2011 05:52 AM

Other Forums: Access Forums

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