E-mail automation

V

Very Basic User

Hello, I have the following macro started. It opens a new mail form and
converts my excel file into a PDF ready to be sent. Is there anyway to add
code that will complete the To: section and actually mail the file
automatically?

Sub Mail()
'
' Mail Macro
'
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\DOCUME~1\G2844JF\LOCALS~1\Temp\Copy of MASTER Production
Meeting.pdf", _
Quality:=xlQualityStandard, IncludeDocProperties:=False,
IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Application.Dialogs(xlDialogSendMail).Show
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA macro creating pdf 9
Sending Excel Worksheet as PDF file with Excel 2007 3
Baffled, can record macro, and then RTE5. Macro works fine on another PC. Excel2007 2
ExportAsFixedFormat Options 0
Selecting multiple sheets to print to PDF 7
ExportAsFixedFormat? 4
Excel Convert excel sheet to pdf, faulty vba code 0
PDF basics 1

Top