Someone's wisdom needed

  • Thread starter Thread starter JD
  • Start date Start date
J

JD

Someone please tell me how to do this...I'm at my wits
end. I posted this question on Friday, but noone
responded, so sorry for the repost. We have a small
database in Access 97 that tracks the dates employees wish
to schedule for vacation, how many days they are eligible
for, how many they have taken, etc. My supervisor asked
me if it is possible for the employee to e-mail the
request "form" he has completed to his supervisor, who in
turn would approve or reject the dates requested, and
email the "form" back to the employee. I'm sure I will
have to use another program along with Access to complete
this task. Does anyone have any ideas how to do this?
Thanks in advance.

JD
 
There are many possibilities, depending on your skills.
A simple way would be to create a report which the user could open in
preview from the form.
Then the user could click on File/Send and select rtf or HTML format, and
click OK which will open the default E-mail client with the report already
inserted as an attachment, to allow the user to select a recipient and send
it. The recipient could edit the attached file and E-mail it back.
You can actually do the same with the form, but unless you set the
recordsource to show only one record it will create an attachment with all
the records.
You get as fancy as you are capable of here, parts of or the whole operation
can be automated. With automation you could create a Word document or an
Excel spreadsheet with the data and automatically E-mail it to a set E-mail
address.

Ragnar
 
JD,

Try the following command:

DoCmd.SendObject acReport, "A Report with pertinent
information", "HTML(*.html)", emailaddress, "", "", "Enter
you subject Here", "", False, ""

This is an VBA Command. The first item in questes is the
name of a report in your database. emailaddress is a
string variable. You would need to pass in the supervisors
e-mail address here. The application I have stores the e-
mail address in a table, I run a VBA Query and pass in the
value that way. There is also a Macro equivalent, but I am
not sure how you pass in the e-mail address in a macro. In
a previous version of the application I used the macro
command and had troubles with anything but a fixed address.

I know this works with both Microsoft Outlook and Lotus
Notes, but not sure with other applications. Also, you may
have to have the E-Mail application open when you run this
command.

Hope this helps!

Kevin
 
Ragnar,
I have a question...if I e-mail a report and the recipient
edits it, the changes will only be made on the report, not
in Access, correct? We're looking for a way that the
changes can be made in Access.

Thanks,
JD
 
JD said:
Ragnar,
I have a question...if I e-mail a report and the recipient
edits it, the changes will only be made on the report, not
in Access, correct?
Click to expand...

That is correct.
We're looking for a way that the
changes can be made in Access.
Click to expand...

Then I think I would consider Excel, since the altered data in the
spreadsheet can be imported again. You could do that with a text file too,
by defining an import/export spec.

There is probably a much more elegant way to do this, but the more automated
the more work initially.

I will let you know if I come up with any good ideas.

Ragnar
 
Thank you.
-----Original Message-----



That is correct.


Then I think I would consider Excel, since the altered data in the
spreadsheet can be imported again. You could do that with a text file too,
by defining an import/export spec.

There is probably a much more elegant way to do this, but the more automated
the more work initially.

I will let you know if I come up with any good ideas.

Ragnar


.
Click to expand...
 
Back
Top