Sending an email message via a Macro

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

I have created a button called 'Notify person' on a form. The purpose of
this button is to notify a member of staff when an entry into a table has
been made against his / her name.

I have attempted to do this as follows.

In the properties tab of my button, on the event tab, at the On click option
I have created a Macro.

I have selected the SendObject command.

I wish to send the email to the address of the person whose name features in
a field which I have created on my table, entitled 'email'. As such in the
'to' column of the action arguments (in the macro) I have entered

This however, does not work and I receive the message (unknown message
recipient, the message was not sent).

I guess I'm just not specifying the field properly, but essentially I want
to send the email to whatever address is specified in the 'to' column.

Many thanks in advance.

Adam
 
Adam,

Put a = in front, i.e. in the To argument of the SenObject action in
your macro, like this...
=
 
Back
Top