Send emails with worksheet attachment to multiple email addresses

[eMorgan]

I have worked out how to send an email from excel to a single person (with a specified email address stated in the VBA code). However, as I am creating a form which will require it to be sent to multiple email address (which can't be specified, as the required email addresses will vary). Therefore, if the user of the form was to put the email address in certain cells on the form ie. B20, B13 etc. then how could I make sure that the address entered in to the cells - will be the email address that the worksheet will be sent to. I don't need a macro to include subject lines or messages etc. just the worksheet to be emailed to them. The macro is in a 'submit' button, which I've already created - I just need to edit the VBA code.

[Excel Fox]

eMorgan, welcome to ExcelFox

Do you want to send individual emails or can the same mail be sent with multiple recipients

[eMorgan]

eMorgan, welcome to ExcelFox

Do you want to send individual emails or can the same mail be sent with multiple recipients

The same mail can be sent to multiple recipients, but the other recipients would need to be 'CC' in.