+ Reply to Thread
Results 1 to 3 of 3

VBA code to add previously created PDF file as attachment in outlook

  1. #1
    Registered User
    Join Date
    10-04-2018
    Location
    Cancun, Mexico
    MS-Off Ver
    2013 & 2016 32b
    Posts
    78

    VBA code to add previously created PDF file as attachment in outlook

    good afternoon

    i have a VBA code that create a PDF file from a worksheet , i need to complete a code that when CheckBox5 is selected add that created PDF file as attachment in outlook to send it by mail.

    Please Login or Register  to view this content.
    thank you for you help

  2. #2
    Valued Forum Contributor PaulSP8's Avatar
    Join Date
    11-21-2017
    Location
    Chorley, England
    MS-Off Ver
    2013 & 2021
    Posts
    437

    Re: VBA code to add previously created PDF file as attachment in outlook

    Add the following to the top of the Code;

    Please Login or Register  to view this content.
    Then try this as your "If"

    Please Login or Register  to view this content.
    (I don't know if you'll need to add the extension as I can't see 'fileSaveName' - Just remove the comment if needs be )

  3. #3
    Registered User
    Join Date
    10-04-2018
    Location
    Cancun, Mexico
    MS-Off Ver
    2013 & 2016 32b
    Posts
    78

    Re: VBA code to add previously created PDF file as attachment in outlook

    Thank you very much

    working fine

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Outlook VB Code to export attachment
    By rizmomin in forum Outlook Formatting & Functions
    Replies: 3
    Last Post: 09-14-2018, 08:40 AM
  2. Save outlook attachment as file using email subject as file name w/o invalid characters
    By kristinlarmer in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 10-16-2015, 05:07 PM
  3. [SOLVED] Outlook Attachment - PDF file not attaching.
    By Maroota in forum Outlook Formatting & Functions
    Replies: 16
    Last Post: 05-01-2015, 06:57 AM
  4. [SOLVED] Need to update code previously created by Berlan to add other sections to summary sheet.
    By missit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2015, 09:54 PM
  5. Replies: 0
    Last Post: 01-20-2015, 10:07 PM
  6. code to save attachment from Outlook mail
    By prabhuduraraj09 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-22-2014, 07:11 AM
  7. [SOLVED] Drag Attachment file from Outlook to OLE Object
    By Ronin in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-15-2005, 12:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1