opret et emne og vedhæft et excel ark
hej ..her opretter jeg en (ide/emne) men jeg vil gerne have man kan vedhæfte et word eller excel ark men hvordan...
<%
if request.form("send") <> "" then
' ADODB connection objektet
Set Conn = Server.CreateObject("ADODB.Connection")
' Husk at angive den rigtige sti til din database
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database.mdb")
' Åben databaseforbindelsen
Conn.Open DSN
strSQL = "Insert into Kontor (Fornavn, telefondato, telefonsub, telefonfelt, telefontid, telefonopret) values('" & Request.Form("Fornavn") & "','" & Request.Form("telefondato") & "','" & Request.Form("telefonsub") & "','" & Request.Form("telefonfelt") & "','" & Request.Form("telefontid") & "','" & Request.Form("telefonopret") & "')"
conn.execute(strSQL)
Alert = "Din ide er nu oprettet "
end if
%>
<center>
<form action="info.asp" method="post"><a href="default.asp" target='_self'><%=Alert%></a>
<TABLE width="500" bgcolor="#FFCC66" class="Formindhold">
<TR>
<TD bgcolor="#FFCC66"><center> <TABLE>
<TR>
<TD valign="top" bgcolor="#FFCC66" width="500"><FONT SIZE="1" COLOR="#FF0000"><b>Opret Ide <TABLE>
<TR>
<TD width="80"><FONT SIZE="1" COLOR="#000000">Oprettet af<td><select name="Fornavn" class="Formindhold">
<option value="" selected><FONT SIZE="1" COLOR="#000000">Vælg person</option>
<option value="Jesper">Jesper</option>
<option value="Peter ">Peter </option>
</select></td></TD> </TR>
<TD ><FONT SIZE="1" COLOR="#000000">Dato<td><input type="text" name="telefondato" class="Formindhold" size="30" value="<%
Response.Write "Den " & FormatDateTime(Now, vbLongDate)
Response.Write " kl. " & FormatDateTime(Now, vbShortTime)
%>">
</td></TD> </TR>
<TD ><FONT SIZE="1" COLOR="#000000">Emne <td><input type="text" name="telefonsub" class="Formindhold" size="72"></td></TD></TR>
<TD valign="top"><FONT SIZE="1" COLOR="#000000">Ide grundlag<td><textarea name="telefonfelt" rows="7" cols="50" class="Formindhold"></textarea></td></TD></TR>
<TD valign="top"><FONT SIZE="1" COLOR="#000000">For<td><textarea name="telefontid" rows="7" cols="50" class="Formindhold"></textarea></td></TD></TR>
<TD valign="top"><FONT SIZE="1" COLOR="#000000">Imod<td><textarea name="telefonopret" rows="7" cols="50" class="Formindhold"></textarea></td></TD>
</TR>
</TR>
</TABLE>
</TD>
</TR>
</TABLE>
<input type="submit" value="Gem" name="send" class="knap" >
</form>
