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

SendMail 0
Macro to Publish as PDF 1
VBA macro creating pdf 9
PDF the Excel Report 3
Sending Excel Worksheet as PDF file with Excel 2007 3
Selecting multiple sheets to print to PDF 7
PDF basics 1
Macro stops running if date is not in past... 3

Top