VBA code to send a mail

Closed
jay - Mar 17, 2010 at 07:45 AM
 Waseem - Apr 3, 2010 at 02:19 AM
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.
Related:

2 replies

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
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
0
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
0