Home |
Search |
Today's Posts |
#1
|
|||
|
|||
mail list function
I have been told that I can enter names, addresses, emails and other customer
details into an excel workbook and then manipulate it to create an address lable list in word or a contact list for outlook express. I have entered all my info but am having difficulty proceeding. I am new to excel HELP! thank you |
#2
|
|||
|
|||
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 For the Contact List............... If all you want is to move a list of contacts from Excel to your Outlook address book Contacts list................ This is how I do it. The basics........Your layout may differ. Instructions here are for Name and Email address only, but adjust to suit for more columns. First have the names and email addresses in Excel in two columns. I set up also a third column with the names duplicated so when you Import to Outlook you have a name for the Contact and a Display Name instead of the email address in the To: box. FileSave AsFile Type CSV(comma delimited)(*.csv) Now open Outlook and FileImport/ExportImport from another fileComma Separated Values(Windows)NextFile to Import(you can browse to your saved *.csv file). Next you will be asked where to import them to. I bring mine to "Contacts". Follow the instructions and you will get a Map. Drag your names and addresses to the appropriate spots on the Map 1. Name of Contact 2. Email address1 3. Display Name(if you have one by making the duplicate column mentioned earlier). If not, the email address wil be displayed in the To: box. Continue with the OK's until Outlook pulls all from the *.csv file(should take only a few seconds). Now they are in the Contacts folder, you can group them as you wish. Gord Dibben Excel MVP On Tue, 15 Mar 2005 16:35:02 -0800, "samster" wrote: I have been told that I can enter names, addresses, emails and other customer details into an excel workbook and then manipulate it to create an address lable list in word or a contact list for outlook express. I have entered all my info but am having difficulty proceeding. I am new to excel HELP! thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the mail merge function from excell | Excel Discussion (Misc queries) | |||
If function using a list of criteria | Excel Discussion (Misc queries) | |||
Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
Mail merge type of function?? | Excel Discussion (Misc queries) | |||
Can I use a List in a IF Function? | Excel Worksheet Functions |