VBA code to send a mail

jay - Mar 17, 2010 at 07:45 AM
 Waseem - Apr 3, 2010 at 02:19 AM

guys, im looking for a VBA code to write that so when i click upon a command button it will populate a pre ready email with a fixed list of recipiants, any ideas guys???

help much appreciated.

p.s. i have created a hyperlink but with this i cant seem to get a tidy button, hence why i have created a command button but jst need a vba code to populate the mail.

2 responses

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Mar 17, 2010 at 09:40 AM
Could you post your workbook I am not sure what is the issue.

basically you would have a button and behind the button there would be a code that will get executed and send email out. May be sharing WB would clarify things for me at least

Please find below the VB Code for Button to Send Email by using default Email Program.

I am also finding the way to send the email to a specific Email Address by the click of button. If anyone know please guide.

Private Sub CommandButton1_Click()

End Sub

Waseem Amjad