I have a table called contacts for 3 different companies there is a tick of who I would like to send an e.mail to for each company with the report attached from the report dropdown box depending whos company is named in the issue list form . at this time it is API capacitors . previously this database was for one company and I just put the names on the macro . now its 3 companies I have no ide how to tackle it thank steve