Sending Email from Access

  • Thread starter Thread starter keaven
  • Start date Start date
K

keaven

is this possible? What i need to do is very simple. I
have a database where employees will fill in details of an
upcomming meeting. Once they are done, i need an email to
be sent that would hold only one piece of information from
the record (some id number or such) and the rest would
be 'hard coded' text that never changes. this email is
sent to a person who will then enter the database, go to
that record, and approve the meeting. this could be a
button.. which would then send an email to the person who
created the record (the person's email address could/would
be part of the record) letting them know that the meeting
has been approved.. again, everything 'hard coded' except
for the id number.

is this something that is possible? thanks in advance for
help.

-keaven
 
Keaven,

Yes, using a SendObject macro would seem a good approach. Did you try
it? You could possibly put the ID number in the email's Subject line.
As for the hard-coded message text, there is a limit to the allowable
size of this (in number of characters) - I am not sure off-hand of the
size restriction but I know there is one.

- Steve Schapel, Microsoft Access MVP
 
Back
Top