View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gab1972 gab1972 is offline
external usenet poster
 
Posts: 57
Default Prompt the start of an email...user fills in email address

There is a lot of great information for sending emails...but all of
them seem to do one of two things...or both. Either they
automatically send the email (no prompt) and/or it's to attach the
workbook they are in.

What I want to do...
My workbook has the option for my users to send a permit application
package. I want the user to click a macro assigned button that will
start an email (Outlook) with just a subject (New Permit Application
Package) and body (Attached is the permit application package you will
need to submit for a new permit.) and then attach two files (a pdf,
and a word document). The macro would then unload and the user is
left to fill in the To line. Then when the user is ready, they
themselves click the Send button. I know this should be relatively
easy...just can't seem to figure it out. Ron has a lot of good
information but either I can't piece it together to make it work or I
have a lot of errors in my own tweaking. Any help would be greatly
appreciated.