Is there a way to email a report based on a hierarchy or for the sites that we would have in a report. After running a report, we would like to email those results out to our sites, but only for the sites in the report.
Thanks
Annette Linden
TravelCenters of America
1 Answer
-
Posted on Jun 24, 2004 at 08:28 PM
Link your QUery in Sheet1, then in Sheet2 link a copy of the same Query, adding a Characteristic that shows e-mail addresses. Save you Workbook
Site1 - site1@twc.us
Site11 - site11@twc.us
Site12 - site12@twc.us
Site2 - site2@twc.us
Then in VBA loop on the column about e-mail addresses and use Method ActiveWorkbook.SendMail Recipient:= ...
Remember to hide Sheet2.
Hope it helps
GFV
Add comment
Add comment