Hello,

I would like to write some data from an excel to a custom made outlook form
which is then inturn mail. Here are the specifics;

Excel

Excel workbook - 'somebook.xls'
the worksheet is - 'rates'
the cell is - 'A1'


Outlook

The form is 'orders' in the Personal Forms Library
A textbox name on the form is 'txtsales'


I want... through a macro in Excel ... write the data in 'A1' to 'txtsales'
in Outlook

Can this be done? thx.


-Lumpjaw

please don't cross post.

--
Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au



"Lumpjaw" wrote in message
...
Hello,

I would like to write some data from an excel to a custom made outlook
form
which is then inturn mail. Here are the specifics;

Excel

Excel workbook - 'somebook.xls'
the worksheet is - 'rates'
the cell is - 'A1'


Outlook

The form is 'orders' in the Personal Forms Library
A textbox name on the form is 'txtsales'


I want... through a macro in Excel ... write the data in 'A1' to
'txtsales'
in Outlook

Can this be done? thx.


-Lumpjaw

Thanks for the suggestion! Good grief!

Man... people are uptight!


"Judy Gleeson (MVP Outlook)" wrote in message
...
please don't cross post.

--
Judy Gleeson
MVP Outlook
Outlook trainer and author of Productiv_IT with Outlook
www.acorntraining.com.au



"Lumpjaw" wrote in message
...
Hello,

I would like to write some data from an excel to a custom made outlook
form
which is then inturn mail. Here are the specifics;

Excel

Excel workbook - 'somebook.xls'
the worksheet is - 'rates'
the cell is - 'A1'


Outlook

The form is 'orders' in the Personal Forms Library
A textbox name on the form is 'txtsales'


I want... through a macro in Excel ... write the data in 'A1' to
'txtsales'
in Outlook

Can this be done? thx.


-Lumpjaw

it sure can be done, a lot of people will tell you that... coz they've done
it, so get in there and do it sunny...

and oh, yeah, don't get uptight about the answer. There are a lot of
people here who will help you, so don't slag them off.

just chill... it's all in Google...


"Lumpjaw" wrote in message
...
Hello,

I would like to write some data from an excel to a custom made outlook
form
which is then inturn mail. Here are the specifics;

Excel

Excel workbook - 'somebook.xls'
the worksheet is - 'rates'
the cell is - 'A1'


Outlook

The form is 'orders' in the Personal Forms Library
A textbox name on the form is 'txtsales'


I want... through a macro in Excel ... write the data in 'A1' to
'txtsales'
in Outlook

Can this be done? thx.


-Lumpjaw