![]() |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
||||
|
||||
![]()
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?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
![]()
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
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
![]()
macropod,
my source file is an excel worksheet with headers such as (name, address, etc). does this help? Marc |
#5
|
||||
|
||||
![]()
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
AlexTeslin | Mail Merge | 1 | 03-08-2013 09:31 PM |
![]() |
Freddies_grandad | Mail Merge | 7 | 12-10-2012 11:05 PM |
![]() |
lawlaw | Mail Merge | 3 | 11-29-2012 04:47 PM |
![]() |
janm | Mail Merge | 1 | 08-06-2012 11:41 PM |
![]() |
TanMan | Mail Merge | 1 | 10-13-2011 06:36 PM |