+ Reply to Thread
Results 1 to 2 of 2

Creating a Rule to automatically save received emails as Template files

  1. #1
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Creating a Rule to automatically save received emails as Template files

    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!
    Last edited by Speshul; 11-23-2015 at 11:03 AM.
    You should hit F5, because chances are I've edited this post at least 5 times.
    Example of Array Formulas
    Quote Originally Posted by Jacc View Post
    Sorry, your description makes no sense. I just made some formula that looks interesting cause I had nothing else to do.
    Click the * below on any post that helped you.

  2. #2
    Valued Forum Contributor
    Join Date
    01-19-2012
    Location
    Barrington, IL
    MS-Off Ver
    Excel 2007/2010
    Posts
    1,211

    Re: Creating a Rule to automatically save received emails as Template files

    bump

    Any ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 07-23-2015, 06:46 AM
  2. Search and Replace patterns of strings with a RULE with any new message received.
    By sev7en in forum Outlook Programming / VBA / Macros
    Replies: 0
    Last Post: 05-04-2015, 09:37 AM
  3. Can I set a rule to delete mail with a specific subject and not received today?
    By mrkhchan in forum Outlook Programming / VBA / Macros
    Replies: 4
    Last Post: 03-19-2015, 12:43 PM
  4. Replies: 1
    Last Post: 02-10-2014, 09:13 PM
  5. Create rule to save specified emails to hard drive
    By theletterh in forum Outlook Programming / VBA / Macros
    Replies: 4
    Last Post: 06-12-2013, 06:04 AM
  6. weird font on received emails
    By Peeps32 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 03-08-2012, 10:04 AM
  7. Count of emails by folder and received date
    By TypicalDru in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-16-2012, 04:48 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1