table not showing in email body

Hi

Please see attached w/book

At the moment when the workbook is opened the first time in the day emails are auto sent for any overdue items (all good)

1) there is a column with lead times in each sheet that should send a warning email when the lead time number of days
is reached( this sends the email but does not populate the table)?

Question how can i amend the code to either make the lead time populate the summary sheet or remove the lead time option

2) Also i have copied the template sheet over to add more shhets but the email table dont populate.

How should i be copying new sheets over?

Thank you in advance for help

Peter

Renton






http://www.ozgrid.com/forum/member.php?u=230186