form letter macro question

[Cory]

Hi.
I work at a nice hotel and everyday we have a new batch of guests who check
in with a variety of rate packages that each require a different form letter
that we give to the guests at check in. The hotel has always just done this
manually, but I'd like to try to find us a way to save a little time.

So... I'd like to be able to create a form that will let me input the guest
name (Mr. Smith, Ms. Jones, etc.) and their package name (AMEX, Honeymoon,
etc.) so that a macro can be run to input the names in the appropriate Word
documents and print. Sometimes we have 20 to 30 guests with these packages
and it would be nice to automate some of the work.

I've looked around at various websites trying to figure out how to do this,
but I haven't been able to figure it out. Any help would be greatly
appreciated!

 

[Doug Robbins - Word MVP]

You should use mail merge.

See the article "Creating a Mail Merge Data Source" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

See the article "How to create a Mail Merge" at:

http://www.word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

If you wish to vary the text of the letter depending upon the contents of
one of the merge fields, you can use an If...then...Else field construction
in conjunction with an includetext field


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP