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
|
|||
|
|||
excel as address book
Hi Pete,
I your intent is to print labels, you would use Microsoft Word with your Excel sheet as the first sheet and used as the database. http://www.mvps.org/dmcritchie/excel/mailmerg.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Pete" wrote in message ... if I have used a excel sheet for an address book, Name, address, address1, etc etc in the columns and the individual address' in the rows, is there any way I can convert that to a list of all the different address' individually ??? |
#2
|
|||
|
|||
Pete
Sounds like each row is a separate person and address etc. but not sure. That is the normal format if you are exporting to an address book or using in a MailMerge with Word or similar. What exactly do you want done with the list you now have? Show us a small example, maybe 5 or 6 rows of data so's we can get a better idea. Gord Dibben Excel MVP On Wed, 11 May 2005 14:44:12 -0700, "Pete" wrote: if I have used a excel sheet for an address book, Name, address, address1, etc etc in the columns and the individual address' in the rows, is there any way I can convert that to a list of all the different address' individually ??? |
#3
|
|||
|
|||
Say I Have: Name Address Address 1 Tel email Peter 1 ding Place LA 3184748 pete@ding George 17 My Road NYC 4756474 George@My Can I get them to automatically go onto a page as follows, wihtout having to type them all out again??: Peter 1 ding place LA 3184748 pete @ ding George 17 My Road etc etc etc |
#4
|
|||
|
|||
yes, see my previous answer using Mail Merge, if you don't have Word
you can use the elephants are us example of John Walkenbach's in the related area, but Mail Merge is best. "pete" wrote in message ... Say I Have: Name Address Address 1 Tel email Peter 1 ding Place LA 3184748 pete@ding George 17 My Road NYC 4756474 George@My Can I get them to automatically go onto a page as follows, wihtout having to type them all out again??: Peter 1 ding place LA 3184748 pete @ ding George 17 My Road etc etc etc |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Can't configure contacts to be an email address book | sandra | Contacts | 19 | April 7th, 2005 12:34 AM |
Excel Address Book | Paul | General Discussion | 0 | November 16th, 2004 08:07 PM |
Express Address Book within Outlook | J. Lehman | Contacts | 8 | July 16th, 2004 10:35 PM |
Outlook 2003 e-mail problem | Mauro | Contacts | 5 | June 24th, 2004 09:19 PM |
Corrupt Address Book | Ibrahim Folarin | Outlook Express | 10 | June 17th, 2004 11:23 AM |