Hey guys!
I’m currently using a form which sends a HTML email to the recipient - very basic.
The recipient now asked me if we can also send it as an Excel sheet attached in the E-mail.
I’ve tried implementing both PHPExcel and Spreadsheet_Excel_Writer but I just can’t get it to work, which is really frustrating.
Anyone who could give me a helping hand?
Here’s my code.
Thank you so much in advance!!
kontoansokan.php
[php]<?php
require(‘client.inc.php’);
require(CLIENTINC_DIR.‘header.inc.php’);
?>
Datum/tid | <? date_default_timezone_set('Europe/Stockholm'); ?> kl.<?php echo date("H:i") . ""?>"> |
Handläggare * | |
Företagsuppgifter | |
Organisationsnr | |
Företagsnamn | |
Tillhör koncern/kommun | |
Telefonnummer | Fax |
Kontaktperson | |
Namn | |
Mailadress | |
Faktureringsadress | |
Företagsnamn/enhet |
|
Postadress | |
Postnummer | |
Ort | |
Leveransadress | |
Företagsnamn/enhet |
|
Gatuadress | |
Postnummer | |
Ort | |
Eventuell kommentar till kundregistret | |
Inloggning till Netshop |
Ja |
kontoansokan_skicka.php
[php]<?php
if(isset($_POST[‘email’])) {
// EDIT THE 2 LINES BELOW AS REQUIRED
$email_to = "[email protected]";
$mailkopia = "[email protected]";
$email_from = "[email protected]";
$email_subject = "Email Subject";
function died($error) {
// your error code can go here
echo "We are very sorry, but there were error(s) found with the form you submitted. ";
echo "These errors appear below.<br /><br />";
echo $error."<br /><br />";
echo "Please go back and fix these errors.<br /><br />";
die();
}
// validation expected data exists
// if(!isset($_POST[‘first_name’])) {
// died(‘We are sorry, but there appears to be a problem with the form you submitted.’);
// }
$first_name = $_POST['first_name']; // required
$datum = $_POST['datum'];
$orgnr = $_POST['orgnr'];
$foretagsnamn = $_POST['foretagsnamn'];
$koncern = $_POST['koncern'];
$telephone = $_POST['telephone'];
$fax = $_POST['fax'];
$kundnamn = $_POST['kundnamn'];
$email = $_POST['email'];
$fakt_foretag1 = $_POST['fakt_foretag1'];
$fakt_foretag2 = $_POST['fakt_foretag2'];
$fakt_foretag3 = $_POST['fakt_foretag3'];
$fakt_postadr = $_POST['fakt_postadr'];
$fakt_postnr = $_POST['fakt_postnr'];
$fakt_ort = $_POST['fakt_ort'];
$lev_foretag1 = $_POST['lev_foretag1'];
$lev_foretag2 = $_POST['lev_foretag2'];
$lev_foretag3 = $_POST['lev_foretag3'];
$lev_gatuadr = $_POST['lev_gatuadr'];
$lev_postnr = $_POST['lev_postnr'];
$lev_ort = $_POST['lev_ort'];
$comments = $_POST['comments'];
$inlogg = $_POST['inlogg'];
$error_message = "";
// $string_exp = “/^[A-Za-z .’-]+$/”;
// if(!preg_match($string_exp,$first_name)) {
// $error_message .= ‘The First Name you entered does not appear to be valid.
’;
// }
if(strlen($error_message) > 0) {
died($error_message);
}
$email_message = “”;
function clean_string($string) {
$bad = array("content-type","bcc:","to:","cc:","href");
return str_replace($bad,"",$string);
}
$email_message .= "<img src='http://webbhjalpen.com/kund/frontline/images/frontline.png'><br><br>";
$email_message .= "<font face='Calibri'>Hej!<br>Ni har fått en kontoansökan från kundtjänst.<br>Se nedan uppgifter.<br><br></td></tr>";
$email_message .= "<table>";
$email_message .= "<tr><td width='200'><font face='Calibri'>Handläggare:</td><td><font face='Calibri'>".clean_string($first_name)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Datum/tid:</td><td><font face='Calibri'>".clean_string($datum)."</td></tr>";
$email_message .= “
$email_message .= “
$email_message .= “
$email_message .= “
$email_message .= “
$email_message .= “
$email_message .= “
$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";
$email_message .= "<tr><td><font face='Calibri'><b>Kontaktperson</td><td></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Namn:</td><td><font face='Calibri'>".clean_string($kundnamn)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Mailadress:</td><td><font face='Calibri'>".clean_string($email)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";
$email_message .= "<tr><td><font face='Calibri'><b>Faktureringsadress</td><td></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Företagsnamn/enhet:</td><td><font face='Calibri'>".clean_string($fakt_foretag1)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 2:</td><td><font face='Calibri'>".clean_string($fakt_foretag2)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 3:</td><td><font face='Calibri'>".clean_string($fakt_foretag3)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Postadress:</td><td><font face='Calibri'>".clean_string($fakt_postadr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Postnummer:</td><td><font face='Calibri'>".clean_string($fakt_postnr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Ort:</td><td><font face='Calibri'>".clean_string($fakt_ort)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";
$email_message .= "<tr><td><font face='Calibri'><b>Leveransadress</td><td></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Företagsnamn/enhet:</td><td><font face='Calibri'>".clean_string($lev_foretag1)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 2:</td><td><font face='Calibri'>".clean_string($lev_foretag2)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Rad 3:</td><td><font face='Calibri'>".clean_string($lev_foretag3)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Gatuadress:</td><td><font face='Calibri'>".clean_string($lev_gatuadr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Postnummer:</td><td><font face='Calibri'>".clean_string($lev_postnr)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Ort:</td><td><font face='Calibri'>".clean_string($lev_ort)."</td></tr>";
$email_message .= "<tr><td><font face='Calibri'></td><td height='10'></td></tr>";
$email_message .= "<tr><td><font face='Calibri'>Inloggning til Netshop</td><td><font face='Calibri'>".clean_string($inlogg)."</td></tr>";
$email_message .= "<tr><td valign='top'><font face='Calibri'>Ev. kommentar:</td><td valign='top'><font face='Calibri'>".clean_string($comments)."</td></tr>";
$email_message .= "</table>";
// create email headers
$headers = 'From: '.$email_from."\r\n".
‘MIME-Version: 1.0’ . “\r\n” .
'Reply-To: '.$email_from."\r\n" .
'BCC: '.$mailkopia."\r\n" .
‘Content-type: text/html; charset=UTF-8’ . “\r\n”;
‘X-Mailer: PHP/’ . phpversion();
@mail($email_to, $email_subject, $email_message, $headers);
?>
Din förfrågan är nu skickad till kundregistret via mail.