View Single Post
 
Old 06-16-2018, 09:08 PM
Logit Logit is offline Windows 10 Office 2007
Expert
 
Join Date: Jan 2017
Posts: 533
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

.
If it were me .. I would allow the PDF to display after creation. Review the PDF and decide if it requires editing.

In your macro code, just before "With MailOutLook" which is right after the creation of the PDF file, insert this macro code :

Code:
Dim Msg As String, Title As String
  Dim Config As Integer, Ans As Integer
  Msg = "Approve sending the PDF file ? "
 
 
  Title = "Proceed YES / NO "
  Config = vbYesNo + vbQuestion
  Ans = MsgBox(Msg, Config, Title)
  If Ans = vbYes Then GoTo continue:
  If Ans = vbNo Then Exit Sub
continue:
This will give you an opportunity to choose continuing with the PDF as is, or exiting the email macro completely so you can make changes to the PDF.
Reply With Quote