Copying text from Outlook message to Excel

  • Thread starter Thread starter andy_hammer2001
  • Start date Start date
A

andy_hammer2001

Hi

I am familiar with Excel vba, have never tried anything in outlook
though.

In order to automate a task I wish to (when a button is clicked) run a
macro that will search for a particular instance of a word in an open
mail message and copy the rest of the text (after that instance of the
word) and paste into a new excel worksheet

Using Outlook 2003 and Excel 2000.

This is the first step, is this possible.

Thanks

Andy
 
Am 20 Jun 2006 22:15:54 -0700 schrieb (e-mail address removed):

The currently opened message is Application.ActiveInspector.CurrentItem.
Search in that object´s Body property with the Instr function. In case of a
match it returns the start position. Mid(Text, Position) then returns the
rest after that position.
 
Back
Top