I have created a Library database. I would like to be able to email
when borrowed material is due as a friendly reminder. So I have
created a Macro in Access 2003 that's an action of SendObject to
Outlook 2003.

Object Type: Form
Object Name: frmInvdb
Output Format: HTML
To: (not sure if I should leave this blank or link it to borrower's
email by date to be returned by an expression like
[Form]![frmb_email]![date_to_be_returned])

Do I also need a command button to trigger this or just go into
properties and once the date_to_be_returned field is filled in enter
in properties under "on exit" and link it back to macro created as
mcrEmailReminder. Thanks.

Kim

You can have multiple Macro Actions under a single macro name. Make sure the
name column is turned on in the macro window and just put the actions in
order that you want them to be executed.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


<kimtorvinen@hotmail.com> wrote in message
news:3e63baa9-c842-490d-b59c-410cb7491669@d45g2000hsc.googlegroups.com...
>I have created a Library database. I would like to be able to email
> when borrowed material is due as a friendly reminder. So I have
> created a Macro in Access 2003 that's an action of SendObject to
> Outlook 2003.
>
> Object Type: Form
> Object Name: frmInvdb
> Output Format: HTML
> To: (not sure if I should leave this blank or link it to borrower's
> email by date to be returned by an expression like
> [Form]![frmb_email]![date_to_be_returned])
>
> Do I also need a command button to trigger this or just go into
> properties and once the date_to_be_returned field is filled in enter
> in properties under "on exit" and link it back to macro created as
> mcrEmailReminder. Thanks.
>
> Kim
>

On Aug 14, 3:01*pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> You can have multiple Macro Actions under a single macro name. Make sure the
> name column is turned on in the macro window and just put the actions in
> order that you want them to be executed.
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> <kimtorvi...@hotmail.com> wrote in message
>
> news:3e63baa9-c842-490d-b59c-410cb7491669@d45g2000hsc.googlegroups.com...
>
>
>
> >I have created a Library database. *I would like to be able to email
> > when borrowed material is due as a friendly reminder. *So I have
> > created a Macro in Access 2003 that's an action of SendObject to
> > Outlook 2003.
>
> > Object Type: Form
> > Object Name: frmInvdb
> > Output Format: HTML
> > To: (not sure if I should leave this blank or link it to borrower's
> > email by date to be returned by an expression like
> > [Form]![frmb_email]![date_to_be_returned])
>
> > Do I also need a command button to trigger this or just go into
> > properties and once the date_to_be_returned field is filled in enter
> > in properties under "on exit" and link it back to macro created as
> > mcrEmailReminder. *Thanks.
>
> > Kim- Hide quoted text -
>
> - Show quoted text -

Thanks Arvin, can you tell me if my expression is correct to ensure
it's run on the specified due date as a reminder? Not sure if I
insert this in the condition column?

The expression looks correct, but it won't run on the specified date because
you have nothing to trigger the event. Using VBA, a form would continuously
run a timer and when the correct condition was met, the timer would fire the
event. Another possibility is to check when you open the database within the
AutoExec macro.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


<kimtorvinen@hotmail.com> wrote in message
news:9120c96c-8ece-4b28-9921-59b9b1f9de60@i24g2000prf.googlegroups.com...
On Aug 14, 3:01 pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> You can have multiple Macro Actions under a single macro name. Make sure
> the
> name column is turned on in the macro window and just put the actions in
> order that you want them to be executed.
> --
> Arvin Meyer, MCP,
> MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> <kimtorvi...@hotmail.com> wrote in message
>
> news:3e63baa9-c842-490d-b59c-410cb7491669@d45g2000hsc.googlegroups.com...
>
>
>
> >I have created a Library database. I would like to be able to email
> > when borrowed material is due as a friendly reminder. So I have
> > created a Macro in Access 2003 that's an action of SendObject to
> > Outlook 2003.
>
> > Object Type: Form
> > Object Name: frmInvdb
> > Output Format: HTML
> > To: (not sure if I should leave this blank or link it to borrower's
> > email by date to be returned by an expression like
> > [Form]![frmb_email]![date_to_be_returned])
>
> > Do I also need a command button to trigger this or just go into
> > properties and once the date_to_be_returned field is filled in enter
> > in properties under "on exit" and link it back to macro created as
> > mcrEmailReminder. Thanks.
>
> > Kim- Hide quoted text -
>
> - Show quoted text -

Thanks Arvin, can you tell me if my expression is correct to ensure
it's run on the specified due date as a reminder? Not sure if I
insert this in the condition column?

On Aug 15, 6:58*am, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> The expression looks correct, but it won't run on the specified date because
> you have nothing to trigger the event. Using VBA, a form would continuously
> run a timer and when the correct condition was met, the timer would fire the
> event. Another possibility is to check when you open the database within the
> AutoExec macro.
> --
> Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmvp.com
>
> <kimtorvi...@hotmail.com> wrote in message
>
> news:9120c96c-8ece-4b28-9921-59b9b1f9de60@i24g2000prf.googlegroups.com...
> On Aug 14, 3:01 pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:
>
>
>
>
>
> > You can have multiple Macro Actions under a single macro name. Make sure
> > the
> > name column is turned on in the macro window and just put the actions in
> > order that you want them to be executed.
> > --
> > Arvin Meyer, MCP,
> > MVPhttp://www.datastrat.comhttp://www.mvps.org/accesshttp://www.accessmv...
>
> > <kimtorvi...@hotmail.com> wrote in message
>
> >news:3e63baa9-c842-490d-b59c-410cb7491669@d45g2000hsc.googlegroups.com....
>
> > >I have created a Library database. I would like to be able to email
> > > when borrowed material is due as a friendly reminder. So I have
> > > created a Macro in Access 2003 that's an action of SendObject to
> > > Outlook 2003.
>
> > > Object Type: Form
> > > Object Name: frmInvdb
> > > Output Format: HTML
> > > To: (not sure if I should leave this blank or link it to borrower's
> > > email by date to be returned by an expression like
> > > [Form]![frmb_email]![date_to_be_returned])
>
> > > Do I also need a command button to trigger this or just go into
> > > properties and once the date_to_be_returned field is filled in enter
> > > in properties under "on exit" and link it back to macro created as
> > > mcrEmailReminder. Thanks.
>
> > > Kim- Hide quoted text -
>
> > - Show quoted text -
>
> Thanks Arvin, can you tell me if my expression is correct to ensure
> it's run on the specified due date as a reminder? *Not sure if I
> insert this in the condition column?- Hide quoted text -
>
> - Show quoted text -

Sorry I'm pretty new to Access. Do I have to create an AutoExec
macro, save this separately from mcr.EmailReminder? VBA is pretty new
to me as well, do I give it an action of RunMacro, then enter the
Date_to_be_returned field?

Thanks again.

Kim

<kimtorvinen@hotmail.com> wrote in message
news:52366036-b919-4b6b-943a-4f43d941190a@r66g2000hsg.googlegroups.com...
On Aug 15, 6:58 am, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> The expression looks correct, but it won't run on the specified date
> because
> you have nothing to trigger the event. Using VBA, a form would
> continuously
> run a timer and when the correct condition was met, the timer would fire
> the
> event. Another possibility is to check when you open the database within
> the
> AutoExec macro.

Sorry I'm pretty new to Access. Do I have to create an AutoExec
macro, save this separately from mcr.EmailReminder? VBA is pretty new
to me as well, do I give it an action of RunMacro, then enter the
Date_to_be_returned field?
----------------------
Yes. The name: AutoExec tells Access to run what's inside when it starts up.
If your other macro works OK, a RunMacro action with the name of macro that
you want to run as the argument should do it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com