How to specify dynamically the 'To:' field into a SendObject within a Macro in MS Access 2003? -

I am using a form where I have a control / text box that is populated by a query. I have a button that launches a macro, sends an email with an attached file.

My problem is that I want to set the value of the "value:" field within SendObject

See the screenshot.

Use the form! Use the form!

  = form! [Reporting Business List]! Email