1 Attachment(s)
email sections of worksheet to different email addresses
I have a workbook which contains a sheet with a dept number column and a sheet with dept #s and email addresses. I need code to create an email for each department which contains only that department's data. i've attached a sample workbook. so, for rows containining department 606 or 607, i'd need an email to go to pam.white@lpnt.net (one email to pam white for dept 606 data and a separate email to pam white for 607 data). for 608, email pdeshazier@yahoo.com. thanks in advance for any assistance!! :hi:
email sections of worksheet to different email addresses
thanks for responding. The subject will likely be populated from the file name OR file name with "yesterday's" date concatenated.
The body - i had planned on it being the data on each row. Our controller is concerned about outputting data in excel for fear of it being changed, though i've tried convincing her we can protect it so that it can't be modified. the only thing i'm unsure of there is whether they can make a copy of a protected workbook, save it and then modify the copy. if not, i favor sending in excel rather than .pdf (which is the direction my controller was going bc pdf cant' be modified). so.... currently, going with controller's preference, attached .pdf file. however, as long as whatever we DO send cannot be modified, i feel our CFO will be okay with any of these solutions.
Quote:
Originally Posted by
Kenneth Hobs
What is the subject? What is the body? IF the data is not in the body, would data be an Excel file attachment with just with their data? IF the data is not in the body, would data be a PDF file attachment with just with their data?