Alert Messaging

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

Guest

Hello,

I'm developing a database that allows end-users "A" to schedule appointments
for end-users "B". Each end users in category "B" has it's own unique
employee code. What I would like is for end-users "A" to schedule appts and
then click on a macro button to send an appointment notification to the
specific employee in category "B". Meanwhile, the employee in category "B"
will get the pop-up message while viewing other applications or forms. Is
this possible? (Please note that there are mulitple employees in both
category A and B.)

Thanks in advance for any help or suggestions you can give.

Maria
 
Hi Steve,

I was thinking of doing that, too. Can you tell me how I can auto populate
the recipient's name from a record onto Outlook? I'm trying to remove as
many keystrokes or steps as possible for the person who's doing the
scheduling. I know in macro, I can leave the "To" line blank, which forces
the sender to enter the e-mail address in Outlook. It would be great if
Access can just take the data from the "Recipient" field on a form into
Outlook.

Thanks,
Maria
 
Great! Thank you so much.

Steve Schapel said:
Maria,

Like this...
=[Forms]![NameOfForm]![Recipient]

--
Steve Schapel, Microsoft Access MVP

Nyla said:
Hi Steve,

I was thinking of doing that, too. Can you tell me how I can auto populate
the recipient's name from a record onto Outlook? I'm trying to remove as
many keystrokes or steps as possible for the person who's doing the
scheduling. I know in macro, I can leave the "To" line blank, which forces
the sender to enter the e-mail address in Outlook. It would be great if
Access can just take the data from the "Recipient" field on a form into
Outlook.

Thanks,
Maria
Click to expand...
Click to expand...
 
Back
Top