Hi there,

I have a little situation. I am working on a form, basically, that grades people. Now, I got the form made, my outputs are ok. However, there is something I was my form to do, which I think is possible, but is a major road block for me.

Currently, my form does a POST in an Excel file, which is saved with the values that I want.

But I need this file to be send via email to recipient, CC to the user logged in and the part that I am confuse is to send the XLS file as attachment. Is that possible and if so, can someone guide me on how to get my outputted excel form in an attachment ready to send.

Thanks for your help.

Hi Moloch,
I've attached a zipped file for a formmail script. It will send out attachments to your email, a bcc, or cc email and include the attachment. I use it and it works great. You might want to try this easy solution.

By the way, how did you post the data into an excel file? I'd be very interested in how you did this.

Hope this helps,
DianeD

So you can create the XLS file and just need to know how to send it? I Google'd this:

http://pear.php.net/package/Mail_Mime
http://www.4wordsystems.com/php_mail_attachment.php

Thanks for the reply.

Yes, I already have the output created, I use the header feature to load my POST data from my form to display it in Excel, however, it prompt's the user to either save it to HD or open it.

header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition:filename=$agent-$userid.xls");

So basically, I am searching for something that might be able to send the newly created xls file, without having to save it on the server and simply mail it to the specified address .

thanks again, and in the mean time, I will check your post to see if I can do something with it.

cheers

Use Php mime email class or phpmailer class

Phpmailer: download from sourceforge.net
phpmime: download from phpclasses.org

Both the classes comes with complete documentation and examples.

Thank you all for your replies,

I've added more information to better help you or others to understand my situation. So here goes :-)


I am trying to create a grading sheet. Well, I've done it, it calculates and post my necesary information.

My problem is, I currently have setup to prompt the user to save or open the Excel .Xls file that it generates. However, I've been trying to search all over the place for my result, to send an email to a specific recipient with attached to output that it creates in Xls instead of saving the file.

In other words:

- fill out the form
- click submit
- then it sends email with the .xls file without prompting the user to save it or without storing it on the server(if possible)

I've tried to check out phpmail and the other links, however, I don't think will do the trick as I am not taking a file from the HD just the post data that's been converted to xls and send via email as attachment. If there is a way though with phpmail, can someone guide me on how to setup this particular feature.

if you want to see what it's currently doing, please visit http://moloch.ca/php/testing/form.html

Also, this is my code for the PHP file ( result.php ) if it may help:

Thanks for your help.
Brian

<?php
$agent = $_POST['agent'];
$salutation = $_POST['salutation'];
$transition = $_POST['transition'];
$loyalty = $_POST['loyalty'];
$solving = $_POST['solving'];
$rapport = $_POST['rapport'];
$footer = $_POST['footer'];
$resolution = $_POST['resolution'];
$userid = $_POST['userid'];
$lob = $_POST['lob'];
$internal = $_POST['internal'];
$procedures = $_POST['procedures'];
$spelling = $_POST['spelling'];
$grammar = $_POST['grammar'];
$punctuation = $_POST['punctuation'];
$msgcopier = $_POST['msgcopier'];
$bonus = $_POST['bonus'];
$today = date('d-M-y');
$notesq1 = $_POST['notesq1'];
$notesq2 = $_POST['notesq2'];
$notesq3 = $_POST['notesq3'];
$notesq4 = $_POST['notesq4'];
$notesq5 = $_POST['notesq5'];
$notesq6 = $_POST['notesq6'];
$notesq7 = $_POST['notesq7'];
$notesq8 = $_POST['notesq8'];
$notesq9 = $_POST['notesq9'];
$notesq10 = $_POST['notesq10'];
$notesq11 = $_POST['notesq11'];
$notesq12 = $_POST['notesq12'];

$total = $salutation + $transition + $loyalty + $solving + $rapport + $footer + $resolution + $internal + $procedures + $spelling + $grammar + $punctuation + $bonus ;


header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: filename=$agent-$userid.xls");



?>
<html>
<head><title>Grading Sheet Result</title>
</head>
<body>
<body>
<center>
<table border=1 width=1000>

<tr><td align=center bgcolor=blue colspan="4"><b><font color=yellow>CONTACT ASSESSMENT GRADING SHEET  RESULTS</font></b>
</td></tr>

<tr><td width=230><b>Name: </b></td><td width=150><?php echo $agent; ?></td>

<td width=120>
<b>Case</b>
</td>
<td><?php echo $userid; ?></td>
</td>

</tr>
<tr><td> Graded on </td><td><?php echo $today; ?></td>

<td>
<b>Business</b>
</td>
<td><?php echo $lob; ?></td>
</td>
</tr>

<tr height="50"><td align=top><b> Salutation (header): </b></td><td><b><center> <?php echo $salutation; ?></center></b></td>
<td colspan="2" align="top"> <div STYLE=" height: 50px; width:600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq1; ?></div>
</td>
</tr>

<tr height="50"><td><b> Transition: </b></td><td><b><center><?php echo $transition; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq2; ?></div>
</td>
</tr>

<tr height="50"><td><b> Loyalty close (footer): </b></td><td><b><center><?php echo $footer; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq3; ?></div>
</td>
</tr>

<tr height="50"><td><b> Delivery: </b></td><td><b><center><?php echo $delivery; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq4; ?></div>
</td>
</tr>		

<tr height="50"><td><b> Rapport Building:  </b></td><td><b><center><?php echo $rapport; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq5; ?></div>
</td>
</tr>		

<tr height="50"><td><b> Problem solving: </b></td><td><b><center><?php echo $solving; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq6; ?></div>
</td>
</tr>

<tr height="50"><td><b> One contact Resolution: </b></td><td><b><center><?php echo $resolution; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq7; ?></div>
</td>
</tr>

<tr height="50"><td><b> Internal policies and procedures: </b></td><td><b><center><?php echo $procedures; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq8; ?></div>
</td>
</tr>

<tr height="50"><td><b> Revenue (bonus points): </b></td><td><b><center><?php echo $bonus; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq9; ?></div>
</td>
</tr>

<tr height="50">
<td> <b>Spelling errors: </b></td><td><b><center><?php echo $spelling; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq10; ?></div>
</td>
</tr>

<tr height="50">
<td> <b>Grammar: </b></td><td><b><center><?php echo $grammar; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq11; ?></div>
</td>
</tr>

<tr height="50"><td><b> Punctuation: </b></td><td><b><center><?php echo $punctuation; ?></center></b></td>
<td colspan="2"> <div STYLE=" height: 50px; width: 600px; overflow: auto;">
<b>Notes:</b> <?php echo $notesq12; ?></div>
</td>
</tr>

<tr><td><b>Total: </b></td><td><b><center><font color="blue"><?php echo $total; ?></font> / 100</center></b></td>

</tr>

<tr>
<td colspan="4" witdh="1000">
<b>Copy of message:</b>  <?php echo $msgcopier; ?>
</td>

</tr>

</table>

</body></html>

<?php ?>

Did sbdy manage to do this. I too am trying to do a similar thing. I can generate teh excel file but I don't know how to attach it to email since it is not saved on the server.

so why don't you save it in the temp folder ?
and after mail send delete it

I was thinking of doing that but I don't know how to do that. ??? Can you tell me how ot do it?

a simple fopen,fwrite,fclose .... look those function on php.net

thx will do