Jump to content

Fax merge Word 2007


Recommended Posts

My google skills are extremely lacking for some reason. I'm hoping someone here has run into this:

My bosses want to send a winter closing notice as a fax blast and I don't see 'Fax' as a document type on the mail merge wizard.

I have a SQL server that, as part of the production software that runs on it, has a physical fax modem installed on COM1 (faxing order acknowledgments, invoices, etc...). For purposes of this business need, I also have a copy of office 2007 installed on that server as well. Faxing from within Windows works just fine.

I have looked at




both of those articles have been suggested many times on the web, but neither have helped. I have installed the fax transport service in outlook, but I can only pull in outlook contacts. These contacts exist in our accounting system (QuickBooks Enterprise).

Has anyone successfully merged to fax from the built-in software? They don't want to have to go out and purchase a 3rd party program to do this.


Link to comment
Share on other sites

solved it, though it's not very elegant.

1. Through ODBC, pull out all my customers with fax numbers into excel.

2. Edit the list in excel to format the fax number canonically (1+ fax number with area code), and save it as a CSV.

3. Import those customers into outlook as contacts.

4. Using the fax mail transport protocol, type my message and select all the contacts as recipients

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...