Now it gets confusing to me :)
The email is the email notification?
Email notifications are sent by standard wp_mail. I don’t know mailchimp that well, I assume it doesn’t keep a history of outgoing email.
If you mean the email address that is entered with a guestbook entry, that is something else. That will not work by default I assume, it needs code to integrate this.