It's not clear that what you want to do is even possible. Consider these issues:

1) A form contains no data. A form is a code/UI template that Outlook uses to display and run code for individual items. Therefore, it is not possible to export data to a form.

2) A text box itself contains no data. A text box is a control that can display either data from an Outlook property or data that the user or code puts into the control. Unless the text box is bound to an OUtlook property, the data in the text box is discarded when the item closes or sends.

3) Assuming we can figure out what you really have in mind with regard to #1 and #2, ***when*** do you want this "export" to take place?

4) Who are you mailing the item created by the form (note: you're not mailing form) to? Do they have access to the published form?

In the meantime, while you're pondering these issues, you might want to brush up on Excel automation techniques. The code samples using Excel listed at http://www.outlookcode.com/d/customimport.htm#samples might be a good place to start. I have a feeling that the Outlook item and control syntax information at http://www.outlookcode.com/d/propsyntax.htm will also come in handy.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"Lumpjaw" wrote in message ...
Greetings earthlings,

I have an issue that I have been trying to resolve for sometime, I think I
will provide the scenario and hope someone has an answer. Here it is.

- I have Excel workbook called "users.xls"
- I have a worksheet called "location"
- I have a cell B10 in the worksheet who's contents I want to be exported to
a textbox called "state" in a custom Outlook form called "RFCO" that resides
in the personal forms library in Outlook. (this custom form is from an
email template)
- I then want to be able to email the form.

How do I copy the contents of cell "B10" from worksheet "location" in
workbook "users.xls" to the custom Outlook form called "RFCO" and then
email? Thanks for the help

-lumpjaw