Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing from Outlook
Hi folks - wondering if someone can put me right:
I receive emails generated by an Outlook Template. The email has a 1 page form (p.2) and that form contains three textboxes (textbox1, textbox2 etc). I'm trying to get Excel to access the data in these textboxes and import it into a worksheet but for the life of me I can't figure out how. Best I've been able to do is copy the body of the email (not what I need). Here's the vba I need to work on: For Each pMail In Fldr.Items If InStr(pMail.Subject, "Test") 0 Then ActiveSheet.Cells(i, 1).Value = ???? i = i + 1 End If Next pMail Where ???? is the code I need help with. I've looked everywhere I can find but can't find any information on importing from forms. Anybody got any clues at all? TIA Semiaza. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing Excel via Outlook | Excel Discussion (Misc queries) | |||
Importing from Excel in to outlook | Excel Discussion (Misc queries) | |||
Help with importing from Outlook | Excel Worksheet Functions | |||
Importing email from outlook | Excel Programming | |||
I could really need your help on importing contacts into Outlook (Please?) | Excel Programming |