Import Outlook Body as text only into Access

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.

--
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" <A.Gemmiti@gmail.com> wrote in message
news:1166152348.238580.185980@t46g2000cwa.googlegroups.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=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
>