I have used code from a couple different sources and have got it close but need a bit of help
to finish it up.
The code should create jpg images of the data and email one areas data to each recipient listed in
a column.
In the attached file I have two problems.
Email with Image Attachment To Each Recipient v2 - Copy.xls
1) When run, I get an Object variable or with variable not set error on the line:
If I uncommentPlease Login or Register to view this content.
the code will run however it leads to my second problem:Please Login or Register to view this content.
2) The code will create 5 emails for each recipient. Each recipient should only receive one email
for their area in the order their email is listed and in the order the area is listed
(e.g. email 1 to Area 1, email 2 to Area 2).
As always, thank you for your invaluable assistance.
Regards,
BigDawg15
Bookmarks