New Excel Forum
This forum has been moved to TeachExcel.com
Ask all future questions in the New Excel Forum.
ExcelKey
|
|
Unlocking the Mysteries of Excel
|
email selected active windowfrom worksheet
5 posts
• Page 1 of 1
email selected active windowfrom worksheet
by RichardOwls » Thu Jan 05, 2012 11:23 am
I want to auto send an email attachment of a selected sheet on a workbook from macro just like when sending the same selected sheet to print a copy. Any advise? Thanks.
- 0
- RichardOwls
- Rookie
- Posts: 1
- Joined: Jan 5, 2012
- Reputation: 0
Re: email selected active windowfrom worksheet
by charles » Thu Jan 05, 2012 1:00 pm
Richard,
Welcome to the forum.
This is a common question. You can visit this site. You may find an answer there. If you do and you need some adjustment let us know and we'll help you.
Welcome to the forum.
This is a common question. You can visit this site. You may find an answer there. If you do and you need some adjustment let us know and we'll help you.
- 0
There are other ways too do this but...
Be kind let us know if you posted somewhere else!
Charles
Be kind let us know if you posted somewhere else!
Charles
- charles
- Excel Badass
- Posts: 632
- Joined: Dec 10, 2011
- Location: Mississippi
- Reputation: 1
- Excel Version: Excel 2003, 2007 and Mac 2011
Re: email selected active windowfrom worksheet
by Sisyphus » Fri Jan 06, 2012 8:44 am
Which site, charles?
- 0
Have a great day! 
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
Sisyphus
I do this for "honour and country" - much less of the latter, actually.
If I helped you, award points, plenty of them.
If I bored you, deduct points for being too long-winded. (I know, :lol)
- Sisyphus
- Former Moderator
- Posts: 4454
- Joined: Dec 7, 2011
- Location: Shanghai
- Reputation: 203
- Excel Version: 2010
Re: email selected active windowfrom worksheet
by Don » Fri Jan 06, 2012 9:54 am
This site will give you everything you ever wanted for emailing from Excel using macros and VBA:
http://www.rondebruin.nl/sendmail.htm
http://www.rondebruin.nl/sendmail.htm
- 0
- Don
- Moderator
- Posts: 733
- Joined: Dec 4, 2011
- Reputation: 2
- Excel Version: 2010
Re: email selected active windowfrom worksheet
by charles » Fri Jan 06, 2012 11:34 am
As one of our "Presidential" candidates said "Oops". I did not make sure the site pasted to to post.
Thanks for the catch.
Thanks for the catch.
- 0
There are other ways too do this but...
Be kind let us know if you posted somewhere else!
Charles
Be kind let us know if you posted somewhere else!
Charles
- charles
- Excel Badass
- Posts: 632
- Joined: Dec 10, 2011
- Location: Mississippi
- Reputation: 1
- Excel Version: Excel 2003, 2007 and Mac 2011
5 posts
• Page 1 of 1
Return to Macros and VBA Questions
Who is online
Users browsing this forum: Google [Bot] and 255 guests