Sending an email message via a Macro

[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

 

[Guest]

http://www.microsoft.com/office/com...35b6-4f15-84c5-ae9fb957bc95&lang=en&cr=US&p=1

 

[Steve Schapel]

Adam,

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

 

[Steve Schapel]

Oliver,

This link does not relate to support with use of macros.