Send out email through command button and macros

[David77]

Hello everybody,

First of, please note that I am quite new at VBA coding and thus have extremely limited experience here.

I am currently trying to create an Excel workbook where customers can fill in their orders and "Submit" this to by pressing a button after which the order is sent by email to me.

I was figuring that the best way to do so would be to create a command button linked to a macro. However, this seems to be extremely difficult and I have naturally tried googling this to find solutions. Most of the solutions I found were able to create macros that sent out emails, but not emails that included the excel file as an attachment too.

In order to include the excel file as an attachment, I found the following link: Using Excel VBA to Send Emails with Attachments - wellsr.com which apparently should have solution

However, when I try to run this macro in my own excel file, it comes with the following error:

Does anybody here have any idea how I can fix this or provide a better solution to my problem? It would truly be much appreciated!

Thank you so much for your time, whoever may have read this.

Best regards,
David

 

[David77]

In the code David change the word

.Display

to

.Send

Hello Trevor,

Thank you so much!! This is amazing!

Final question, how do I create a command button that does this? Can I somehow link this VBA code to a command button in the sheet?

Best regards,
David

 

[Trevor G]

On your worksheet go to the Insert Tab and select a shape, more than likely the Rectangle and then point in the spreadsheet where you want it appear. To get a shape to fill the size of the cells hold down the ALT on the keyboard then click and draw with the mouse. Change the colour as necessary and right click on the button you have an option to Edit Text so you can type in what you want it to display. Finally right click the button again and you will see near the bottom Assign Macro, click that option and pick the macro by its name and away you go.

 

[David77]

On your worksheet go to the Insert Tab and select a shape, more than likely the Rectangle and then point in the spreadsheet where you want it appear. To get a shape to fill the size of the cells hold down the ALT on the keyboard then click and draw with the mouse. Change the colour as necessary and right click on the button you have an option to Edit Text so you can type in what you want it to display. Finally right click the button again and you will see near the bottom Assign Macro, click that option and pick the macro by its name and away you go.

Amazing!!

Thank you so much Trevor

May I ask, is there any way so I can get the Macro to give me a message after you have clicked it, such as: "Your order has been submitted by email. Thank you very much." ?

 

[Trevor G]

Add this line below the .Send

MsgBox "Your order has been submitted by email.", vbInformation, "Sent"

 

[David77]

Add this line below the .Send

MsgBox "Your order has been submitted by email.", vbInformation, "Sent"

Hello Trevor,

Thank you so much. It's perfect!

Is it possible to convert the sheet to a PDF file before I send out the Excel file by mail through the macro?

Best regards,
David

 

[Trevor G]

What you need David is inside this thread.

VBA code to convert excel to pdf and email it as attachment

Dear Forumers, I really need your help. I am new to this whole VBA coding thing have no basic at all in programming and stuff so please help me out here. I am currently assigned a project where I have to create a excel sheet which act as a templete for sending request. The requirement of the...

www.mrexcel.com