E-Mail Merge

[1chicken]

Looking to merge each line of detail from 8.5 or 9 report into an e-mail. Each line of detail will include an e-mail address, subject line, etc.

 

[dgillz]

Check out

http://www.chelseatech.co.nz

They have a UFL for emailng that works great.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[IdoMillet]

Have a look at Ken Hamady's list of 3rd-party tools at:

http://www.kenhamady.com/bookmarks.html

A User Function Library (UFL) solution, such as the Outlook or SMTP UFLs by Chelsea Technologies:

http://www.chelseatech.co.nz/ctprod.htm#SMTP

or my CUT Light:

http://www.milletsoftware.com/CUT_Light.htm

would require that you PREVIEW the report to invoke the e-mailing.

If you use the UFL approach, I suggest you create a parameter that allows you to control whether the relevant formulas would actually kick those e-mails. Otherwise, each Preview or Refresh would trigger the e-mails even when you don't want that to happen.

Another approach is to use a Report Manager tool such as my Visual CUT. This would allow you to schedule the processing and to construct the e-mail content by dragging & dropping fields/formulas from the report into the e-mail From/To/cc/bcc/Subject/Body options.

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com