I'll redo the macro today with your code. however my curiosity won't let go of why it doesn't work. Provoking my curiosity is; when I insert the code below right at the end, it works exactly as I expect. So I am terribly confused why "target1" doesn't work further up the macro.
In my world, I'd rather get a result than be right, but I am intensly curious none the less.
Code:
MsgBox ("remember to secure the PDF before sending")
Call Shell("explorer.exe """ & target1 & "", vbNormalFocus)
End Sub
I'll get back later today with a result.
Regards from a sunny Queensland.