So i want to be able to send a single Excel sheet to a recipient, not already pre-defined in the VBA. I am trying to get to where i can click a button/link and a window pops up, asking me to enter recipient's email address. When i enter the address and press- 'Send', the email is sent using Outlook.
I need help with this. Anyone please?
Prepare the email as you are doing (I assume) but then use Display instead of Send. You'll get a draft email that you can put an address in ... and edit if you wish.
Regards, TMS
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
I am a noobie and have no idea on what VBA to use and how to change what you advisedWould you mind helping me with this?
If you have nothing then the best place to go is Ron de Bruin's web site. He has examples of pretty much anything you want to do with Excel, VBA and Outlook.
If you have some code already, then please share it in a sample workbook.
Regards, TMS
Originally Posted by TMShucks
So what would i change here?
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks