CFMail

[monoone]

I have added content into a database. In the action page I am trying to 1. add the content into the db (this works fine) 2. Send an automatic email telling the administer what has been added to the database.

I get no errors, but the email portion is not working:

Here is my SQL and CFM code:

------------Code---------------------

<CFIF IsDefined(&quot;FORM.sumbit_mailer&quot>
<CFMAIL TO=&quot;pread@heine.com, eott@heine.com&quot; FROM=&quot;Administrator@heine.com&quot; SUBJECT=&quot;Process Loaner&quot;>
On #Form.InputDate#
<br>
NOTES:<br>
<br>
#Form.LoanNotes#
</CFMAIL>

<CFQUERY NAME=&quot;addLoaner&quot; DATASOURCE=&quot;Loaner&quot; DBTYPE=&quot;ODBC&quot;>
INSERT INTO Loaner
(InputDate,
QtyOnHand,
LocationID,
ManID,
ProdID,
LoanType,
LoanNotes)

VALUES
(#CreateODBCDate(NOW())#,
#QtyOnHand#,
#LocationID#,
#ManID#,
#ProdID#,
'#LoanType#',
'#LoanNotes#')
</CFQUERY>
</CFIF>
----------------End Code---------------

Thanks for the help,

Eric

 

[vamsialuru]

check whether ur mail server has denied outgoing mails. if that is ok, then check the log, see what message it is giving, u can see the log under cfusion directoru. mail.log file. if u want to see the undeliver mails, u can see that under cfusion\mail\undeliver directory. also if u have spaces in ur from mail id, cfmail won't send that outside.

 

[monoone]

Hi,

I checked it and there is a message:
&quot;Unable to connect to mail server&quot;

What does this mean?

Eric

 

[neofactor]

Two things:

1) Is the server up and working?
mail.heine.com server (12.30.55.217)
My pings time out to it.

2) Check if your CF server's IP address is allowed to send email through the mail server (relay agent).

One of these is the problem.

If the mail server is up... try addind server into the CFMAIL command ... bypassing the one set in the CF administrator. You might try putting the IP address to rule out DNS.


David McIntosh

http://www.neofactor.com

 

[monoone]

Hello,

Itried all of these and noting worked.

Any other Ideas.