Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2010, 10:59 AM
Rhazdel Rhazdel is offline Need help with user-completed letter Windows 7 Need help with user-completed letter Office 2010 (Version 14.0)
Novice
Need help with user-completed letter
 
Join Date: Sep 2010
Posts: 1
Rhazdel is on a distinguished road
Post Need help with user-completed letter

Hello, everyone.

I work for a small business and would like to streamline our proposal process by using user-completed forms. However, I am running into some issues with certain programs and wanted to know if any of the experts on here had some insights/suggestions.

I just need a letter, addressed to our customers by name and home address, which itemizes their order and gives a total cost at the end. BUT, I would like the form to be as simple to use as possible, since there may be a few people with little computer skill using the forms.

Basically, the forms will have fields that contain choices on the order form. For example: One sentence in the letter might read: "...paint color to be: ______", where the blank could be one of five different colors, chosen by the customer and then included by us in the letter.

I tried creating the letter in Microsoft Word 2010 using drop-down fields, but some item lists may or may not be included in each letter. So, if the customer didn't order a particular item, then whoever is filling out the form will have to manually delete the drop-down menu field, which will be too much work for them, I think.

I could also use a Microsoft Excel spreadsheet, include drop-down menus for the fields and then Mail Merge into a Word document, but then I would need a new Excel file for each letter, or have to teach my co-workers how to Mail Merge only single rows (not likely to happen with them).

We, unfortunately, cannot afford Microsoft Access, which I know can do this rather efficiently.

So, does anyone have some good suggestions on how I can create a simple letter template that allows the user to make some choices and auto-generate the fields as needed?



The programs I have access to are: Microsoft (2010) Word, Excel, One Note and Outlook.

I thank you for any help!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to address a letter to 10,000 different people at once. Bit of a Trip Word 0 08-13-2010 08:44 AM
Convert a completed form to verbalized text tsttm Word 0 07-09-2010 05:07 AM
How do i implement learnings from completed projects? stingy Project 0 03-18-2010 02:09 AM
Auto Letter Hannes Word 1 10-29-2009 06:27 AM
Letter Templates happymouth Word 8 05-17-2009 02:43 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:23 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft