Import Outlook Body as text only into Access

L

LI_SpeedyG

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=ivother&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
 
K

Ken Slovak - [MVP - Outlook]

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.
 
Top