MsgBox ("This drawing does not appear to have a revision letter. " & _
"Make sure the Revision Block is properly updated and that the " & _
"correct revision letter is in the Revision custom property field. " & _
"After the revision letter has been corrected, please try again.") & _
vbNewLine & vbNewLine & ("Remember, sometimes the Revision custom " & _
"property link is disturbed by manual input and must have the current " & _
"revision letter manually entered before it automatically updates with " & _
"the revision block again." & vbNewLine & vbNewLine & "Check the PDF folder for this file name without a revision letter.")
Best way to copy and paste into notepad and remove the spaces then copy it and paste into vba.
Thank you! I was googling this but I wasn't phrasing it right, knew it had to be something simple.