View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Neil Meehan Neil Meehan is offline
external usenet poster
 
Posts: 1
Default Attaching PDF files

I have successfully written some vba code to email a schedule to my
coworkers from excel via outlook. The vba code works well but now some
of them would like a PDF version. I use "cutePDF" free and I also have
FlashPaper 2 installed. Is there a way to access these via VBA to
produce a pdf of a single sheet and attach it to the email? If not is
there another way to automate the process of both producing a PDF and
attaching it to email. Thanks