Using an Address Book Created in Excel
When you fax documents using the [Fax Sending Settings] dialog box of Desktop, you can use an address book created in Excel.
|
Note
|
|
The following file types can be used for address books.
Excel (.xlsx/.xlsm/.xlsb/.xls)
CSV (.csv) For other ways to set destinations, see the following.
To send faxes with the IP fax function, your device must support the IP fax function.
|
1.
Prepare an address book created in Excel.
The address items to enter in each column of the address book is indicated below.
|
Columm A
|
Destination name
|
|
Columm B
|
Company name
|
|
Columm C
|
Department name
|
|
Columm D
|
Fax number 1
|
|
Columm E
|
Fax number 2
|
|
Columm F
|
Enter the following number corresponding to [Communication Mode].
1: Intranet
4: VoIP Gateway
|
|
Columm G
|
Enter the following number corresponding to [Fax Number/URI].
0: Fax number
1: URI
|
|
Columm H
|
A maximum of 120 characters can be entered for the IP fax number.
|
|
Note
|
|
The first line in an Excel address book is the header. The header is not imported as an address.
Set [Format Cells] to [Text] for each column.
For the G3/G4 fax function, column D must be entered. Column F to column H are not required.
For the IP fax function, column F to column H must be entered.
If more than one of Fax number 1, Fax number 2, or IP fax number are included in the address book, the addresses are displayed on separate lines in [Address List].
If you entered something other than "1" (Intranet) in column F, enter "0" (Fax number) in column G.
|
2.
In the [Fax Sending Settings] dialog box, select [Canon Address Book] from the [Address Book] pull-down menu.
3.
Click [Browse].
The [Open] dialog box is displayed.
4.
Select a file to import into the address book and click [Open].
The selected file is loaded and the addresses read from it are displayed in [Address List].
|
Note
|
|
If you selected an Excel file with multiple sheets, select the sheet to use as the address book in the [Select Sheet] dialog box.
If the address book you created is currently open in Excel, it is not imported.
|
5.
Select a destination address in [Address List] and click [Add].
The selected destination address is shown in [Destination].
|
Note
|
|
You can select more than one address from [Address List] to add as destination addresses.
When you enter a keyword in [Search Keywords], the search results are displayed in the [Address List]. Click [Clear] to clear the search results.
When you select an address added to [Destination] and click [Edit], the [Edit New Destination Addresses] dialog box opens, and you can edit the address in the dialog box.
When you select an address added to [Destination] and click [Delete], the address is deleted.
You can click item names in the [Address List] and [Destination] lists to sort the items in ascending or descending order
|
6.
Set any other destination addresses if necessary.