Pasting cells into the body of an e-mail returning blank cells

Hi all,

So I'm trying to send e-mails to multiple people. The details of each recipient are held on a single row - the e-mail address, their name and the range of cells that I want to paste. I've built a formula which should send an e-mail for all the rows on the spreadsheet.

My problem is that it only pastes blank cells into the body of the e-mail.

The msgbox flags I've put in imply that the variables are changing correctly via the loop as well. Does anybody have any idea why this might be happening or what I could do to fix it?

Please Login or Register  to view this content.

Hi john,

Thanks for that - luckily, I already have a Function by RonDeBruin which accomplishes the pasting of the range (below, for the curious).

The issue is that when I use it in the context of my original post, it seems to be pasting blanks. I know that the function works normally, because I've tested it in a separate workbook - but it seems to be misfiring here.

Please Login or Register  to view this content.