Macro Send Object

[amfroehlich]

I am running a macro called e-mail which action is send object. One of the field in the form that i am sending the e-mail from has a feild with the name of the person i want e-mail should be sent to. How can i tell the macro to look at that feild? and add that to the subject line or the TO?

 

[TheToeOfPooh]

Just a thought -

You could possibly achieve this using a combination of SendKeys?

I sugest it useful to look at similar Threads in the Excel section then adapt them to your Macro.

HTH
Bernard