View Single Post
  #2  
Old December 15th 06, 03:40 PM posted to microsoft.public.outlook.program_vba
Ken Slovak - [MVP - Outlook]
external usenet poster
 
Posts: 5,848
Default Import Outlook Body as text only into Access

You can get the email text as HTML using item.HTMLBody. That returns a
string to you. From there you can use string parsing methods to take things
apart.

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"LI_SpeedyG" wrote in message
oups.com...
Hi,

I have been looking for a way to resolve Hyperlinks into it "text only"
part(s) when importing from Outlook into Access.

Example--

Raw import currently:
HYPERLINK
""https://www.site.com/nrp.jsp?tnum=906176936668&language=en&clienttype=i vother&opco=XX""906176936668

Text Only Should read:
906176936668

If not possible I will need to find alternate methods. So, I would
appreciate any direction you can point me towards..

Thanks In Advance,
SpeedyG


Ads