I am trying to think of a way to enable different excel workbooks to be emailed out to different people.
Here is an example of the background:
i have 20 excel workbooks,
these will be generated every month, and the end result is for them to be emailed to the corresponding people.
the names of the workbooks will always be the same each month.
so Workbook1, Workbook2, Workbook3.... so on...
I would like for Workbook1 to email to email@example.com
and Workbook2 to email to firstname.lastname@example.org and so on..
i'm not sure what is the best approach to this, i use SSIS so i'm wondering is there some way to set this up there.
Or would it be possible to use a macro to do this.
has anyone done this before, and if so have you some sample code i could look at to see if i can generate this process?