Using Excel for address book & address labels?

[beaucoup]

Looking for some advanced Excel users.

Years & years ago, when I was less computer savvy, DH set me up using Microsoft Outlook (full version) for the purpose of keeping our address book. I've never liked it.

I'm trying to streamline my life, record keeping, and other data. I would like to get rid of Microsoft Outlook since the only thing I used it for was the address book & its ability to print as a book, labels, or list.

I know more about databases and a little about macros than I did long ago. I know I can export the info in to an excel spreadsheet. But wondering is it possible to print that into an addressbook, custom lists or various labels? Would this require a macro? I hope they exist, because I don't want to learn about writing macros.

I just want a method that isn't going to have a program that I'm tied to for years in the future as operating systems change and my program becomes obsolete. I have Excel. I use Google docs too. I've become a bigger user of gmail & contacts, Google Calendar, GQueues & other google products. And using /sycing alot of that with my smartphone too. Want to try a different method than heavy cumbersome outlook which is way more than I ever needed.

 

[clh2]

Do you know how to do a Mail Merge in Word? It is very easy to "merge" any excel spread sheet into something different - i.e. mailing labels. Mail merge would also get you an address book -in the layout you prefer.

Good Luck!

 

[beaucoup]

Do you know how to do a Mail Merge in Word? It is very easy to "merge" any excel spread sheet into something different - i.e. mailing labels. Mail merge would also get you an address book -in the layout you prefer.

Good Luck!

So I would keep the data in a spreadsheet in Excel, but then merge it into Word to print it as I wish? Ok, that sounds doable.

I don't know how exactly, but I could learn.

 

[golfgal]

Do you know how to do a Mail Merge in Word? It is very easy to "merge" any excel spread sheet into something different - i.e. mailing labels. Mail merge would also get you an address book -in the layout you prefer.

Good Luck!

So I would keep the data in a spreadsheet in Excel, but then merge it into Word to print it as I wish? Ok, that sounds doable.

I don't know how exactly, but I could learn.

If you can read and type you can do mail merge. Make a "spreadsheet" of a couple addresses-fake ones even, then Open word and click on "Mail Merge" and select "labels" or "envelopes' or whatever you want to print. It gives you step by step directions. The hardest part is knowing your "label" size. Most of the labels come with one size on the package and you then have to find the "number" in the mail merge because they don't always match. Sometimes you have to dig for the 1 1/2"x 3" label, or whatever. I would just print to your regular computer paper for your practice ones. It's pretty easy to do. You can print envelopes right from mail merge too. I do this for Christmas cards

 

[Swank]

I use the Word Mail Merge to do my Mailing Labels from Exec as well.

 

[beaucoup]

Another question.
Is it better or more standard to do my records across or down?

Record meaning one persons name, address, etc.

 

[golfgal]

Another question.
Is it better or more standard to do my records across or down?

Record meaning one persons name, address, etc.

If you want to do a mail merge you have to do them across-and label your headings Name, Address, City, State, etc.