Sending Emails

  • Thread starter Thread starter Simon Dowse
  • Start date Start date
S

Simon Dowse

Hi,

I have a table that holds information about various users
(tblUsers). I already have a form that shows all the
information in that table. I want to build another form
that I can use to enter new people's details, they will
then be added to the tblUsers table, and then I want a
button on the form so that I can send it to a pre-defined
address by email.

Any ideas? If a form can't do it, any ideas what would be
able to?

Regards,
Simon
 
Simon,

Unless the form you already have has its AllowAdditions property set to
No, I would imagine this would be the ideal avenue through which to
enter new users.

As for the email, you could look at a SendObject macro, or a VBA
procedure using a DoCmd.SendObject method, to send the data from an
appropriately set up query.
 
Back
Top