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
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