Help Needed Composing emails in Excel

[vba_monkey]

Hello,

I am trying to create a macro where Excel creates an email and attaches a document to be sent to insurance companies selected from a list. The user will select yes next to the name of the insurer that they want the document sent to.

This is what I have created so far but the issue I have is that if the user selects four different insurers, instead of creating four emails with the correct doc attached, it creates one email and attaches the document four times and inserts the body text four times. What am I doing wrong?

Please Login or Register  to view this content.

[6StringJazzer]

You are only creating an email once then referencing that same email for each insurer. Try this, although I have not tested it. If you provide your entire file I would be happy to test.

Please Login or Register  to view this content.

[vba_monkey]

Thanks 6StringJazzer. That works perfect.