Copy from Excel to Outlook as HTML

Originally Posted by event21

Hi -

    With outlookMail
        .to="theemailaddress"
        .htmlBody = htmlBody
        .attachments.Add ThisWorkbook.Path & "\" & oneSheet.Name & ".xlsx"
        .Display
    End With

Regards,
Event

This code will work if the email address is same for all the sheets. But in my case I need to send the mails to different addresses