pause VBA code to view PDF file then continue or cancel

Logit · #2 06-16-2018, 09:08 PM

.
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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What Causes Outlook to Continue Changing File Size While Closed?	chasfh	Outlook	2	04-14-2018 06:32 AM
Displaying Code in a task usage view	ksa5024	Project	1	06-15-2016 06:15 PM
Stop macro if no file is selected in dialog box (when user presses cancel instead of selecting file)	spencerw.smith	Word VBA	2	08-12-2014 07:56 AM
How to save a PPT file in 'Reading View' to be opened always in 'Reading View'	ItzVickey	PowerPoint	2	08-08-2012 09:23 AM
How do you view the source code in a Word 10 web document?	provlima	Word	2	05-25-2012 01:12 PM