HTML body - outlook
Udskrevet fra: Dansk Regneark Forum
Kategori: Hjælp til regneark.
Forum navn: Makro og VBA
Forum beskrivelse: Hjælp til Makroer og VBA-programmering
Web-adresse: https://forum.excel-regneark.dk/forum_posts.asp?TID=4762
Udskrevet den: 27.Apr.2024 kl. 17:17
Emne: HTML body - outlook
Besked fra: Tor4Every1
Emne: HTML body - outlook
Posteringsdato: 29.Jul.2022 kl. 08:16
|
Hejsa, ¨ Jeg håber nogen kan hjælpe herinde. Jeg har lavet et ark som skal sende en mail fra outlook. Derinde er der produceret en html kode til at skrive teksten og få din nødvendige informationer med. Den er opbygget i en kasse. jeg kan sagtens få alt data med, men mangler den sidste streg i kassen til at bryde de to emner. håber der er en ansvarlig som kan hjælpe. ( Billede nederste af mail efter kørsel af marcr) html i kode til mail. ="<BODY style=font-size:11pt;font-family:Calibri><p>Hej alle</p>"&"<p>Hermed salgsindberetning:</p>"&"<table style="&K1&"width: 526pt; border-collapse: collapse;"&K1&" width="&K1&"0"&K1&">"&" <tbody> <tr style="&K1&"height: 19.5pt;"&K1&"> <td style="&K1&"padding: 0.75pt; border: 1pt solid windowtext; width: 59pt; height: 19.5pt; background-color: transparent;"&K1&" width="&K1&"79"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&"><strong><span style="&K1&"font-family: 'Calibri',sans-serif;"&K1&">Afl. dato</span></strong></p>"&" </td> <td style="&K1&"border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0.75pt; width: 59pt; height: 19.5pt; background-color: transparent;"&K1&" width="&K1&"79"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&"><strong><span style="&K1&"font-family: 'Calibri',sans-serif;"&K1&">Afd.</span></strong></p> </td>"&" <td style="&K1&"border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0.75pt; width: 212pt; height: 19.5pt; background-color: transparent;"&K1&" width="&K1&"283"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&"><strong><span style="&K1&"font-family: 'Calibri',sans-serif;"&K1&">Byggeadresse</span></strong></p> </td>"&" <td style="&K1&"border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0.75pt; width: 75pt; height: 19.5pt; background-color: transparent;"&K1&" width="&K1&"100"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&"><strong><span style="&K1&"font-family: 'Calibri',sans-serif;"&K1&">Type</span></strong></p> </td>"&" <td style="&K1&"border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0.75pt; width: 50pt; height: 19.5pt; background-color: transparent;"&K1&" width="&K1&"67"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&"><strong><span style="&K1&"font-family: 'Calibri',sans-serif;"&K1&">Sagsnr.</span></strong></p> </td>"&" <td style="&K1&"border-width: 1pt 1pt 1pt 0px; border-style: solid solid solid none; border-color: windowtext windowtext windowtext #000000; padding: 0.75pt; width: 71pt; height: 19.5pt; background-color: transparent;"&K1&" width="&K1&"95"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&"><strong><span style="&K1&"font-family: 'Calibri',sans-serif;"&K1&">Mursten</span></strong></p> </td>"&" </tr> <tr style="&K1&"height: 65pt;"&K1&"> <td style="&K1&"border-width: 0px 1pt 1pt; border-style: none solid solid; border-color: #000000 windowtext black; padding: 0.75pt; width: 59pt; height: 65pt; background-color: transparent;"&K1&" rowspan="&K1&"3"&K1&" width="&K1&"79"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$A$2&"</p> </td>"&" <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext black #000000; padding: 0.75pt; width: 59pt; height: 65pt; background-color: transparent;"&K1&" rowspan="&K1&"3"&K1&" width="&K1&"79"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$B$2&"</p> </td>"&" <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 212pt; height: 44.95pt; background-color: transparent;"&K1&" width="&K1&"283"&K1&">"&" <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$C$2&"</p> </td>"&" <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext black #000000; padding: 0.75pt; width: 75pt; height: 65pt; background-color: transparent;"&K1&" rowspan="&K1&"3"&K1&" width="&K1&"100"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$D$2&"</p> </td> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext black #000000; padding: 0.75pt; width: 50pt; height: 65pt; background-color: transparent;"&K1&" rowspan="&K1&"3"&K1&" width="&K1&"67"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$E$2&"</p> </td> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 71pt; height: 44.95pt; background-color: transparent;"&K1&" width="&K1&"95"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$F$2&"</p> </td> </tr> <tr style="&K1&"height: 15.75pt;"&K1&"> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 212pt; height: 15.75pt; background-color: transparent;"&K1&" width="&K1&"283"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$C$3&"</p> </td> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 71pt; height: 15.75pt; background-color: transparent;"&K1&" width="&K1&"95"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$F$3&"</p> </td> </tr> <tr style="&K1&"height: 15.75pt;"&K1&"> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 212pt; height: 15.75pt; background-color: transparent;"&K1&" width="&K1&"283"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$C$4&"</p> </td> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 71pt; height: 15.75pt; background-color: transparent;"&K1&" width="&K1&"95"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$F$4&"</p> </td> </tr> <tr style="&K1&"height: 15.75pt;"&K1&"> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 212pt; height: 15.75pt; background-color: transparent;"&K1&" width="&K1&"283"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$C$4&"</p> </td> <td style="&K1&"border-width: 0px 1pt 1pt 0px; border-style: none solid solid none; border-color: #000000 windowtext windowtext #000000; padding: 0.75pt; width: 71pt; height: 15.75pt; background-color: transparent;"&K1&" width="&K1&"95"&K1&"> <p style="&K1&"margin: 0cm 0cm 0pt;"&K1&">"&$F$4&"</p> </td> </tr> </tbody> </table><p style="&K1&"&K1&"&K1&"margin: 0cm 0cm 0pt;"&K1&"&K1&"&K1&"> </p>"  |