SendObject action - auto insert of email address

Update 28/3/11
Hi again

If worked out how to put an email address in to the 'To' field - insert the expression =[Field name].
However, I now can't find a way of adding more than one email address to the 'To' i.e. we have up to 5 email addresses per Supplier so I may want to send to them all.

At the moment I'm going to utilise the CC and BCC fields so I can send to 3 email addresses but would like the ability to send to more recipients.

Any ideas?

Thanks
Andy

Hi
I'm setting up a process to compile and send reports by email.
I have built an event using SendObject that selects the records for a supplier from a query and transfers it to a report, and attaches it to an email with standard subject line and body text.
However, the sendobject command won't allow me to automatically insert the supplier's email address in to the "To" field in the email.

the process would be much slicker if i could get access to add the email address to the email rather than copying and pasting the email address from the access form.

Are there any solutions?