User friendly Mail Merge application using MS SQL and MS Word in ASP.Net and VB

I have a MS SQL 2005 table and a MS Word 2003 document.  It's part of a project already done in ASP.Net 3.5/VB/SQL.

I've got the mail merge fields set up in the Word document to pull the appropriate fields from the SQL Server database, so I can print the whole mail merge in one shot if I want.
But, since the rest of the project is in ASP.Net and the users do not know how to use the mail merge in Word effectively I'd like to make a simple ASPX page with a DropDownList control so the user can select one record to print or perhaps a range.  
I have used SQL queries in DropDownLists before, but I don't know how I would get the data to the Word mail merge that way.
There are probably multiple ways to do it, but I'm looking for "simple".  I'm a novice programmer, so telling me "Create a DataSet and link it to Word" won't help me at all.  I really need an example.
Say, the SQL table contains the fields [LastName] and [Address].
Thanks for any help.
David
LVL 1
megninAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rob_farleyCommented:
You have your ASP.Net page producing a Word Document already, but are wanting to be able to tweak the query that Word uses?

Rob
0
dipakdave1983Commented:
if your word does not contain the images then you can do this way,,,

http://msdn.microsoft.com/en-us/library/aa701256(office.11).aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
megninAuthor Commented:
Hi Rob.  No, it's the ASP.Net page I'm looking for how to create.  I don't know how to get one single record from say, a DropDownList to a Word document or template, like a form letter so the user can select a person's record from the DropDownList and fields from that record will populate the form letter (Word doc).
I know how to mail merge from the database into Word, but I don't know if some form of that technology is what I should use or if there's another method, like how Excel pulls data from a database.
0
megninAuthor Commented:
Hi dipakdave1983.  Dave, that link looks very informative, but it may be a little more complicated than I want to get into.  If it's no easier than that I'll just teach the users how to use the Mail Merge in Word and let the do it 'the old fashion way'.  ;-)
0
megninAuthor Commented:
I'm sure that's a good solution.  I was hoping, however, for one that I would be able to use.  It seems that the Microsoft solution for even the simplest task is much more complicated than it seems that it should be.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.