Thread: Save As Macro using first line of document as document name
View Single Post
 
Old 01-31-2015, 05:39 PM
redzan redzan is offline Windows 7 32bit Office 2003
Advanced Beginner
  
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