+ Reply to Thread
Results 1 to 2 of 2

Automatically sending an E-mail of a previously exported file

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Mexico
    MS-Off Ver
    Microsoft Office 2019
    Posts
    20

    Question Automatically sending an E-mail of a previously exported file

    Hello everyone,

    I am making a macro in which users will request travel expenses with a userform in an excel workbook, this information will be filled in a worksheet, which is a format with ActiveX controls.

    Since there are other sheets in the workbook, I decided to make the code open a new workbook only with the sheet containing the filled in format, and such form will be exported as a pdf file. Is the creation of the new workbook necessary? Or can I export this single sheet to pdf on the original workbook?
    My second question is, how can I make the pdf save with today´s date? (which ever that date is)

    Last but not least is that I would like this pdf to be e-mailed to me afterwards and I haven't had any success in what I'm trying.
    Any suggestions?

    I will post the code so far.

    Thanks in advance

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Automatically sending an E-mail of a previously exported file

    Hi dddddmex and welcome to ExcelForum,

    Try the following code that should answer all 3 of your questions:
    a. Saving sheet ("Sheet2") as Pdf without using another workbook
    b. Putting Date in the Pdf File
    c. Sending email with attachment using Outlook (Outlook must be already open)
    Please Login or Register  to view this content.
    Lewis

+ 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. [SOLVED] How to attach file and send mail automatically
    By thuydo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-27-2013, 03:50 AM
  2. Replies: 2
    Last Post: 05-03-2013, 01:49 AM
  3. Replies: 1
    Last Post: 12-28-2012, 03:46 AM
  4. Replies: 0
    Last Post: 09-12-2011, 06:10 PM
  5. [SOLVED] Sending lotus note Mail from excel - keeps connecting to default mail file
    By cozmo_83@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-25-2005, 06:50 AM
  6. [SOLVED] General mail failure when sending e-mail from Excel
    By Adrienne in forum Excel General
    Replies: 5
    Last Post: 11-04-2005, 08:59 AM
  7. Sending mail with Excel file attached, and cell-value inserted in Subject line
    By arunjoshi in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2005, 09:41 AM

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