SendObject

[Ripper]

I use a macro to send email files to another teacher who runs our In School
Suspension. It works great, but the teacher changed this year. I want to
know if there is a way I could, with the use of a form or something, be able
to change the email address on the macEmailIss macro. I don't know, Dlookup
or something like that. Any tips?

 

[Steve Schapel]

Rip,

I assume you are using a SendObject action in your macro? Yep, I'm
pretty sure that if you had the email address in a table, you could use
an expression like this in the To argument of the macro...
=DLookup("","YourTable")