+ Reply to Thread
Results 1 to 3 of 3

Automate Excel Worksheet to PDF and Send PDF in Outlook

  1. #1
    Registered User
    Join Date
    09-22-2020
    Location
    Miami
    MS-Off Ver
    Office 365
    Posts
    4

    Automate Excel Worksheet to PDF and Send PDF in Outlook

    Hello. I'm tasked with making a MACRO to automate sending PDF files in outlook. Most of the program works, specifically creating the PDF files from certain sheets. The problem is that the MACRO can't find the same PDF file that I saved even when using the same variable to hold the file path and name. Can anyone help me understand what the problem is?

    Please Login or Register  to view this content.
    Last edited by fbataille; 09-22-2020 at 09:52 PM.

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Automate Excel Worksheet to PDF and Send PDF in Outlook

    You missed the file extension.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-22-2020
    Location
    Miami
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Automate Excel Worksheet to PDF and Send PDF in Outlook

    Wow it works. Thank you.
    Last edited by fbataille; 09-23-2020 at 08:46 AM.

+ 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. Replies: 1
    Last Post: 01-17-2019, 09:40 PM
  2. Replies: 16
    Last Post: 10-19-2018, 12:34 AM
  3. VBA send worksheet in outlook email as paste values
    By Hoover5896 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2018, 06:48 PM
  4. [SOLVED] need to save one worksheet into pdf and send via outlook
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2015, 09:41 AM
  5. Using Excel to automate e-mails sent from Outlook?
    By Shelter417 in forum Excel General
    Replies: 3
    Last Post: 02-26-2012, 03:25 PM
  6. Send worksheet as an attachment to specified recipients via outlook
    By SunOffice in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-19-2011, 05:38 PM
  7. [SOLVED] Can I record or write a macro to send a worksheet via Outlook?
    By Catherine in forum Excel General
    Replies: 1
    Last Post: 09-14-2005, 12:05 AM

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