Hello.
So this is a fairly complicated question...hopefully this description makes sense
What I have:
Dozens of Word documents generated based on a template file, using mail merge to autocomplete specific parts of the file. Each contains an identically formatted first few rows. These rows contain info for the specific file, such as 'Subject', 'To', 'BCC', and 'File Name'.
What is manually done:
The body of the Word Document is copied into an Outlook email. The information on the top is Cut/Pasted into the appropriate fields, and the file is saved as an outlook template by the name listed in the header row for 'File Name', for later use. They are not sent at this time. The process of creating the templates is extremely time consuming, as it has to happen dozens or even hundreds of times per week.
What I want to do:
Send the document to myself as the body of an email from Word, using a keyword as the Subject.
Set up a Rule in Outlook to run a script on any email with that keyword in the Subject.
Script would essentially do what is currently manually done. The top rows would be copied into the appropriate fields, and deleted from the body. The file would then be saved as a template under the file name listed. The save to directory can be static. Since the format is exactly the same and always the top few rows, I figure this can be done programmatically with relative ease (i hope?).
What I am stuck on:
The script. I don't know anything about scripting in outlook, I'm mostly an Excel guy. I am having a hard time finding anything on this kind of issue.
Is my concept viable? Is there a better way to turn a word document into an outlook template file? How do I go about adding scripts to outlook? (i made a test Public Sub in VBA editor but the Script list is still empty in the New Rule wizzard?)
Thanks!
Bookmarks