Excel Template With Macro For Sending Mails And Attachment Through Outlook

[bandus]

Dear Excel Fox,

I started using this macro and made some modification but nothing significant. However unfortunately I cannot use it for sending for multiple e-mail addresses. I type the emails as the outlook requires (abc@def; ghi@jkl; etc) but it doesn't work. I checked and the addresses are copied into the right field in the right way, but the outlook doesn't recognize them as an e-mail address. This only occurs if I type more than one emails into the excel cell. If I click into the To or CC field in outlook and then click somewhere else or press the tab, the emails get recognized (and underlined) and the message could be sent.

Do you have any idea how could I skip this step which really slows down the distribution of e-mails?

Thanks in advance!