Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Emailing Invoices with CF 5 Question for GJ
- Thread starter scottd431
- Start date
If you use CFMAILPARAM, it is nested within a CFMAIL tag. You can use more than one CFMAILPARAM tags within a CFMAIL tag in order to attach one or more files and headers.
Syntax:
<CFMAIL
TO="recipient"
SUBJECT="msg_subject"
FROM="sender"
...more attibutes...>
<CFMAILPARAM
FILE="file-name">
or
<CFMAILPARAM
NAME="header-name"
VALUE="header-value">
...
</CFMAIL>
FILE
Required if you do not specify the NAME attribute. Attaches the specified file to the message. This attribute is mutually exclusive with the NAME attribute.
NAME
Required if you do not specify the FILE attribute. Specifies the name of the header. Header names are case insensitive. This attribute is mutually exclusive with the FILE attribute.
VALUE
Optional. Indicates the value of the header.
Sylvano
dsylvano@hotmail.com
Syntax:
<CFMAIL
TO="recipient"
SUBJECT="msg_subject"
FROM="sender"
...more attibutes...>
<CFMAILPARAM
FILE="file-name">
or
<CFMAILPARAM
NAME="header-name"
VALUE="header-value">
...
</CFMAIL>
FILE
Required if you do not specify the NAME attribute. Attaches the specified file to the message. This attribute is mutually exclusive with the NAME attribute.
NAME
Required if you do not specify the FILE attribute. Specifies the name of the header. Header names are case insensitive. This attribute is mutually exclusive with the FILE attribute.
VALUE
Optional. Indicates the value of the header.
Sylvano
dsylvano@hotmail.com
Hey Scott,
To do what you asked about earlier, I would have your clients set up in a table with a record for each client having their e-mail address and the name of the file to attach.
You can then do a query like this:
<cfquery name="q1" datasource="myDS">
select * from clientTable
</cfquery>
You can then just use the cfmail tag like this to send an e-mail and attach their file.
<cfmail
query="q1"
mimeattach=#q1.clientFile#
to=#q1.clientEmail#
from="billing@ourdomain.com"
subject="Your invoice"
>Here is your invoice......
</cfmail>
If you needed to attach more than one file, I would use the <cfmailparam> tags as Sylvano suggests.
Hope this helps,
GJ
To do what you asked about earlier, I would have your clients set up in a table with a record for each client having their e-mail address and the name of the file to attach.
You can then do a query like this:
<cfquery name="q1" datasource="myDS">
select * from clientTable
</cfquery>
You can then just use the cfmail tag like this to send an e-mail and attach their file.
<cfmail
query="q1"
mimeattach=#q1.clientFile#
to=#q1.clientEmail#
from="billing@ourdomain.com"
subject="Your invoice"
>Here is your invoice......
</cfmail>
If you needed to attach more than one file, I would use the <cfmailparam> tags as Sylvano suggests.
Hope this helps,
GJ
- Status