mass emailing of sheet region of a pivot to corresponding recipients (vba help needed)

[Tetonne]

Good evening to all,

is it possible from a pivot table to export for a given column (region), and for all rows of this pivot column the corresponding excel sheets (with the region number)


to send them by email with :
to one or more recipients found in a parameter (sheet 'sent to')

the recipient corresponds to the region

when I run the macro, the pivot is updated
for all lines from B4,
excel generates the data file (sheet) of the region name
and sends it by email (outlook) to the right person

with a small basic text (without literature)

Thanks a lot