|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
#1
June 22nd 06, 06:00 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Copying text from Outlook message to Excel
Am 20 Jun 2006 22:15:54 -0700 schrieb :
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. -- Viele Gruesse / Best regards Michael Bauer - MVP Outlook -- www.VBOffice.net -- 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 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Saving Subject Text in Excel Doc | bbkixx | Outlook and VBA | 1 | June 15th 06 05:09 PM |
| capture Outlook text and export to Excel | Denise | Outlook and VBA | 4 | June 10th 06 06:37 PM |
| extracting mailitem.body text to Excel columns | Junoon | Outlook and VBA | 3 | April 20th 06 05:45 AM |
| Copying PST file resets unseen-message info | Michael Kairys | Outlook - General Queries | 6 | April 12th 06 08:42 PM |
| Copying to a text field in Contacts loses formatting | Jaime | Outlook - Using Contacts | 1 | March 9th 06 11:23 PM |
Hybrid Mode
