Dear Chandoo,
I m Ayyappan, I know the basic Mail Merge but I want to do mail merge with multiple row data for example:
Name Date Day
Mr. A 02-03-2016 Half Day
Mr. A 03-03-2016 Full Day
Mr. B 02-03-2016 Half Day
Mr. B 03-03-2016 Full Day
Mr. B 04-03-2016 Full Day
Mr. B 05-03-2016 Half Day
Above...
Hi,
I m Ayyappan, I know the basic Mail Merge but I want to do mail merge with multiple row data for example:
Name Date of Absent Day
Mr. A 02-03-2016 Half Day
Mr. A 03-03-2016 Full Day
Mr. B 02-03-2016 Half Day
Mr. B 02-03-2016...
I m using excel sheet where data is to be filled by other people.
Column A to M
if A2 is filed with data then it should check B2:M2
and if any blank cells then display message and highlight on the blank cell
if A2 is blank then no message, no highlight
A B C D E F G H I J K L M
Employee...