Email code that has different cell values for message body

[gassiusmax]

Hi All,

Wonder if it's possible? I have code that generates multiple emails based on a table, but I am trying to modify the code so that the message body shows the contents of particular column on different lines for each associated email address

So the message body would look like the below

Dan Hardy (Column B),

Line of customisable text within code

Sunday 22 Nov 2015 - OFF (Column D)
Monday 23 Nov 2015 - IN (Column E)
Tuesday 24 Nov 2015 - IN (Column F)
Wednesday 25 Nov 2015 - IN (Column G)
Thursday 26 Nov 2015 - IN (Column H)
Friday 27 Nov 2015 - IN (Column I)
Saturday 28 Nov 2015 - IN (Column J)

Line of customisable text within code

the code I have is below

Please Login or Register  to view this content.

I have attached the file as well if it makes it easier to understand, it may well be a simple solution but the ones that I am trying are just creating blank emails

Thanks in Advance

Danny

[karedog]

Maybe :

Please Login or Register  to view this content.

[gassiusmax]

Hi,

Thats brilliant it works for the cell look up but I can not seem to add custom lines of text using sMsgBody, I have highlighted below where I am trying to put it

Please Login or Register  to view this content.

Thanks Again

[karedog]

Like this, perhaps ?

Please Login or Register  to view this content.

[gassiusmax]

Brilliant Thank You I had it above Next I not below.

This code is an adpation but out of the 32 emails it could produce it only produces 18 is there a reason why

[karedog]

You are welcome.

I tried to replicate the data down, and it is working well (more than one hundred).

The code processess each cell in Range("C3:C102") which is not blank or zero, does your data meet this conditions ?