A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Collect Form Data using OL2003



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old July 11th 07, 02:02 AM posted to microsoft.public.outlook.program_vba
PJFry
external usenet poster
 
Posts: 14
Default Collect Form Data using OL2003

I have a survey form that I send out on a monthly basis. The recipient opens
the form, answers the questions in a combo box and sends the form back to me.
I would like to have the results automatically exported to a text file. For
example:

Question one is cmbSurQ1. The user chooses 'Outstanding'. The code would
look in the survey inbox, read 'Outstanding' from cmbSurQ1 and append that to
a text file. There are eight questions and eight text files. (Each of the
questions belongs to a different group in the company). The code would
perform the same action on all of the questions in all of the messages.

I would like the text file to contain the recipient’s e-mail address, the
message subject, a note indicating which question and the result.

Our current process is to manually tally these items. This should speed
things up dramatically.

Please let me know what questions you have.

I code pretty regularly in Access, so I am familiar with VBA, just not the
Outlook objects.

Thanks!
PJ

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
OL2003 - Custom form won't open on some PCs Lanwench [MVP - Exchange] Outlook - General Queries 0 November 28th 06 02:42 PM
Can Outlook07 collect/show data re specific recurring "meetings"? Jonathan Outlook - Calandaring 0 August 8th 06 06:50 AM
What is the best way to collect training needs from my company? nashwan Ibrahim Ariqi Outlook - Using Forms 0 April 15th 06 03:08 PM
OL2003 - can you auto-fill a singel new contact form with online form data TimR Outlook - Using Contacts 1 February 15th 06 02:43 PM
need to limit length of form in OL2003 simon_ Outlook - Using Forms 3 January 24th 06 05:30 PM


All times are GMT +1. The time now is 09:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.