Dansk Regneark Forum
  Hjælp Hjælp  Søg i forum   Arrangementer   Opret ny bruger Opret ny bruger  Log ind Log ind


Emne lukketHTML body - outlook

 Besvar Besvar
Forfatter
Tor4Every1 Se dropdown
Bronze bruger
Bronze bruger
Avatar

Medlem: 15.Mar.2021
Land: Danmark
Status: Offline
Point: 47
Direkte link til dette indlæg Emne: HTML body - outlook
    Sendt: 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&">&nbsp;</p>"



Til top



Til top
 Besvar Besvar

Skift forum Forum tilladelser Se dropdown

© 2010 - 2024 Dansk Regneark Forum - en del af Excel-regneark.dk