Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

excel macro email


  • Please log in to reply

#1
dec

dec

    New Member

  • Member
  • Pip
  • 2 posts
I need a macro associated with a control button that will send the active sheet in the form of an email, with a specific subject.
  • 0

Advertisements


#2
Octagonal

Octagonal

    Member 2k

  • Member
  • PipPipPipPipPip
  • 2,528 posts
You may not need a macro. Why not simply use the menu File/Send To/Mail Recipient (as Attachment...). You can put a button on the toolbar for this by selecting Tools/Customize..., select the Commands tab and drag the button to the toolbar. If you have any problems putting the button on the toolbar, read this link for assistance.

HTH
"O"
  • 0

#3
dec

dec

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
Thanks very much for that - certainly made progress... ideally I'd like to be able to compete the eMail address rather than ask a user to do that, and set different 'subject' texts depending on which button was pressed...

Ta!
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP