I'm trying to attach the current workbook to a new Outlook email. I
need to have the text and subject lines be editable. Here's how I'm
creating the basic email, but I can't figure out how to attach the
current workbook. Any ideas? I'm not opposed to saving the file in a
temp folder and attaching it from there.
' Create the URL
URL = "mailto:" & Email & "?subject=" & Subj & "&body=" & Msg
' Execute the URL (start the email client)
ShellExecute 0&, vbNullString, URL, vbNullString,
vbNullString, vbNormalFocus