I don't know about Adobe but, this is an alternative.

Application.ActivePrinter = "Microsoft Office Document Image Writer on
Ne01:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Microsoft Office Document Image Writer on Ne01:", Collate:=True

It will save the file as "filename(your file's name).mdi" There may be
compatability issues with this. Your recipients may have to have Microsoft
Office Document Image Writer on their PCs.
--
Best wishes,

Jim


"clara" wrote:

Hi all,

I have a sheet to be used as a notice to clients, I want to mail this sheet
as a attachment of email, now I can copy this sheet to a new workbook, and
email the workbook to client. the copy process takes too long, so I think I
might print out the sheet to a PDF file and email the pdf file . Is it
possible? How can I do it.

Clara
--
thank you so much for your help