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

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

Dave,

I guess you were trying to help.

I have code to print to specific printer. In this case it would be the
shared fax. Now, what I am trying to know is who to code that. I'm not sure
if I would code for an email and use the fax number in the to address.

I was hoping someone else has tried to send out faxes through VBA.

I am using Small Business Server 2003 Fax Services. The clients are mostly
Windows XP. I don't think there is an Fax object model, but there might be
someone that has accomplished this with using an Outlook object model or
something.

I am open to any ideas. But thanks for responding.

Tony

"Dave Peterson" wrote:

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
.

Don't know if you still need it, but i was looking for something similar and found this post www.pcreview.co.uk/forums/thread-543889.php<

Don't know why the guy had problems with his code, works great with xp pro and office xp. I needed to add the fax services in the windows setup and in the excel VBA editor i added under toolsreferences: ms fax service extended com and faxcom 1.0 type libary.



Webtechie wrote:

Dave,I guess you were trying to help.I have code to print to specific printer.
18-Feb-10

Dave,

I guess you were trying to help.

I have code to print to specific printer. In this case it would be the
shared fax. Now, what I am trying to know is who to code that. I am not sure
if I would code for an email and use the fax number in the to address.

I was hoping someone else has tried to send out faxes through VBA.

I am using Small Business Server 2003 Fax Services. The clients are mostly
Windows XP. I do not think there is an Fax object model, but there might be
someone that has accomplished this with using an Outlook object model or
something.

I am open to any ideas. But thanks for responding.

Tony

"Dave Peterson" wrote:

Previous Posts In This Thread:

On Wednesday, February 17, 2010 8:17 PM
Webtechie wrote:

Code to fax range?
Hello,

I am using Excel 2007. I have 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

On Wednesday, February 17, 2010 8:25 PM
Dave Peterson wrote:

I have not faxed from excel in, er, ever.
I have not 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 am not sure if your fax software (or any fax software) can be maniuplated from
excel's VBA.

Webtechie wrote:

--

Dave Peterson

On Thursday, February 18, 2010 1:41 AM
Webtechie wrote:

Dave,I guess you were trying to help.I have code to print to specific printer.
Dave,

I guess you were trying to help.

I have code to print to specific printer. In this case it would be the
shared fax. Now, what I am trying to know is who to code that. I am not sure
if I would code for an email and use the fax number in the to address.

I was hoping someone else has tried to send out faxes through VBA.

I am using Small Business Server 2003 Fax Services. The clients are mostly
Windows XP. I do not think there is an Fax object model, but there might be
someone that has accomplished this with using an Outlook object model or
something.

I am open to any ideas. But thanks for responding.

Tony

"Dave Peterson" wrote:


Submitted via EggHeadCafe - Software Developer Portal of Choice
What's New for Developers in SharePoint 2010 Object Model?
http://www.eggheadcafe.com/tutorials...evelopers.aspx