Importing from a Form

[semiaza]

Hi All,

I've asked for help in microsoft.public.excel.programming and was
directed here.

I recieve emails created by an Outlook Template. In it is a form with 3
text boxes - textbox1, textbox2 etc... I want to use VBA within Excel
to access the data in these textboxes but the only references I can
find are regarding accessing these textboxes from within Outlook.

The Excel VBA I'm working with is as follows:

For Each olMail In Fldr.Items
If InStr(olMail.Subject, "Test") > 0 Then
ActiveSheet.Cells(i, 1).Value = ????
ActiveSheet.Cells(i, 2).Value = ????
ActiveSheet.Cells(i, 3).Value = ????
i = i + 1
End If
Next olMail

Where ???? is the code I'd need to access the textboxes. Does anyone
here have any experience of this? Any help at all would be most
welcome.

TIA

Semiaza

 

[Sue Mosher [MVP-Outlook]]

Presumably those text boxes are bound to Outlook properties. See
http://www.outlookcode.com/d/propsyntax.htm for the basics of getting and
setting Outlook property values.

 

[semiaza]

Thanks Sue - got the info I needed from the links you gave. Can now
successfully import as required.