If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
address data base in which I can choose which to use for mailing
I want to set up an address data base in Excel. They would be a combination
of personal and business addresses. I want to be able to separate them for the purpose of printing mailing labels. I am new to Office, could someone suggest a template or solution ? Thank you. |
#2
|
|||
|
|||
address data base in which I can choose which to use for mailing
Open a new workbook.
In Sheet1 you will enter your titles across the row in individual cells. LastName FirstName Address City State Zip (and whatever else you wish) Last column title it Type Now assuming John Doe has two addresses...one personal and one business. Row 2 enter Doe John 123 main st. Albany NY 12345 enter a P in the Type column Row 3 enter Doe John 456 main st. Albany NY 67890 enter B in the Type column. Do this for each person in your list. If it is a personal address enter a P When you want to print mailing labels, do it through Word with Excel as the data source. You can filter or query on the P's and B's in the Type column. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training...RC010390291033 Gord Dibben Excel MVP On Thu, 15 Dec 2005 15:56:02 -0800, "Grammurph7" wrote: I want to set up an address data base in Excel. They would be a combination of personal and business addresses. I want to be able to separate them for the purpose of printing mailing labels. I am new to Office, could someone suggest a template or solution ? Thank you. |
#3
|
|||
|
|||
address data base in which I can choose which to use for maili
Thank you, Gord. I used to have all my addresses in Access and access was
not included in the software on my new computer. I think your suggestion just might work. I'm going to start reading through those links now. I'm anxious to enter all my addresses back into the computer. "Gord Dibben" wrote: Open a new workbook. In Sheet1 you will enter your titles across the row in individual cells. LastName FirstName Address City State Zip (and whatever else you wish) Last column title it Type Now assuming John Doe has two addresses...one personal and one business. Row 2 enter Doe John 123 main st. Albany NY 12345 enter a P in the Type column Row 3 enter Doe John 456 main st. Albany NY 67890 enter B in the Type column. Do this for each person in your list. If it is a personal address enter a P When you want to print mailing labels, do it through Word with Excel as the data source. You can filter or query on the P's and B's in the Type column. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training...RC010390291033 Gord Dibben Excel MVP On Thu, 15 Dec 2005 15:56:02 -0800, "Grammurph7" wrote: I want to set up an address data base in Excel. They would be a combination of personal and business addresses. I want to be able to separate them for the purpose of printing mailing labels. I am new to Office, could someone suggest a template or solution ? Thank you. |
#4
|
|||
|
|||
address data base in which I can choose which to use for maili
Grammurph7 wrote:
Thank you, Gord. I used to have all my addresses in Access and access was not included in the software on my new computer. I think your suggestion just might work. I'm going to start reading through those links now. I'm anxious to enter all my addresses back into the computer. "Gord Dibben" wrote: Open a new workbook. In Sheet1 you will enter your titles across the row in individual cells. LastName FirstName Address City State Zip (and whatever else you wish) Last column title it Type Now assuming John Doe has two addresses...one personal and one business. Row 2 enter Doe John 123 main st. Albany NY 12345 enter a P in the Type column Row 3 enter Doe John 456 main st. Albany NY 67890 enter B in the Type column. Do this for each person in your list. If it is a personal address enter a P When you want to print mailing labels, do it through Word with Excel as the data source. You can filter or query on the P's and B's in the Type column. For help on Word mail merge using Excel as the data source. http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training...RC010390291033 Gord Dibben Excel MVP On Thu, 15 Dec 2005 15:56:02 -0800, "Grammurph7" wrote: I want to set up an address data base in Excel. They would be a combination of personal and business addresses. I want to be able to separate them for the purpose of printing mailing labels. I am new to Office, could someone suggest a template or solution ? Thank you. If you already have an Access database, Access can be purchased separately. If you have a previous version and upgrade isn't real expensive. Also if you just open Excel and go to File open browse to the mdb file with your addresses you should be able to open the file and bring your data right into Excel. gls858 |
#5
|
|||
|
|||
address data base in which I can choose which to use for maili
If you still have the Access *.mdb kicking around, Excel will open it as a new
workbook. Gord On Fri, 16 Dec 2005 10:53:39 -0600, gls858 wrote: Thank you, Gord. I used to have all my addresses in Access and access was not included in the software on my new computer. I think your suggestion just might work. I'm going to start reading through those links now. I'm anxious to enter all my addresses back into the computer. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
allow the user to choose the currency he wants for a data base | chiefaccountant | New Users | 5 | February 12th, 2005 10:12 PM |
Pulling data from 1 sheet to another | Dave1155 | Worksheet Functions | 1 | January 12th, 2005 05:55 PM |
How do I get 3 series in sync with the x-axis? | zizbird | Charts and Charting | 10 | October 25th, 2004 01:23 PM |