Hello,
I am new in excel macros and will appreciate any help will be provided. I have created excel spreadsheet that sends emails to the list of recipients. It works perfectly fine and captures all the cells needed, but for some reason removes graphs and pictures. I do need graphs and gadgets to go with the email as well. I have attached the spreadsheet for the review. In advance thank you for your help.
Perhaps this resource will help ? UNTESTED
http://stackoverflow.com/questions/3...o-outlook-body
You could also approach this in a different method: Create a pdf file of the worksheet, save it, then have your code refer to that saved file as an attachment.
Please Login or Register to view this content.
Last edited by Logit; 02-24-2017 at 12:44 PM.
The first problem lies in the fact that Sh.UsedRange is not picking up the charts as part of the usedrange. However, even if that is expanded, it will still have issues since they won't get copied, but maybe logit's solution resolves that?
Last edited by Arkadi; 02-24-2017 at 12:54 PM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Thank you so much for the help.
I tried the micro Logit has provided but unfortunately didn't work for my project. This might work if I was sending the same page to all the recipients, with the same info on it. In my situation metrics will be different for each associate and each associate will only receive their own data. In addition data will be large and be changing every day.
Associate A,
Associate B,
Associate C...
Appropriate email addresses in column A
Thanks again
This will send an email with a specific attachment as listed on Sheet 1. You can change the Column references as needed.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks