Automatically sending an E-mail of a previously exported file

Hello everyone,

I am making a macro in which users will request travel expenses with a userform in an excel workbook, this information will be filled in a worksheet, which is a format with ActiveX controls.

Since there are other sheets in the workbook, I decided to make the code open a new workbook only with the sheet containing the filled in format, and such form will be exported as a pdf file. Is the creation of the new workbook necessary? Or can I export this single sheet to pdf on the original workbook?
My second question is, how can I make the pdf save with today´s date? (which ever that date is)

Last but not least is that I would like this pdf to be e-mailed to me afterwards and I haven't had any success in what I'm trying.
Any suggestions?

I will post the code so far.

Thanks in advance

Please Login or Register  to view this content.

Hi dddddmex and welcome to ExcelForum,

Try the following code that should answer all 3 of your questions:
a. Saving sheet ("Sheet2") as Pdf without using another workbook
b. Putting Date in the Pdf File
c. Sending email with attachment using Outlook (Outlook must be already open)

Please Login or Register  to view this content.

Lewis