Ron,

I found a link to your Excel Email tips in another post and have made
great use of them. Thank you so much for your time and effort on this
matter. There is one other thing I have been trying to figure out, and
that is how to bring up the Save As PDF dialog so I can change where I
save the file each time I execute the script, but pre-populate the
name of the file using both a fixed value with a value from the
spreadsheet.

For example, I create a quote for Acme Company using my spreadsheet,
and the value of B5 is "Acme Company", When I press the button to
execute the script, the Save As PDF dialog comes up allowing me to
select the location I save this file to, but the name is pre-populated
as "QUOTE - Acme Company"

In case it effects your answer, I am Emailing Active Worksheet as PDF
and Inserting an Outlook HTML Signature in the body

Thanks in advance for your help.

magmike