<!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.3790.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Basically the supervisor will use the replies to
create his Division Weekly status report that goes "up the ladder".
Unfortunately this will not be web based. </FONT></DIV>
<DIV><FONT face=Arial size=2>Using your tip, I'm thinking I could put together a
small Access App that would send out a form, the replies would go into Outlook,
and I believe I can get the message out of Outlook and back into the DB and set
up report using all the replies, then export it to Word for final
polishing.</FONT></DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Nancy</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=scapistrant@symphonyinfo.com
href="mailto:scapistrant@symphonyinfo.com">Steve Capistrant</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">Access Developers discussion and
problem solving</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, August 19, 2003 2:13
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] OT: Sending a form
out to multiple users via email</DIV>
<DIV><BR></DIV>
<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>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>