![]() |
#2
|
||||
|
||||
![]()
I don't know from Mail Merge—I've done it a few times, but not often enough to remember how—but it seems all you want, at least for now, is to copy a document with a known path and name to a new document with the current path and a calculated name. Nothing hard or complex about that, right? What am I missing?
First you calculate the new Word document name, probably using this formula: Code:
=$C$2&" "&$C$4&" "&$C$3&" "&$C$6&" "&TEXT($C$7,"m-d-yyyy")&"-"&TEXT($C$8,"m-d-yyyy")&".docx" Either I've misunderstood you, or there's some part of that you don't know how to do. If the latter, which part? I don't want to insult you by telling you all the things you already know and leaving out the one part that's confusing you. For the copying part, you could open up the Word application, then do an Open and a Save-As. But I'm sure it'll be simpler to access some Windows feature that does file copies. Is that the part you're having trouble with? Because if it is, I'd have to google it myself. Won't be hard, though. |
Tags |
excel 2010, excel vba, word 2010 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
mross127 | Word | 10 | 08-16-2017 04:41 PM |
Copy Underline text from Word and Paste into excel | rfaris | Excel Programming | 7 | 10-05-2015 05:56 AM |
![]() |
A_Lau | Drawing and Graphics | 3 | 12-19-2014 06:57 AM |
![]() |
raven26c | Word | 1 | 11-18-2011 02:49 AM |
copy/paste charts from excel to word | bielak01 | Excel | 0 | 04-16-2009 02:27 AM |