<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=424530118-19082003><FONT face=Arial color=#0000ff size=2>A good
answer depends on getting a little more information: how is the "form"
data used once the supervisor sees it? Is it just text that he/she reads
and thinks about? Or is it data that needs to be inserted into database
tables? The answer will affect the choice of software used for the form,
and whether or not it can be web-based, and whether it needs to be sent back to
the supervisor in unstructured (like a Word document) or structured (like an XML
file) form.</FONT></SPAN></DIV>
<DIV><SPAN class=424530118-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=424530118-19082003><FONT face=Arial color=#0000ff size=2>As for
the automated weekly reminder, you can use Windows Task Scheduler to launch an
application with some macro that that performs the sendout. I can't
speak to how that would work with Outlook, but you can certainly do it from an
Access database. You create a standalone database with a startup form that
has code in its OnOpen property to initiate a mailing. Then cycle through
a list of employee names, get the email address, and use SendObject to send the
email (use the variation that does not pause to allow user input). The
database code can then close itself down in 10 minutes using the Timer property
of the startup form. All the TaskScheduler has to do is open the database
once a week.</FONT></SPAN></DIV>
<DIV><SPAN class=424530118-19082003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><FONT size=2><SPAN class=424530118-19082003>S</SPAN>teve
Capistrant<BR>Symphony Information
Services<BR>scapistrant@symphonyinfo.com<BR>Phone:
612-333-1311<BR>www.symphonyinfo.com<BR>212 3rd Ave N, Ste 404<BR>Minneapolis,
MN 55401<BR></FONT></DIV>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Nancy
Lytle<BR><B>Sent:</B> Tuesday, August 19, 2003 11:23 AM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] OT: Sending a form out
to multiple users via email<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>
<DIV><FONT face=Arial size=2>Sorry for the off topic, but I know many of you
have a lot of experience with Outlook and other email products so I though I
would throw this out to everyone:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I am looking for the best solution to the
following:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>My boss has all the personnel in his division do a
weekly status report. Most of us forget to to it, so he has to email us a
reminder each week.</FONT></DIV>
<DIV><FONT face=Arial size=2>I would like to set up something where each
Thursday afternoon a standard message (or form or something) is emailed to
everyone, and all the have to do is fill in the blanks and send it back at that
point a rule would put them all into a separate folder in Outlook.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>What is the best way to do something like
this? I am open to other solutions as well.</FONT></DIV>
<DIV> </DIV></FONT></DIV>
<DIV><FONT face=Arial size=2>Nancy Lytle<BR><A
href="mailto:N_Lytle@terpalum.umd.edu">N_Lytle@terpalum.umd.edu</A><BR>240-274-0069</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2><BR>---<BR>Outgoing mail is certified Virus
Free.<BR>Checked by AVG anti-virus system (<A
href="http://www.grisoft.com">http://www.grisoft.com</A>).<BR>Version: 6.0.509 /
Virus Database: 306 - Release Date: 8/12/2003</FONT></DIV></BODY></HTML>