Automatically formatting and printing messages

  • Thread starter Thread starter Double Dumbass on You
  • Start date Start date
D

Double Dumbass on You

I have an html form that sends an Email to my Outlook account. In the Email
is pertinent information that I would like to process in the following way:

-Format the body of the Email using a Word Macro/Auto-Format template
-Automatically Print the message
-Move the message to a folder entitled "Processed"

I am thinking that I can use an Outlook rule that would touch-off an Outlook
macro to select the body of the Email. The Outlook macro would then call MS
Word, passing the name of a Word macro as a parameter which Word would
execute on the contents of the clipboard and then close the application. I
plan on having the macros signed so that there would be no malignant
activity via macros.

Would this work or is there a more simplistic way to do the same apart from
the "mousetrap" approach. (cf. the parker brothers game "Mousetrap")

TIA.
 
One other thing, here is an example of what I am trying to accomplish:

Input Email:

Customer_Name=Joe Blow
Customer_Acctnum=12345678
Order_num=987654321
Order_amt=$55.00
Order_date=09072004

Output to Printer:

+---------------------------------------------------------------------------
----------------------------------------+
| Joe Blow
|
+---------------------------------------------------------------------------
----------------------------------------+
| 12345678 | 987654321 | $55.00
| 09/07/2004 |
+---------------------------------------------------------------------------
----------------------------------------+

(only in a nicely formatted invoice-type form.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top