|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
December 15th 06, 04:12 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
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=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 |
|
#2
December 15th 06, 03:40 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlook 2003 sending blank emails / text missing from body | Keith | Outlook - General Queries | 3 | June 1st 06 02:57 PM |
| Duplicate emails with different text body | Martin | Outlook - General Queries | 2 | May 28th 06 11:35 PM |
| automating body text search | Edward | Outlook and VBA | 7 | April 10th 06 05:28 PM |
| Outlook won't display body of plain text message | Mike | Outlook - General Queries | 1 | March 14th 06 07:54 PM |
| How do I append text to the body of a email? | Beginner | Outlook and VBA | 2 | February 9th 06 10:36 PM |
Linear Mode
