emails wherre "to" is in tabel

[hans Christiaens via AccessMonster.com]

I need to send a lot of rpts.
I'm looking for a solution where the "to" field is automaticly filled with the emailadress in the "email" field in the corresponding tabel from the active form.
The rpt should also be send whithout opening in preview.
thks for helping
Hans

 

[Jim/Chris]

You could create a macro using the SendObject Action.
In the To argument of the SendObject, put the equivalent of...
=[Forms]![NameOfYourForm]![NameOfEmailAddressControl]

Jim

-----Original Message-----
I need to send a lot of rpts.
I'm looking for a solution where the "to" field is

automaticly filled with the emailadress in the "email"
field in the corresponding tabel from the active form.

 

[hans Christiaens via AccessMonster.com]

Thks for helping,
It was nearly to simple to be through
Should have tought on it myself
Hans