Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
adee pe Simpatie
 | Femeie
24 ani
Mures
cauta Barbat
24 - 59 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2334
|
|
Source:
Requirements: Office 365
function main(workbook: ExcelScript.Workbook) {
// Create variables
let ws = workbook.getActiveWorksheet();
let name = ws.getRange("C3").getText();
let emailAddress = ws.getRange("C4").getText();
let quote = ws.getRange("C12").getText();
let img = ws.getRange("B6:C10").getImage();
let imgHtml = `<img src="data:image/png;base64,` + img + `"style="width:400px"/><br/><br/>`
let emailBody =
`Hi ` + name + `<br/><br/>
Please the quote is <strong>£` + quote + `.</strong><br/><br/>
Which is based upon the following:<br/>
` + imgHtml + `<br/><br/>
If you wish to accept the quote, let me know.<br/><br/>
Kind regards,<br/><br/>
Mark`
// Send the e-mail
OfficeScript.sendMail({
to: emailAddress,
subject: "Quote",
contentType: OfficeScript.EmailContentType.html,
content: emailBody
});
}; |
_______________________________________
|
|
| pus acum 2 saptamani |
|