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
|