Auto send email

Hello everyone.

This is my first time posting on this forum. Hope you can help.

I would like to create a code (macro) to auto send the excel data to the supplier.

Posnetek zaslona 2022-03-14 152124.png

I would like to send the data about quantities, parts, code, dimension to our supplier with one cliick.

This is the marco I'm trying to modify:
222.png
we use it for this sheet:
333.png

I would like to modify the code for my above sheet. So when i would click on the macro the data of the sheet would be send to the specified email.

Could you help me?

Best regards,

Dejan

It is hard to work with pictures. It would be easier to help and test possible solutions if you could attach a copy of your file. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary). See the yellow banner at the top of this page for instructions to attach a file. Also, it would help if you could translate the column headers so that we know which ones contain data about quantities, parts, code and dimension.

Your duplicate thread on this has been closed. You were not asked to open a new thread. Please post the requested extras HERE. Thanks.

Thanks for your answer. I managed to write a code to send the email with subject and some text, but now I would like to add a table in the body. I use this code bellow. What hould i write in the "theBodyP" row if i want to send a specific table from excel?

Please Login or Register  to view this content.

Please edit your post by using code tags. Select the code and then click the # icon in the menu.
What range is the table in? It would help if you could attach a copy of your file as I suggested in Post #2.

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new here, I have done it for you this time.)