Results 1 to 9 of 9
  1. #1
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    I would like to create an order form for my off-site sales reps. that they can fill out & e-mail to me. Ideally this form would be a one page document that contains both text & graphics. A main feature would be boxes next to each item listed that can be clicked on to check or uncheck as well as space for data such as name, date, address, etc. I'm pretty sure I could create such a form in access, but I don't know how/if I could easily e-mail it.

    Also, the form cannot require a lot of computer skill to fill out as several of the potential users may have limited computer skills.

    Is there an Office program that can do this? My knowledge of Office programs would probably best be described as moderate, so please keep that in mind when offering solutions.

    Thank you,

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    Have you considered creating a web page to do this? It is something that FrontPage (for example) could create quite easily and wouldn't require the sender to have the software to run whatever program the form would run under - plus they could fill in the form from anywhere.
    You would need a suitably hosted web-site, though.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    No, but you could do something like this with Adobe Acrobat and PDF files. You won't be able to easily get the information back into Access though, if that's what you had in mind.

    If this is really an Access question, post it in the Access board.
    Charlotte

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    Outlook supports custom forms. I'm not very familiar with their full range of capabilities, but you can create user-defined fields and then create displays that allow users to enter data into them with checkboxes and other controls.

    Here's some more reading:

    Designing Microsoft Outlook Forms at Slipstick.com

    OL2000: Questions About Custom Forms and Outlook Solutions (Q146636) from the MSKB

  5. #5
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    You can create a HTML document (NOT a webpage) and use SendTo method to e-mail completed form to your address. See FrontPage Help for details (better, any book about JavaScript). You can open such document from ANY location, not from website only (Leif, you are not right.)
    You can use both Word and FrontPage to create HTML document, but it is better to use FrontPage when you editing JavaScript.

  6. #6
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    The suggestion I was making meant that the user would not need to physically have a copy of the form, they would only need access to the internet, from any computer with suitable browser, anywhere in the world.
    In this case, I would suggest that they would need to have a suitably hosted website to handle the form - for example if they used FrontPage as you suggest, the FP Server Extensions would look after the responses, either saving them to file and/or emailing them onward.

  7. #7
    New Lounger
    Join Date
    Jan 2001
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    Word has good form functions such as you desire. You can have check boxes, fill-in-the-blanks, drop-down lists, etc. Once you lock the form, you can e-mail it and the recipient just completes it, within the limitations you establish, and sends it back to you. The easiest way to the forms is View | Toolbars | Forms -- this brings up the forms toolbar with all the commands you need.

  8. #8
    New Lounger
    Join Date
    Oct 2001
    Posts
    11
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    Thank you so much. The forms tool bar was exacly what I needed. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23>
    I'm embarrassed to say that I had no idea it existed. <img src=/S/blush.gif border=0 alt=blush width=15 height=15>

  9. #9
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Form that can be sent in via e-mail (Microsoft Office (Win. 98))

    I would like a little more information on this. I need to create a Generic form for our clients to use. My problem... they all us different email services, word processors, spreadsheets, etc. I need to create a form that they can download to their PC. Fill in the blank fields of the form, so that the form is filled at their site and mail to us.

Posting Permissions

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