excel spreadsheet in contact form

[GolfGal]

I have created a custom contact form, and used several 'tabs' on one is an
excel spreadsheet. However, since this is not bound, it does not save with
the contact form.

I know there is some code I would need, however I have no idea how to do
that. I've seen postings on it elsewhere, however, I also don't know where
to enter it so that it works. Help please.

Thanks

 

[Sue Mosher [MVP-Outlook]]

See http://www.outlookcode.com/d/spreadsheetcontrol.htm . You enter code in the form's code window. Press the View Code button in design mode.

 

[GolfGal]

I've done a bit of code in access, but in the code window, how does it know
what control the code is associated with?

Also, I did visit http://www.outlookcode.com/d/spreadsheetcontrol.htm before
posting question. Duh! moment, but I just don't get it. I need the notes
field. And am I suppose to put the excel sheet into another large text field
to use that code?
Forgive my stupidity, but I can manipulate a form pretty well...(exc that
now one I worked for hours on won't display, posted for help elsewhere here)
but when it comes to code, I am lost.

 

[Sue Mosher [MVP-Outlook]]

Outlook form VBScript is event-driven. Controls (and only certain unbound controls) expose only a CLick event. So, if you see ControlName_Click, you know that the code is associated with a control.

If you can't use the item body to hold the spreadsheet information, you'll have to store it somewhere else. A text field is a possibility, although you need to be aware that an item can store a maximum of 32k of data outside the body. For anything larger, it might be necessary to use an attached file, reading from and writing to it as the item is opened and closed, in other words in the Item_Open and Item_Close or Item_Write event handlers. In the form code window, you can use the Script | Event Handler command to add the procedure declaration for any event you want to use.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers