Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2015, 05:39 PM
redzan redzan is offline Save As Macro using first line of document as document name Windows 7 32bit Save As Macro using first line of document as document name Office 2003
Advanced Beginner
Save As Macro using first line of document as document name
 
Join Date: Feb 2012
Posts: 37
redzan is on a distinguished road
Default Save As Macro using first line of document as document name


Hello,

I run a mail merge from excel to word with many sheets. I have recorded this in a macro so my end result is a bunch of open windows with the top line highlighted. I then hit Ctrl-C to copy that line followed by F12 to and paste to save the document. Is there a way to automate this with a macro?

Thanks
Reply With Quote
  #2  
Old 01-31-2015, 09:24 PM
macropod's Avatar
macropod macropod is offline Save As Macro using first line of document as document name Windows 7 64bit Save As Macro using first line of document as document name Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 20,499
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

See 'Send Mailmerge Output to Individual Files' and 'Split Merged Output to Separate Documents' in the Mailmerge Tips and Tricks thread in our Mailmerge forum, at:
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
Save Every 2 pages of Word Document as the First Line of Text Faugs Word VBA 6 08-13-2014 11:50 PM
Save As Macro using first line of document as document name How to save a macro in a document generated with a word model? Cristin7 Word VBA 4 03-25-2014 03:25 AM
Save As Macro using first line of document as document name Macro to create new word doc and save the file using String found in the document VBNation Word VBA 2 02-08-2013 07:14 AM
Word ask to save template whenever i save a derived document jorbjo Word 3 10-04-2012 10:52 AM
Put File Name Of A Document On Line 1 Of The Document mikeburg Word 0 12-14-2007 08:14 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 06:00 AM.


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