dropdown list to activate mail merge?

[cmefly]

Hi,

I'm using microsoft word 2010 to do a letter mail merge (fields consists of name, address, city, date, etc). All the fields are from an excel file.



However, I want the "contact name" field to be a drop-down menu so when the user picks a "contact name"....the other fields associated with that name fill in.

Seems easy but for the life of me i can't figure it out.

Any ideas?

Marc

[macropod]

No, this is not 'easy'. Depending on where the contact names and their related data come from, it may not even be possible with a mailmerge. Where would those data come from?

[macropod]

Cross-posted at: http://www.mrexcel.com/forum/general...ease-help.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

[cmefly]

macropod,

my source file is an excel worksheet with headers such as (name, address, etc).

does this help?

Marc

[macropod]

Not really, since it doesn't answer the question I asked... I'd expect the mailmerge data source to be such a file but, unless your "contact name" field is the same as your "name" field (and likewise for the 'related' fields), that doesn't tell me where the contact names and their related data come from. If they are the same, why not use the mailmerge filters? That'd be a whole lot easier than trying to create a dropdown for doing only part of what the filters already do.