Want to attach certain tabs of a spreadsheet to certain emails

  • Thread starter Thread starter Jackie at MCard
  • Start date 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?
 
In the Range argument of the TransferSpreadsheet method, put the name of the
sheet.
 
You must log in or register to reply here.

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
Attaching Chart to Email? 4
Joining only certain columns to a spreadsheet. 1
Outlook How to create hyperlink with specific page of the pdf attachment in Outlook 2
Excel If a Cell Contains a Certain Text (From Another Table) 0
ATTACHING ITEMS FROM OUTLOOK CALENDAR TO CERTAIN SPREADSHEET RECOR 1
Problems emailing attachment from Excel 3
Using "mailto" hyperlink to email the workbook as an attachment 1

Back
Top