Hello,

I am trying to automatically create a Outlook New email based upon an incoming email and a lookup table.

1. Receive a PayPal payment email notification.
2. Automatically read that email and pull out a few pieces of information.
3. Then generate a New email by populating a template email with the pulled pieces of information and a lookup table.
4. The “To & Bcc” address of this email would be determined by a lookup table currently in excel.
5. Once complete, then HOLD the email in a folder for manual check.


Does anyone have experieince with something like this, if not, can you point me in the right direction.

Thanks again...