Adding Cell Values To .HTMLBody in Excel VBA

Hello,

I am having some real trouble referencing multiple cell values in the body of the email I need to send. I have a series of macros that run to trim down data and put it into a table format and paste it into an email. Everything is perfect, except getting the cell values adding into the text of the email to string along with my predetermined text. In the code below in the .htmlbody tag, I indicated which cell references I need. Can you please help?

Please Login or Register  to view this content.

Hi, try this:

During the interval, " & sheets("Macros").range("H4").value & " calls exceeded the Max Delay threshold of 300 seconds.

Thank you so much, that has worked perfectly! Now I have a new dilemma. One of the cells I am referencing in my VBA is a MIN or a MAX formula [=MIN(Res!A:A)]. This returns a time value in Military Time. The cell value is variable based on the results of another macro that runs. I need the contents of this cell to paste into the email function and not change the formatting. I think this is done with a format VBA code but I can't seem to get it right.

The line that needs the formatting wrap is : During the " & sheets("Macros").range("S28").value & " -" & sheets("Macros").range("S29").value & " interval (s), "

The S28 and S29 cell values appear as a military time stamp however the is resulting from the Min & Max functions.

The full .HTMLBody code is below

Please Login or Register  to view this content.

Thank you for your help!

Hi, how exactly does the value change when it is transferred into the email? The 'Range("X").Value' should only return a value of the cell and not change it.

Converting it to a decimal for some reason. Even when I formatted the cell to a time reference, it still did not work right. I converted the existing cell value to an =Time("A1", HH:mm) and it works perfect now. Something weird with the formatting I guess. Thanks for looking for me, I appreciate it!