Need help to organize address at work?
ariesalways411 asked:
Im looking to organize alot of bussiness address for work.
We have Microsoft Suite.
Word.
What I want to do is type all address in, and be able to catorgorize them as some local customers, other customer within state. and out of state customer…As an example.
I saw a mail merge…But that shows to bring it to address label form after you alreayd ahve a list address so keep that in mind to - In the future I want to be able pull up address to mail out.
Investment Jobs
Im looking to organize alot of bussiness address for work.
We have Microsoft Suite.
Word.
What I want to do is type all address in, and be able to catorgorize them as some local customers, other customer within state. and out of state customer…As an example.
I saw a mail merge…But that shows to bring it to address label form after you alreayd ahve a list address so keep that in mind to - In the future I want to be able pull up address to mail out.
Investment Jobs
One Response to “Need help to organize address at work?”
What you need is a very basic database, which will store not just the addresses but a code to show which type of customer they are. You can do this in Excel, using one column for each “field” (a field is the name, the first line of the address, the second line of the address etc., and of course the code). Set up the column for “code” with an Autofilter (Data -> Filter -> Autofilter).
When you want to send a mailing to, say, just the local customers, you use the drop-down list in the Autofilter to select only those with that particular code, and copy the resulting rows of addresses to another file; and then it’s that new file which you tell Word to look in for the addresses for the mailmerge.
It sounds harder than it is!