excel, outlook, automation

i have a list of customers with contact names in one cell, email address in another cell, and required response date in another cell. i want to find out how to creat a form to grab that info from the excel sheet and then email to customers. usually a list of 20 - 50 everymonth. if there is a forum for this i have missed it.

Originally Posted by npgandlove

i have a list of customers with contact names in one cell, email address in another cell, and required response date in another cell. i want to find out how to creat a form to grab that info from the excel sheet and then email to customers. usually a list of 20 - 50 everymonth. if there is a forum for this i have missed it.

i actually found the answer to be really simple. i used mail merge in word to complete my task. it asked for the file and also asked for the info from the excel sheet i wanted to use.