Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

3rd Time of Asking - Getting Data from Outlook Form Based on Excel

Status
Not open for further replies.

Grippen

Technical User
Sep 3, 2001
24
GB
Hello,

Nobody seems to know how to help me - can you? - Third time lucky!

I am in an Outlook Form and want to set a User_Defined Field to a value in another "DataRecord" form. The DataRecord Form is an Outlook "Document Form" based on Excel.

The code below works - it finds and displays the "DataRecord" I'm after by Serching for "OpNo" - which is a User_Defined Custom Property on the Excel Form..

Sub cmdOpenDataForm_Click

Set myItems = oDataFolder.Items
Set oCriteria = item.userproperties.find("Criteria Field")
FinString = "[OpNo] = """ & oCriteria &""""
Set DataRecord = myItems.Find(FinString)
DataRecord.Display

end Sub


What I can't get to work is reading in the data I need.

I've tried adding to the above in all sorts of variations for example ....

Set oReadInData = Financials.userproperties("Data")
item.userproperties.find("RetrievedData") = oReadInData


but no Joy.

Can you help?

Thanks

Grippen

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top