Tech Support Guy banner
Status
Not open for further replies.
1 - 9 of 9 Posts

· Registered
Joined
·
16 Posts
Discussion Starter · #1 ·
I have a worksheet that I email on a daily basis as the message body (don't want to send the entire file). Unfortunately my very computer illiterate coworkers can't do this without messing it up.

I'd like a button when clicked does the following:

1. Opens Outlook
2. Sends the active sheet as the message body.
3: To: AMG-NM-CREW
4: Subject: Crew Check In
5. Closes Outlook

I'm a novice at visual basic, so please be specific how I make any macros.
 

· Registered
Joined
·
7,842 Posts

· Registered
Joined
·
16 Posts
Discussion Starter · #3 ·
I got it setup. Can you help me get rid of that dialoge box that asks for permission for Excel to send the email? I'm using Outlook 2003. I saw an earlier post mentioning CDO, and other stuff I don't get. Please respond in lay speak :)
 

· Registered
Joined
·
7,842 Posts

· Registered
Joined
·
8,565 Posts
@ slurpee: in Outlook Express, it's Tools > Options > Security, then uncheck "Warn when other apps try to send mail as me".

There may be something similar in Outlook. HTH
 
1 - 9 of 9 Posts
Status
Not open for further replies.
Top