Help - Email a Report

I designed my Form and my Report to look the same, to be user friendly.



I've added an email button so when someone fills out the form they can send that report.



The problem is that ALL records of the report are sent and it's only text, no lines that separate the fields.



How do I send (email) the current record with all of the lines drawen in?



Thanks,

Dan

You have to replace the carriage returns chr(13) .



Replace( strText, vbCrLf, "<br>" ) '---for html

Replace( strText, vbCrLf, chr(13) ) '---for email



Try that. Thanks.