Database is at U:\CBS\VitaContacts.mdb
in Access:
Queries->FaxLocal;File->Export->C:\CBS\FaxLocal.csv->delimited->comma(include field names,text qualifier ")
Queries->FaxLongDistance;File->Export->C:\CBS\LongDistance.csv->delimited->comma(include field names,text qualifier ")
Edit .csv files put "Company","Business Fax" on first line

import address to outlook:
in OutLook Contacts page:
File->"Import and Export"->"Import from another program or file"->Comma Separated Values (DOS)-><file name>->Contacts->Finish
Note: use comma delimited "\tCompany\tBusiness Fax" to use in MSfax (inital tab is important)
Notes for MSfax
MSfax wants to add areacode to local numbers but doesn't add '1' to long distance
workaround is to use spaces for local numbers: 9 8 4-8653
and '1+' for long distance: 1+(337)984-8653

Setting up dialing rules (Not honored with OutLook/MSfax): 
Control Panel-> Phone and Modem options->edit 'My Location'-> Area Code Rules tab
higlight rule to edit it: 
  area code: 337
  ???Include only the prefixed listed: 893,942,948 ???
  When dialing the numbers that contain the prefixes above:
    Dial 1
    Include the area code
rule: '337' 'All' 'Dial 1 plus area code'

to fax an image:
use IrfanView
File->print->select 'Fax' as Printer then click Print to get 'Send Fax Wiziard'
in 'Send Fax Wiziard'->next->(note: 'Use Dialing Rules' doesnt work) click address book
in 'Address Book' window, select locations on left and copy to right with 'To->' then click 'OK' button.
Back in 'Send Fax Wiziard', click 'Next' select cover page (WORKSHOP), click 'NEXT' send 'now', click 'Next'
note: FAX files in C:\Documents and Settings\All Users\Application Data\Microsoft\Windows NT\MSFax\
NOTE: To kill pending faxes from cue: settings->printers and faxes->Fax->Outbox [select and delete] (not tested yet!)


nawk -F "\t" '{gsub("\x00","");print $37"|"$8"|"$11"|"$5"|"}' /mnt/TOSHw/Documents\ and\ Settings/All\ Users/Application\ Data/Microsoft/Windows\ NT/MSFax/ActivityLog/OutboxLOG.txt | grep "Completed" | nawk -F "|" '{p=$3;gsub(" ","",p);gsub("\x22","",p);print p;}' > ! Completed.lst ; grep -f Completed.lst name_phone_fax.txt
##################### Mon Oct  9 14:59:32 CDT 2006
C:\Documents and Settings\All Users\Application Data\Microsoft\Windows NT\MSFax\ActivityLog\OutboxLOG.txt
nawk -F "\x22" '{for (i=1;i<=NF;i++)print i,":",$i;}' /tmp/OutboxLOG.txt | more
nawk -F "\x22" '{print $8,$14,$58}' /tmp/OutboxLOG.txt
mv OutboxLOG.txt OutBoxLog.txt
FaxRept.awk

#####################
To rename fax OutboxLOG.txt:
control panel->Administrative tools->Component services->Sevices(local)
Highlight Fax and "Stop the service"

C:\Documents and Settings\All Users\Application Data\Microsoft\Windows NT\MSFax\ActivityLog\OutboxLOG.txt

##################### Fri Jan 12 07:32:07 CST 2007

                STEPS FOR FAXING
1) Export FaxLocal and FaxLongDist as tab delimited w/ qualifiers (quotes)
2) PhoneNameFax as space delimited and no text qualifiers (no quotes)
2) cat /tmp/FaxLocal.txt /tmp/FaxLongDist.txt>! /tmp/Fax.txt
4) vi /tmp/Fax.txt
   "Company"<tab>"Business Fax"
(note: need to be DOS format so may need to open w/ WordPad and save again)
5) Import /tmp/Fax.txt into OutLook (file->import from another program or file->Tab separated Values Windows)->Contacts
6) Reset OutboxLOG.txt (as above)
7) send faxes
8) copy contents of OutboxLOG.txt to /tmp/OutboxLOG
9) nawk -F "\x22" '{s=$14;s=substr(s,length(s)-3);if ($8=="Call completed")print s "|" $8,$14,$58}' /tmp/OutboxLOG | nawk -F "|" '{print $1}'i | sort -u>! /tmp/grep.lst
10) Create report: grep -f /tmp/grep.lst /tmp/PhoneNameFax.txt
11) grep -vf /tmp/grep.lst /tmp/Fax.txt >! /tmp/Fax_2.txt
12) Import /tmp/Fax_2.txt into OutLook and repeat steps 6-11
NOTE: to cancel Faxes: Fax Consol -> OutBox (not Fax Monitor) <delete items>

Work around for getting data into fax address book:

1) Export from Access:
Export->csv->Delimited->Comma, Include names 1st row, text qualifier quote-> 
2) edit csv file change "Other Fax" to "Business Fax"
3) run wab in dos or start->run (C:\i386\wab.exe)
4) File->Import->"Other Address Book"-> "Text file (CSV)"->Browse for CSV file->(change mapping if necessary) and finish)
5) Contacts should be in the fax address book under "Main Identity's Contacts"