From: Fred on 28 Feb 2010 22:36
how can I create an email with an attachment using the SendMail dialog.
When I record a macro and "Send: Email as PDF Attachment" I get
ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
Running this macro does not work as it attaches the full Excel workbook to
the email. The ExportAsFixedFormat does work as it does create a the PDF
file, but this PDF file does not get attached to the email.
How can I get the file "C:\DOCUME~1\ME~1.COM\LOCALS~1\Temp\REOI11.pdf" to be
the attachment on the email.
Thanks for any help
Prev: MSCOMM Control with Excel 2003
Next: Test named range exists & exclude worksheet if it doesn't