SendObject To field?

[shiner]

Can the to field in a SendObject macro be a variable? I would like to place this address in a table of user preferences. This would allow for the address to change in the future without having to re-code the macro. Thanks!

 

[Rob.Mills]

Well you can have it pull the address from a textbox:

Forms!frmName!txtBoxName

 

[shiner]

Rob,
I am getting errors in the macro - it states that it can not find the address in the TO field. The form containing the address field is open... so any tips?

 

[shiner]

While I am thinking about it... is it possible to send mail to the results of a query? I would like to send out mail in bulk to personnel matching certain criteria.