Results 1 to 2 of 2

Email Notification when a request has been submitted via a macro button?

Threaded View

jonvanwyk Email Notification when a... 07-21-2011, 12:51 PM
jonvanwyk Re: Email Notification when a... 07-21-2011, 01:07 PM
  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    Email Notification when a request has been submitted via a macro button?

    I am using the code below to create a PDF and automatically save it to a network drive when a "submit" button is pushed. How would I modify the code below to send an email notification that a PDF is waiting on the the network drive for a particular person to view it?

    
    If ([A51] = True Or [A53] = True Or [A54] = True Or [A56] = True) And _
      ([A60] = True Or [A61] = True Or [A62] = True Or [A63] = True) Then
        FileName = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 5)
        ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
                "S:\Folder\" & Cells(2, 2).Value & " - " & Cells(6, 2).Value & ".pdf", _
                Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
                :=False, OpenAfterPublish:=False
        Range("A1:D28").Select
    
    End If
    Last edited by jonvanwyk; 07-21-2011 at 01:05 PM.

Thread Information

Users Browsing this Thread

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

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