Skipping blank cells in Email body

[bocaj315]

I am sending an email that has the following text in the body. If any of the cells A-J are blank, I want the Macro to skip whatever line of code has the blank cell.

Please Login or Register  to view this content.

[tehneXus]

Hi,

like this?

Please Login or Register  to view this content.

[bocaj315]

perfect. Thank you! I may have to start a new thread for this question, but I need to include a logo into the body as well. How would I do this?

[tehneXus]

Hi,

as I am not using Outlook I cannot test anything but this might help you getting started:
http://www.mrexcel.com/forum/excel-q...ml#post3392185

[bocaj315]

Is there a way to do exactly what you did before except with HTML format?