Good afternoon all,
I'm trying to create a button in an Excel 2010 spreadsheet to open up a new message in excel with a predefined recipient and subject but I keep coming up short. Just need a blank, editable email so people will be able to paste the data in and hit send. Any suggestions?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry I am a bit of a vba noob, I literally just need a macro where clicking on the button opens a blank new message in outlook with the recipient and subject filled in. These all seem a little more complicated than that?
Perhaps if you post an example of what you have tried, someone may give some pointers as to how to correct it...but I keep coming up short.
The site contains examples of creating and displaying, or sending, emails.
Most examples would have the same core code. And you would need to edit the .Subject, .To, .cc, and .Body parts to include information for the user. You haven't shared any of that information, so it isn't possible to give you a detailed solution.
This is a generic example to do what you want: http://www.rondebruin.nl/win/s1/outlook/bmail4.
(Slightly modified)
I tend not to offer specific solutions for email questions as all the information is available at Ron's site.
Please Login or Register to view this content.
You just need to assign the macro to your button.
In it's most simple way.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thanks to you both I seem to have got it working :D
You're welcome and thanks for adding rep points.
Ditto. You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks