Syntax for emailing one worksheet

[Lisab]

I know how to automate access to send outlook emails.

However, I would like to know the syntax for sending 1 excel worksheet. I
thought that maybe the SendObject method would work but I only saw excel as
one of the output options; not a source option.

I have an excel file that has multiple worksheets. Each worksheet has a
unique name. We want to be able to use access automation to send individual
worksheets to different people. Sending the whole excel file as an
attachment is not acceptable because an indivudual should only be allowed to
see the sheet with their info.

any help would be greatly appreciated

Thank you