Aretradeser
Board Regular
- Joined
- Jan 16, 2013
- Messages
- 176
- Office Version
- 2013
- Platform
- Windows
I need, by means of a VBA code, to send, from an Excel sheet, this same sheet, with the following conditions:
* That I can put the address of sending the email through a Msgbox.
* That the subject of the mail takes the name of the excel sheet to send.
* That the body of the email has the following text: "Enclosed I send file". The font of this text must be Calibri and size 14. In addition, an image must be included below the text: "Enclosed I send file", which is located in the path: C:\Documents\Images\Image1.png.
That the Excel sheet, in PDF format, that we are going to send by mail, complies with the following specifications:
* Horizontal format
* Left and right margins 1cm
* Top margin 2,5cm
* Lower margin 1cm
Finally, that it is not sent automatically, but that I am the one who sends the e-mail, once it has been opened in Outlook.
* That I can put the address of sending the email through a Msgbox.
* That the subject of the mail takes the name of the excel sheet to send.
* That the body of the email has the following text: "Enclosed I send file". The font of this text must be Calibri and size 14. In addition, an image must be included below the text: "Enclosed I send file", which is located in the path: C:\Documents\Images\Image1.png.
That the Excel sheet, in PDF format, that we are going to send by mail, complies with the following specifications:
* Horizontal format
* Left and right margins 1cm
* Top margin 2,5cm
* Lower margin 1cm
Finally, that it is not sent automatically, but that I am the one who sends the e-mail, once it has been opened in Outlook.