Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    May 2003
    Location
    Sacramento, California, USA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Email Survey (O2k)

    I am trying to decide how to distribute a survey. It will be a short survey (about 15 questions) using the Likert scale. What I'm trying to determine is how to set it up so that the respondents can mark their answers on the emailed survey and email it back to me. This is how I'd like to do it, but don't know how much "advanced" work (VBA) would be involved in setting this up. I can always set up the questionnaire using word or excel and and email them out to be downloaded, printed and mailed or faxed back to me-just seems that eliminating those intermediary steps would be best way to go.

    Any ideas or suggestions?

  2. #2
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Survey (O2k)

    Yep, go with an ASP web page. Of course that means you would need access to a webserver. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Email Survey (O2k)

    Well, if you wanted to use Excel, you could put a simple button in the sheet, with something similar to the following code:

    Private Sub CommandButton1_Click()
    ActiveWorkbook.SendMail Recipients:="YourName@YourAddress.net", _
    Subject:="Short Survey " & Range("A1").Value
    End Sub

    I use this frequently for mgt schedules and other things which several locations complete. Substitue your email address in the code above and make any other changes you desire, the person can click the button, and away it goes (back to you).

    Most of the work would be involved in setting up the option buttons or whatever other method you wish to use to mark the choices in the worksheets.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •