Import Outlook Body as text only into Access

  • Thread starter Thread starter LI_SpeedyG
  • Start date Start date
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
 
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.
 
Back
Top