I think that would depend on what your fax software offers in terms of
capabilities. It might have provisions to pass it a file name for getting
such information or to control it programmatically - you would have to check
with the documentation for your fax software and its print driver.

--
Regards,
Tom Ogilvy

wrote in message
...
Tom,
Thanks for your prompt response...I did try recording the
macro manually, but the portion where I tell the fax
program whom to fax the pages to never is recorded.

Is this as far as I can go with it?

Thank you.

Pam
-----Original Message-----
Usually I believe your fax software provided a print
driver. You install
that, select it as the default printer, then print to
the fax. Record a
macro while you do it manually.

--
Regards,
Tom Ogilvy

"PamG" wrote in
message
...
How do I use VBA to send a fax of an excel worksheet?


.