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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Import MS Outlook messages into MS Access - The Email Body Loses Formatting 0
Importing Text Files Into Access 1
Automating Outlook from within Access 5
import hyperlinks into access 4
Outlook and hyperlinks 1
How do I syncronize my Access contacts with Outlook contacts while keeping my Access contacts as the 0
Invisible body text in Outlook 2007 5
Missing (invisible) body text in Outlook 2007 6

Back
Top