M
materialhandlingmarketer
I am working with a database of customer names and addresses in Excel 1003.
Naturally, each one has a salesperson. Just for fun, I tried sorting by
salesperson, and naming that range after the salesperson, intending to allow
that salesperson to update only his customers.
As soon as I sorted the customers back into customer name order, the range
names kind of disappeared and I forgot about them, at least until I went into
Mail Merge and tried to print labels for some of the customers. Word does
not allow me to format the labels.
I suspected that it had something to do with the range names, so I deleted
the range names. I also tried copying the names I needed for labels into
another workbook entirely, but I still cannot set up the labels.
Am I right that I messed up by naming the ranges and protecting them? If
so, are there any easy fixes?
If there are not any easy fixes, are there any hard ones? I would
appreciate it if you would not suggest getting a proper CRM. With six
salespeople we cannot agree on a format everybody likes. And unfortunately,
it's not a huge list--it's my job to grow it.
Blessings!
materialhandlingmarketer
Naturally, each one has a salesperson. Just for fun, I tried sorting by
salesperson, and naming that range after the salesperson, intending to allow
that salesperson to update only his customers.
As soon as I sorted the customers back into customer name order, the range
names kind of disappeared and I forgot about them, at least until I went into
Mail Merge and tried to print labels for some of the customers. Word does
not allow me to format the labels.
I suspected that it had something to do with the range names, so I deleted
the range names. I also tried copying the names I needed for labels into
another workbook entirely, but I still cannot set up the labels.
Am I right that I messed up by naming the ranges and protecting them? If
so, are there any easy fixes?
If there are not any easy fixes, are there any hard ones? I would
appreciate it if you would not suggest getting a proper CRM. With six
salespeople we cannot agree on a format everybody likes. And unfortunately,
it's not a huge list--it's my job to grow it.
Blessings!
materialhandlingmarketer