How to attach 2 type of files to an Outlook email

[jlyn123]

Hello,

I am trying to attach a PDF version of an excel spreadsheet form I have as well as the spreadsheet itself but I cant seem to figure out the VBA code that will attach both types of files. I have been successful in attaching the PDF but I cant seem to figure out how to get the spreadsheet to attach as well. How do you combined those two requests in one code?

Can you please help me out here?

Thanks!

 

[John_w]

Welcome to Mr Excel forums.

Similar request to yours, with code that will need tweaking slightly, here - https://www.mrexcel.com/forum/excel...pdf-attach-email-post4902664.html#post4902664

 

[jlyn123]

Welcome to Mr Excel forums.

Similar request to yours, with code that will need tweaking slightly, here - https://www.mrexcel.com/forum/excel...pdf-attach-email-post4902664.html#post4902664

Thank you - this was very helpful and worked.

 

[jlyn123]

Hello,

How would you attached multiples tabs within the same excel spreadsheet to PDF in the same email?

Thanks,
Jenny

 

[John_w]

Multiple sheets (tabs) in one PDF file, or multiple sheets with 1 sheet per PDF? This does the former for 3 named sheets:

Public Sub Save_3_Sheets_As_PDF()

    Dim currentSheet As Worksheet
    
    With ThisWorkbook
        Set currentSheet = .ActiveSheet
        .Worksheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
        .ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ThisWorkbook.Path & "\Multiple Sheets.pdf", _
            Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False
        currentSheet.Select
    End With
    
End Sub

Then do

.Attachments.Add ThisWorkbook.Path & "\Multiple Sheets.pdf"

in the Outlook code.

 

[jlyn123]

Hello,

Yes, I was looking for multiple sheets per PDF but with this code I am getting a Compile error: For without Next. I tried to put in a Next code but its not working I get Next without For error. Any thoughts?

Thanks!

 

[John_w]

If you post your whole code we can help.