LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Send data from Excel in email from specific email address Erik Excel Programming 5 December 5th 07 05:09 PM
send wkbk as an email attachment with an email address copied from SueInAtl Excel Discussion (Misc queries) 0 May 21st 07 10:53 PM
can I copy a column of email addresses, paste into email address? Lizizfree New Users to Excel 4 July 20th 06 10:03 PM
Transfer Email addresses from spreadsheet to email address book Beana Excel Discussion (Misc queries) 2 May 30th 06 06:07 PM
Find User Default Email Address in Outlook aph Excel Programming 4 February 1st 06 09:41 AM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"