If I understand your question correctly, there's a logrotate option that will do what you want. Simply add
mail email@example.com as one of the configuration options, like this:
This will mail you the log files that are about to be rotated.
Perhaps you've tried this and it didn't quite do what you need. In that case, I think you're on the right track for the most part. However, invoking sendmail directly isn't the right approach when you're trying to send a message with attachments. To quote the sendmail FAQ:
How do I create attachments with sendmail?
You don't. Sendmail is a mail transfer agent (MTA). Creating e-mail messages, including adding attachments or signatures, is the function of a mail user agent (MUA). Some popular MUAs include mutt, elm, exmh, Netscape, Eudora and Pine. Some specialized packages (metamail, some Perl modules, etc.) can also be used to create messages with attachments.
If you have the mail user agent mutt (or can install it), it should be able to do what you want. Try something like this:
echo | mutt -s "Log files for `date`" firstname.lastname@example.org -a /var/log/httpd/*log
Note also in your example configuration file you're missing the
endscript for your