K
KurtMD
Hello all,
I some help with an advanced question concerning a project I'm working on
for a client.
I have created an Excel 'Source File' (or Master List) using thier client
list. First Name, Last Name, Title, Company Name, Street Address, City,
State and Zip are the row 1 column identifiers. I've then created 8
'Sub-lists' (each to be used for different purposes) by pasting links from
different rows in the 'Source File' so all that ever needs to be edited is
the 'Source File' to keep ALL 'Sub-lists' current. Some of the names and
addresses are listed in multiple 'Sub-lists' but, no 1 'Sub-list' contains
all the names from the 'Source File'. This is all working perfectly fine.
The problem I'm having is when I use MS Word to create sheets of mailing
labeles using these Excel 'Sub-lists' as the merge file, there is no data
and the process is halted. I do understand these Excel 'Sub-lists' do not
contain HARD or REAL data but rather, links to data from the 'Source File'.
So, I'm stumped! Is there any way I can possibly make this work short of
doing all this via a full fledged Data Base app?
I do know that Office XP allows individual rows to be chosen from within a
'Source File' (Master List) to aid in the creation of merge files but, this
will become quite tedious since my client has 8 'Sub lists' being managed by
this 'Source File'. BTW, I'm creating these files using Office XP but, my
client is using Office 2K.
Any help in overcoming this dilemma will be graciously accepted and truly
appreciated!!
Kurt Dschida
I some help with an advanced question concerning a project I'm working on
for a client.
I have created an Excel 'Source File' (or Master List) using thier client
list. First Name, Last Name, Title, Company Name, Street Address, City,
State and Zip are the row 1 column identifiers. I've then created 8
'Sub-lists' (each to be used for different purposes) by pasting links from
different rows in the 'Source File' so all that ever needs to be edited is
the 'Source File' to keep ALL 'Sub-lists' current. Some of the names and
addresses are listed in multiple 'Sub-lists' but, no 1 'Sub-list' contains
all the names from the 'Source File'. This is all working perfectly fine.
The problem I'm having is when I use MS Word to create sheets of mailing
labeles using these Excel 'Sub-lists' as the merge file, there is no data
and the process is halted. I do understand these Excel 'Sub-lists' do not
contain HARD or REAL data but rather, links to data from the 'Source File'.
So, I'm stumped! Is there any way I can possibly make this work short of
doing all this via a full fledged Data Base app?
I do know that Office XP allows individual rows to be chosen from within a
'Source File' (Master List) to aid in the creation of merge files but, this
will become quite tedious since my client has 8 'Sub lists' being managed by
this 'Source File'. BTW, I'm creating these files using Office XP but, my
client is using Office 2K.
Any help in overcoming this dilemma will be graciously accepted and truly
appreciated!!
Kurt Dschida