View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.outlook
Lumpjaw Lumpjaw is offline
external usenet poster
 
Posts: 13
Default Excel data exported to custom Outlook form

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