Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i make my own phonebook to send faxes
l.S,
I would like to make my own phonebook ( in groups) and then transfer this list to send faxes on my pc. Its time consuming to copy and paste these addresses one by one into my microsoft outlook address book. |
#2
|
|||
|
|||
poenki
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(or in your case fax number)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) Click "Yes" when you get the messages about losing formats and "are you sure"? Close the file. 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, 6 Sep 2005 09:04:40 -0700, poenki wrote: l.S, I would like to make my own phonebook ( in groups) and then transfer this list to send faxes on my pc. Its time consuming to copy and paste these addresses one by one into my microsoft outlook address book. |
#3
|
|||
|
|||
Try clicking on File - Import/Export - I was able to export my Contacts List
into an Excel spreadsheet. "poenki" wrote: l.S, I would like to make my own phonebook ( in groups) and then transfer this list to send faxes on my pc. Its time consuming to copy and paste these addresses one by one into my microsoft outlook address book. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how i make the excel send data or save it to another bad file | Excel Worksheet Functions | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
SEND TO menu | Excel Discussion (Misc queries) | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions | |||
make a cell empty based on condition | Charts and Charting in Excel |