Nancy Lytle
nancy.lytle at auatac.com
Tue Aug 19 13:24:45 CDT 2003
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. 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. Thanks, Nancy ----- Original Message ----- From: Steve Capistrant To: Access Developers discussion and problem solving Sent: Tuesday, August 19, 2003 2:13 PM Subject: RE: [AccessD] OT: Sending a form out to multiple users via email 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. 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. Steve Capistrant Symphony Information Services scapistrant at symphonyinfo.com Phone: 612-333-1311 www.symphonyinfo.com 212 3rd Ave N, Ste 404 Minneapolis, MN 55401 -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Nancy Lytle Sent: Tuesday, August 19, 2003 11:23 AM To: AccessD at databaseadvisors.com Subject: [AccessD] OT: Sending a form out to multiple users via email 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: I am looking for the best solution to the following: 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. 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. What is the best way to do something like this? I am open to other solutions as well. Nancy Lytle N_Lytle at terpalum.umd.edu 240-274-0069 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.509 / Virus Database: 306 - Release Date: 8/12/2003 ------------------------------------------------------------------------------ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030819/82f4cd9a/attachment-0001.html>