Hi
I have a request to send emails direct from Excel. The excel file can have between 10 to 50 sheets in it.
I'd like to generate the email on the Monday of every week.
Is it possible to have an email automatically generated, BUT only for one of the sheets in the file?
I can place an email address inside each sheet (and each sheet may have a different email recipient), but can it export that sheet only and not send the whole file?
Rather than upload a file, my example would be ONE file, with Sheets 1 to 10, a different email address in cell A1, and when the email sends, it sends "Sheet1 only" to the email for the recipient of Sheet 1 in A1.
Then Sheet 2 would go to the recipient in A1 of "Sheet 2" ..... and continuing until sheet 10 (or the last sheet as some files will have maybe 50 sheets).
Any ideas??
Bookmarks