Want to attach certain tabs of a spreadsheet to certain emails

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jackie at MCard - 07 Jan 2008 17:01 GMT

Long ago, when I attempted to attach a spreadsheet to an emai, Excel would
ask me if I wanted to attach the whole file or just a certain tab. I have
Excel 2002 version and I need to have that capability so that I don't have to
reinvent the wheel. My project involves sending an email to 5 different
executives who will each have their own tab of a spreadsheet attached to the
email. I want to avoid saving the spreadsheet five times and altering it
five times.

Does anyone know about this?

Reply to this Message

Klatuu - 07 Jan 2008 17:18 GMT

In the Range argument of the TransferSpreadsheet method, put the name of the
sheet.

Signature

Dave Hargis, Microsoft Access MVP

> Long ago, when I attempted to attach a spreadsheet to an emai, Excel would
> ask me if I wanted to attach the whole file or just a certain tab. I have
[quoted text clipped - 5 lines]
>
> Does anyone know about this?

Reply to this Message