Extracting cell data from table

Status
Not open for further replies.

mike w

Member
Outlook version
Email Account
POP3
Hi, New here
I'm using outlook 2003

Have a a single table in a email body, it has 2 columns and 9 rows (see below):
It is the results from a email enquiry and it is a table with <td>'s etc.
I would like to extract the data from the <td's>. The Name, Telephone, Date, etc
this is what i have so far, but it is extracting the complete rows.
sText = oMail.Body
vText = Split(sText, Chr(13))
For i = UBound(vText) To 0 Step -1
If InStr(1, vText(i), "Full-name:") Then
strGBP = vText(i + 0)
Exit For
End If
Next i

Any help you be appreciated, even if it mean a different approach. The <td> cells don't have id's

Full-name: john doe
Email: mjohn@yahoo.co.uk
Venue: white house
Telephone: 12345678
Date: Fri, 29 January 2016
Service: phones
Comments:
Contact:
E-Mail
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
After the row with "full-name" is found, again use Instr in that row to find the next <td> and </td>. The text between both is the value you're looking for.
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
D Outlook VBA error extracting property data from GetRules collection Outlook VBA and Custom Forms 10
B Extracting email addresses from a folder - how to also get the name of the person the address is for? Using Outlook 5
O Extracting all mail addresses from all folders Using Outlook 10
A Extracting only one recipient from Msgitem.To Outlook VBA and Custom Forms 7
Z Default VBA code for extracting data from email (Outlook) to Excel? Outlook VBA and Custom Forms 1
V Extracting user-defined details from a public folder Outlook VBA and Custom Forms 2
M Oh please read---> Extracting email web leads on to excel spread sheet Using Outlook 3
J Need Help Extracting Email Content into Excel Specifically the Attachment Name Using Outlook 3
D Extracting Location info from All Day Event in mailboxes into webpage Exchange Server Administration 3
E Extracting CC Email Address Using VBA Outlook VBA and Custom Forms 2
K Extracting Calendar information from a OST file? Exchange Server Administration 5
S Find a cell value in excel using outlook vba Using Outlook 1
M Linking Excel Cell to Shared Contacts Outlook VBA and Custom Forms 7
C Copy Cell value from Excel and paste into current email Outlook VBA and Custom Forms 10
D Outlook VBA to open Excel attachment and send recipient's email address to a workbook cell? Using Outlook 4
E Outlook 2007 bottom cell missing. Using Outlook 1
1 how to connect my cell phone number with my outlook 2007 Using Outlook 3
J cannot copy and paste while in list view in-cell editing Using Outlook 1
J Outlook 2013 Change color of text in data fields of contacts in Outlook 2013? Using Outlook 9
T How can Exchange be configured to sync/push one-way so that the server data can't be affected Exchange Server Administration 0
C Can't create Outlook data file Outlook Wishlist 0
T Extract Data From Outlook Tasks Using Outlook 0
F outlook.com Exchane Server corrupts data Since September 2019 Using Outlook.com accounts in Outlook 6
T Extract Data From Outlook Tasks Using Outlook 0
E To convert imported data to custom fields in Task list Outlook VBA and Custom Forms 1
R "Can't store Outlook data files under the AppData folder. Please choose another folder." Using Outlook 6
C How to export Outlook data to csv? Using Outlook 0
RBLampert Assigning a newly (re)created e-mail account to a specific .pst data file Using Outlook 2
S newly added shared mailboxes downloading 500GB data a day Exchange Server Administration 1
M Using field names to capture a data element Using Outlook 0
S Custom Form, copy user field data to message body Outlook VBA and Custom Forms 12
M Outlook 2016 Requesting data from server Using Outlook 0
G Entered data in custom field goes in card and does not stay in list view Outlook VBA and Custom Forms 1
E Copying data from e-mail attachement to EXCEL file via macro Outlook VBA and Custom Forms 38
Sofia Manni Some of my favorite data in outlook. Using Outlook 2
A Outlook 2016 Will Not Show Any Data In the People Pane Using Outlook 15
A Script to fetch data from mails in restricted collection and sending them to excel Using Outlook 1
Commodore Search cannot complete the indexing of your Outlook data Using Outlook 6
P Microsoft Outlook is requesting data from the server Using Outlook 2
S BCM Auto Backup Data and Customizations BCM (Business Contact Manager) 6
K How to access emails found to be located in "Top of Outlook data file"? Using Outlook 3
M adding corresponding contact form data on a mass scale Using Outlook 5
J Calendar data can be viewed on Outlook.com, but no longer syncs to Outlook 2013 Using Outlook.com accounts in Outlook 3
M Retrieve data from GAL and put it in Clipboard Using Outlook 1
G How to Copy Multi Select Listbox Data to Appointment Outlook VBA and Custom Forms 3
G Using Data From Combo Box in Appointment Body Outlook VBA and Custom Forms 6
P How to copy and append data from Outlook 2016 message into Excel 2016 workbook Using Outlook 0
Diane Poremsky Set Another Data File as Default When Using an Exchange Account New Slipstick.com Articles 0
Diane Poremsky How to Compact the Data File When you Close Outlook New Slipstick.com Articles 0
T Uploading Outlook 2016 Contacts to Exchange Server Drops "Company" field data in 30% of records Exchange Server Administration 4

Similar threads

Top