Want to attach certain tabs of a spreadsheet to certain emails

  • Thread starter Jackie at MCard
  • Start date
J

Jackie at MCard

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

Klatuu

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

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

Email selected tabs of spreadsheet? 4
Can I attach my sub-form to the tabs I just added? 6
Attach Excel Template to Existing Spreadsheet 1
Joining only certain columns to a spreadsheet. 1
Yet another cheap PSU failed! Anatomy of a cheap PSU... 6
attach pictures to emails 4
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
ATTACHING ITEMS FROM OUTLOOK CALENDAR TO CERTAIN SPREADSHEET RECOR 1

Top