Outputting Invididual Records to Users   

Seems like this should be a simple thing to do, but I can't figure it out for 
the life of me.

I have a database that will be used to process employee vacation requests.  
After approving or denying the requests, I would like to send the employees 
e-mails, letting them know the result of their requests. 

I'm working with two tables - one that contains the processed vacation 
requests (Request Date/Time, Approval Date/Time, whether it was approved or 
denied, the user's name, and if the user was notified of the approval/denial 
yet) and another table of employee data (user name, e-mail address).  Is 
there any way, via macro or any other means, to join those two tables on the 
user name and send e-mails for each line in the vacation request table to the 
related employee e-mails, letting them know the result of their request?  

Thanks in advance.

date: Fri, 29 Aug 2008 11:46:01 -0700   author:   thefonz37

Re: Outputting Invididual Records to Users   

Using a [UserName] as a primary key for joining tables is risky.  What will 
you do when you have two employees named "John Smith"?

Use a query to join tables.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"thefonz37"  wrote in message 
news:85875423-CC8E-4E17-9823-59D092929CCF@microsoft.com...
> Seems like this should be a simple thing to do, but I can't figure it out 
> for
> the life of me.
>
> I have a database that will be used to process employee vacation requests.
> After approving or denying the requests, I would like to send the 
> employees
> e-mails, letting them know the result of their requests.
>
> I'm working with two tables - one that contains the processed vacation
> requests (Request Date/Time, Approval Date/Time, whether it was approved 
> or
> denied, the user's name, and if the user was notified of the 
> approval/denial
> yet) and another table of employee data (user name, e-mail address).  Is
> there any way, via macro or any other means, to join those two tables on 
> the
> user name and send e-mails for each line in the vacation request table to 
> the
> related employee e-mails, letting them know the result of their request?
>
> Thanks in advance.

date: Fri, 29 Aug 2008 16:32:21 -0700   author:   Jeff Boyce

Re: Outputting Invididual Records to Users   

The username field is actually their LAN login they use to sign on to their 
computers in the morning, so it will always be unique.  I actually have a 
query set up already joining on the username, but I don't know how to output 
each row of that query to the e-mail address in the row.

"Jeff Boyce" wrote:

> Using a [UserName] as a primary key for joining tables is risky.  What will 
> you do when you have two employees named "John Smith"?
> 
> Use a query to join tables.
> 
> Regards
> 
> Jeff Boyce
> Microsoft Office/Access MVP
> 
> 
> "thefonz37"  wrote in message 
> news:85875423-CC8E-4E17-9823-59D092929CCF@microsoft.com...
> > Seems like this should be a simple thing to do, but I can't figure it out 
> > for
> > the life of me.
> >
> > I have a database that will be used to process employee vacation requests.
> > After approving or denying the requests, I would like to send the 
> > employees
> > e-mails, letting them know the result of their requests.
> >
> > I'm working with two tables - one that contains the processed vacation
> > requests (Request Date/Time, Approval Date/Time, whether it was approved 
> > or
> > denied, the user's name, and if the user was notified of the 
> > approval/denial
> > yet) and another table of employee data (user name, e-mail address).  Is
> > there any way, via macro or any other means, to join those two tables on 
> > the
> > user name and send e-mails for each line in the vacation request table to 
> > the
> > related employee e-mails, letting them know the result of their request?
> >
> > Thanks in advance. 
> 
> 
>

date: Fri, 29 Aug 2008 17:24:01 -0700   author:   thefonz37

Re: Outputting Invididual Records to Users   

in a VBA module, you can open a Recordset based on the query, and loop
through the records in the recordset, running the DoCmd.SendObject action on
each record.

hth


"thefonz37"  wrote in message
news:8B294B78-CD38-4E23-B1DA-23FB2411E6F4@microsoft.com...
> The username field is actually their LAN login they use to sign on to
their
> computers in the morning, so it will always be unique.  I actually have a
> query set up already joining on the username, but I don't know how to
output
> each row of that query to the e-mail address in the row.
>
> "Jeff Boyce" wrote:
>
> > Using a [UserName] as a primary key for joining tables is risky.  What
will
> > you do when you have two employees named "John Smith"?
> >
> > Use a query to join tables.
> >
> > Regards
> >
> > Jeff Boyce
> > Microsoft Office/Access MVP
> >
> >
> > "thefonz37"  wrote in message
> > news:85875423-CC8E-4E17-9823-59D092929CCF@microsoft.com...
> > > Seems like this should be a simple thing to do, but I can't figure it
out
> > > for
> > > the life of me.
> > >
> > > I have a database that will be used to process employee vacation
requests.
> > > After approving or denying the requests, I would like to send the
> > > employees
> > > e-mails, letting them know the result of their requests.
> > >
> > > I'm working with two tables - one that contains the processed vacation
> > > requests (Request Date/Time, Approval Date/Time, whether it was
approved
> > > or
> > > denied, the user's name, and if the user was notified of the
> > > approval/denial
> > > yet) and another table of employee data (user name, e-mail address).
Is
> > > there any way, via macro or any other means, to join those two tables
on
> > > the
> > > user name and send e-mails for each line in the vacation request table
to
> > > the
> > > related employee e-mails, letting them know the result of their
request?
> > >
> > > Thanks in advance.
> >
> >
> >

date: Sat, 30 Aug 2008 20:37:01 GMT   author:   tina

Re: Outputting Invididual Records to Users   

Awesome, Tina, thanks for your help.  I will play around with that and see 
what I come up with.

"tina" wrote:

> in a VBA module, you can open a Recordset based on the query, and loop
> through the records in the recordset, running the DoCmd.SendObject action on
> each record.
> 
> hth
> 
> 
> "thefonz37"  wrote in message
> news:8B294B78-CD38-4E23-B1DA-23FB2411E6F4@microsoft.com...
> > The username field is actually their LAN login they use to sign on to
> their
> > computers in the morning, so it will always be unique.  I actually have a
> > query set up already joining on the username, but I don't know how to
> output
> > each row of that query to the e-mail address in the row.
> >
> > "Jeff Boyce" wrote:
> >
> > > Using a [UserName] as a primary key for joining tables is risky.  What
> will
> > > you do when you have two employees named "John Smith"?
> > >
> > > Use a query to join tables.
> > >
> > > Regards
> > >
> > > Jeff Boyce
> > > Microsoft Office/Access MVP
> > >
> > >
> > > "thefonz37"  wrote in message
> > > news:85875423-CC8E-4E17-9823-59D092929CCF@microsoft.com...
> > > > Seems like this should be a simple thing to do, but I can't figure it
> out
> > > > for
> > > > the life of me.
> > > >
> > > > I have a database that will be used to process employee vacation
> requests.
> > > > After approving or denying the requests, I would like to send the
> > > > employees
> > > > e-mails, letting them know the result of their requests.
> > > >
> > > > I'm working with two tables - one that contains the processed vacation
> > > > requests (Request Date/Time, Approval Date/Time, whether it was
> approved
> > > > or
> > > > denied, the user's name, and if the user was notified of the
> > > > approval/denial
> > > > yet) and another table of employee data (user name, e-mail address).
> Is
> > > > there any way, via macro or any other means, to join those two tables
> on
> > > > the
> > > > user name and send e-mails for each line in the vacation request table
> to
> > > > the
> > > > related employee e-mails, letting them know the result of their
> request?
> > > >
> > > > Thanks in advance.
> > >
> > >
> > >
> 
> 
>

date: Sat, 30 Aug 2008 22:49:00 -0700   author:   thefonz37

Re: Outputting Invididual Records to Users   

you're welcome  :)


"thefonz37"  wrote in message
news:CE8403C1-E0F0-4A81-A62F-712965030CD4@microsoft.com...
> Awesome, Tina, thanks for your help.  I will play around with that and see
> what I come up with.
>
> "tina" wrote:
>
> > in a VBA module, you can open a Recordset based on the query, and loop
> > through the records in the recordset, running the DoCmd.SendObject
action on
> > each record.
> >
> > hth
> >
> >
> > "thefonz37"  wrote in message
> > news:8B294B78-CD38-4E23-B1DA-23FB2411E6F4@microsoft.com...
> > > The username field is actually their LAN login they use to sign on to
> > their
> > > computers in the morning, so it will always be unique.  I actually
have a
> > > query set up already joining on the username, but I don't know how to
> > output
> > > each row of that query to the e-mail address in the row.
> > >
> > > "Jeff Boyce" wrote:
> > >
> > > > Using a [UserName] as a primary key for joining tables is risky.
What
> > will
> > > > you do when you have two employees named "John Smith"?
> > > >
> > > > Use a query to join tables.
> > > >
> > > > Regards
> > > >
> > > > Jeff Boyce
> > > > Microsoft Office/Access MVP
> > > >
> > > >
> > > > "thefonz37"  wrote in message
> > > > news:85875423-CC8E-4E17-9823-59D092929CCF@microsoft.com...
> > > > > Seems like this should be a simple thing to do, but I can't figure
it
> > out
> > > > > for
> > > > > the life of me.
> > > > >
> > > > > I have a database that will be used to process employee vacation
> > requests.
> > > > > After approving or denying the requests, I would like to send the
> > > > > employees
> > > > > e-mails, letting them know the result of their requests.
> > > > >
> > > > > I'm working with two tables - one that contains the processed
vacation
> > > > > requests (Request Date/Time, Approval Date/Time, whether it was
> > approved
> > > > > or
> > > > > denied, the user's name, and if the user was notified of the
> > > > > approval/denial
> > > > > yet) and another table of employee data (user name, e-mail
address).
> > Is
> > > > > there any way, via macro or any other means, to join those two
tables
> > on
> > > > > the
> > > > > user name and send e-mails for each line in the vacation request
table
> > to
> > > > > the
> > > > > related employee e-mails, letting them know the result of their
> > request?
> > > > >
> > > > > Thanks in advance.
> > > >
> > > >
> > > >
> >
> >
> >

date: Sun, 31 Aug 2008 22:20:31 GMT   author:   tina