emails wherre "to" is in tabel

  • Thread starter Thread starter hans Christiaens via AccessMonster.com
  • Start date Start date
H

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
 
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
Click to expand...
automaticly filled with the emailadress in the "email"
field in the corresponding tabel from the active form.
 
Thks for helping,
It was nearly to simple to be through
Should have tought on it myself
Hans
 
Back
Top