Unanswered: How to open email compose window w/ current Excel doc attached?
I have a button that, when clicked, should basically ShellExecute() a mailto:xxx@xxx so that the user's default mailer opens a compose window with subject and body prefilled.. but here's the catch... the current Excel sheet in its current state must be pre-attached to the e-mail.
All I need to do is have a commandbutton open a new mail window with attachments already inserted. But it's sounding like maybe this isn't possible without 3rd party apps? If we DO have to go the 3rd party route, what do you recommend?
Yeah.. I AM working within Excel..that's where the macros are. I know how to get the Excel sheet attached, I think it's SendForReview() or SendMail() or something. Problem is, I also need to allow the user to attach some JPEGs first.. AND I have to set the subject/body to a predetermined block of text (the user does not need to edit it at all).
Just another thought. I had developed a Form in Outlook that included all the addresses plus standard text. I then set up a macro in Outlook and attached to a button on the Outlook toolbar. This allowed the senior managers to click the button, bring up the pre-formatted Outlook message, and all they had to do was manually attach any Excel file. Is this of any help?
old, slow, and confused
but at least I'm inconsistent!
Well, the process here is kind of the opposite..sort of. They're going to be making lots of changes in an Excel sheet, and want a button within the Excel sheet to send off an email with predefined subj/body, and attach the Excel sheet in its current state along with as many JPEGs as they want to attach.