Varying range in Email function

**damage** · 05-03-2011, 04:13 PM

I have built a function from a worksheet that creates a personalized email based on data entered in other sheets.

I have a maximum 75 email addresses. The number of people to be mailed varies each time from 1-75. How do I look up and create on the correct number of emails based on how many have been selected? Below is the code I am using, but currently this creates 75 mails. Thanks

Please Login or Register  to view this content.

**Leith Ross** · 05-03-2011, 04:44 PM

Hello damage,

You can find the last cell in the column with data several ways. Here is one way to do it...

Please Login or Register  to view this content.

**damage** · 05-03-2011, 05:11 PM

Thanks, that seems to have worked to stop picking up the blanks, but has changed the format of the emails it has created. I think I have screwed up the code. Going to have a play with it and will be back, but thanks for getting me this far.

**Leith Ross** · 05-03-2011, 05:15 PM

Hello damage,

If you can not get it work, post the workbook. Be sure to disguise any personal information before posting it.

**damage** · 05-03-2011, 05:24 PM

I got it working now.

I do need to add a couple of extra functions to this macro.

1) a copy and paste of some date
2) cc another email address
3) add attachments

Can anyone help with these.