Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for a contact without going through the whole list.
I have a large contact data base in Excel, and I send out a lot of mailings.
Some get returned back to me, return to sender. Is there a way to look up those names for deletion without having to go through the whole list of names? Please help, going blind looking through all those names. Thank you |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for a contact without going through the whole list.
Hmmm.....Large contact database in Excel. I'm tempted to explain why that
might result in problems, but I think you're beginning to experience them. Possibly too late for this....but, if you assign a unique ID_NUM to each contact and include it in the address label, you could use Ctrl+F to find them. Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "vvsmith" wrote in message ... I have a large contact data base in Excel, and I send out a lot of mailings. Some get returned back to me, return to sender. Is there a way to look up those names for deletion without having to go through the whole list of names? Please help, going blind looking through all those names. Thank you |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for a contact without going through the whole list.
If your data is in a column, you can use the MATCH() function to find the row
the data is on. =MATCH("james",A:A,0) -- Gary''s Student - gsnu200753 "vvsmith" wrote: I have a large contact data base in Excel, and I send out a lot of mailings. Some get returned back to me, return to sender. Is there a way to look up those names for deletion without having to go through the whole list of names? Please help, going blind looking through all those names. Thank you |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for a contact without going through the whole list.
For future reference how do I assign each contact an ID_NUM I just started my
job two weeks ago, so this data base was already in effect, but would love to change somethings to make it easier for me to work with. Thank you for any and all help vvsmith "Ron Coderre" wrote: Hmmm.....Large contact database in Excel. I'm tempted to explain why that might result in problems, but I think you're beginning to experience them. Possibly too late for this....but, if you assign a unique ID_NUM to each contact and include it in the address label, you could use Ctrl+F to find them. Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "vvsmith" wrote in message ... I have a large contact data base in Excel, and I send out a lot of mailings. Some get returned back to me, return to sender. Is there a way to look up those names for deletion without having to go through the whole list of names? Please help, going blind looking through all those names. Thank you |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Searching for a contact without going through the whole list.
In it's simplest form....Just:
1) Insert a column in front of the existing list, with a heading of ID_NUM. 2) Enter a seqential series of numbers, beginning with 1000. When you print the labels: Place that ID_NUM in a non-disruptive area of the label (eg upper right). For mailings that are returned you have a few options. Here are two: 1)Press Ctrl+F...Enter the ID_NUM....Press Enter (that ID_NUM will be selected) or 2)Enter the ID_NUMs in a single list. Then....Use an Advanced Filter to display only the ID_NUMs on that list. Does that help? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "vvsmith" wrote in message ... For future reference how do I assign each contact an ID_NUM I just started my job two weeks ago, so this data base was already in effect, but would love to change somethings to make it easier for me to work with. Thank you for any and all help vvsmith "Ron Coderre" wrote: Hmmm.....Large contact database in Excel. I'm tempted to explain why that might result in problems, but I think you're beginning to experience them. Possibly too late for this....but, if you assign a unique ID_NUM to each contact and include it in the address label, you could use Ctrl+F to find them. Is that something you can work with? -------------------------- Regards, Ron (XL2003, Win XP) Microsoft MVP (Excel) "vvsmith" wrote in message ... I have a large contact data base in Excel, and I send out a lot of mailings. Some get returned back to me, return to sender. Is there a way to look up those names for deletion without having to go through the whole list of names? Please help, going blind looking through all those names. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I export my contact list to my iPhone | Excel Discussion (Misc queries) | |||
Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
excel contact list | Excel Discussion (Misc queries) | |||
how do i import a contact list from a spreadsheet | Excel Discussion (Misc queries) | |||
How do I email my contact list to another computer | Excel Discussion (Misc queries) |