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)
="<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>"
Forum start
Forummets regler
Sådan uploader du filer
Marker Accepteret løsning
Del dine regneark
Excel-regneark.dk
HTML body - outlook
Emne funktioner
