drop down list help

[rm11561]

Hi all,

Is this even possible?

On a separate worksheet (#2), I created a list of address:

A1 = Mrs. Jones
111 Main Street
A-Town, NY 11111

A2 = Mr. Smith
222 Main Street,
B-Town, NY 22222


i want to create a drop down list on my cover letter, listing Mrs. Jones and Mr. Smith.
When i select Mrs. Jones, i want her address to populate. The same for Mr. Smith.

This is something i want to do for a long time but never had the patience to try. I just want to get it done.

Any help is greatly appreciated!!
Thanks,
Mark

[newdoverman]

To be able to use the addresses in a mail merge operation in Word, the format of your address list in Excel should have one row per address with each element of the address in its own cell. A proper setup would be like this:
A1 Name, B1 Street, C1, Apt., D1 City, E1 State, F1 Zip_Code.

The way you have the addresses laid out now seems to be the most logical but it is the most difficult to work with.

If this is a Word Mail Merge situation, the easiest way is to enter the Mail Merge area of Word and you should see a prompt to either create a "source" document or to locate the source document. Choose to create the source document and you will be prompted with the proper headings and then all you do is fill in the data.

If you already have an extensive list of addresses in Excel, it may pay you to re-format the data to be acceptable for a mail merge.