Send Email With Multiple Tables In Body Dynamic Ranges with if Statements

Dear Everyone,

I am new to VBA and I would like to kindly ask you how to do the following coding: I want to say if the value on a specific cell is numeric error thus #NUM! then, I want to attach two specific tables as body on an outlook mail otherwise send a message "no changes". I do not need the full code for attachments etc. cause I have already written it. I only need a code for the if cell a1 is numeric error then attach the following dynamic range.

Thanks in Advance!!!

to check if a cell has an error in it, more than likely this will work:

Please Login or Register  to view this content.

it also depends on how you want to attach the tables. you can manually copy and paste them into the email yourself and see what happens. that is different than, say, using the HTML language to display the data properly. outlook mail items have an HTMLbody property that has a purpose of taking in HTML code and showing it to a recipient as if they were looking at it on a webpage itself. so, for instance, if you wanted to display excel table (specified range) as an actual table inside an outlook mail item, it would be something like this (without all the spaces):

Please Login or Register  to view this content.

that code can also be consolidate using other VBA methods more than likely.

Indeed I am using the HTML property but I cannot paste my code here because it says that it includes outlook coding which is not accepted. Thank you for your feedback though!

post it on a could drive and them post the link here. furthermore, you can get around the security here like I did (placing spaces in code), but the admins probably don't like that.

or, put the code in a text file and attach that. many ways....

Thank you. I attached again both the excel and the text file. Could you please help me? If there is no change in the dates before and after for the three different cases then the client, date before and date after will be denoted as : #NUM! which is alright! However, if there is no change I want to include an if formula in vba which will say something like the following multiple if formula: if cell c5, f5, i5 = #NUM! then I want in the body mail a message only saying : "There were no changes in delivery dates", otherwise if only one of these cells is = #NUM! then display in the body mail only the tables for the other two cases i.e. the client, the date before, and the date after.
Thanks in advance,

well, first of all, the output as it was for me, with regard to HTMLbody, was, as in the attached file:

I don't know if that's what you intended or not? furthermore, to add what you desire to that, I would guess you would just need this:

Please Login or Register  to view this content.

now, I've done most of the work for you. you can surely do the rest.

Thank you so much for you time and consideration. All the best!

I'm going to assume that you solved the issue then. if so, glad to help. =)