Incoming Message
Do you mean, the data is written within the message text? You can extract
that by using the functions Instr, Left, Right, and Mid. Every function is
explained in the VBA help.
--
Best regards
Michael Bauer - MVP Outlook
: VBOffice Reporter for Data Analysis & Reporting
: Outlook Categories? Category Manager Is Your Tool
: http://www.vboffice.net/product.html?pub=6&lang=en
Am Tue, 15 Jul 2008 12:21:01 -0700 schrieb MEG:
I have messages sent to me from a company in a standard format.
The message has fields and data from a form and therefore is in the same
location each time.
When a new message arrives, I'd like to read the message text and then
extract certain data (i.e. email address, First Name, Last Name, etc).
Using these fields, I'd like to send a response inserting the above
extracted data into the message.
What is the best way to do this?
If macros are the way to go, is there sample code to do this?
Thanks,
MEG
|