View Full Version : Copy Matching Data to Email

02-12-2015, 07:42 AM
Hello All

I am working on a VBA code which searches data matching a criteria and copy data from Excel to a new email and sends email to user. I tried running a loop but it does not works. Also, I am not sure how to make it in tabular format. Can someone give me some idea how can this be achieved. The data looks something like this:

Store Name Tool Type
ABC Jack Hammer Hardware
XYZ Holly Plier Hardware
LMN Stuart Hammer Hardware
XYZ Holly Nail Hardware
XYZ Holly Screw Hardware.....

So here what it does would be compose emails. Like Jack would be sent email with his data in tabular format. Then it would compose email for Holly and put his data and so on.
I am done with all other parts of the program except putting individual data in email.

Thanks in advance.