VBA code to send a mailClosed

Question

Hello,

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.

rizvisa1 · Answer

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

Waseem · Answer

Dear, 

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() 
ActiveDocument.SendMail 

End Sub  

Waseem Amjad

VBA code to send a mail

2 responses

Similar discussions

Subscribe To Our Newsletter!