Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Attaching a File to an Outlook Email using VBA (in Excel)

  Asked By: Mindy    Date: Jan 25    Category: MS Office    Views: 2730
  

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

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Attaching a File to an Outlook Email using VBA (in Excel) Or get search suggestion and latest updates.




Tagged: