I haven't faxed from excel in, er, ever.

But maybe your fax software just acts like a printer.

You could record a macro when you change printers (to get the name correct) and
then print that range to the printer.

I'm not sure if your fax software (or any fax software) can be maniuplated from
excel's VBA.

Webtechie wrote:

Hello,

I am using Excel 2007. I've written code to print a range on my
spreadsheet. The boss wanted to be able to email the range, so I created
code that saves as pdf and then emails it as an attachment.

Great. Now the boss wants to fax the range to customers with a fax machine.
I have no idea how to fax a Excel range.

If anyone has any ideas, please let me know. Thanks for any and all help.

Tony

--

Dave Peterson