What is the Syntax to email one worksheet

L

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 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Syntax for emailing one worksheet 0
Combine multiple worksheets in one Workbook into one big worksheet 6
Converting excel to PDF, single page converts to multiple HELP! 1
Which MS Program to Use? 0
Import data from individual employee monthly location sheets to onedepartment monthly location sheet 14
Multiply with Vlookup value from another Worksheet 0
VBA Macro Training in Chennai 0
Automatic email to recipient 1

Top