Send active workbook as attachment

  • Thread starter Thread starter OTTO
  • Start date Start date
O

OTTO

Hello,

I have a routine that creates a number of individual
workbooks that need to be sent to different recipients.
Ideally, I'd like to append some new code to the existing
that simply sends the open workbook to an e-mail address
in a worksheet cell somewhere in that open workbook --
this address will change based on a lookup embedded
elsewhere.

So again, send open workbook to a recipient whose name
appears in a certain cell... What do you all think?!

THANX
 
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

How to reference a cell from anther workbook without opening it 0
Open Office Outlook & Insert e-mail address 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
How do I send single worksheets in a workbook to different recipi. 1
Cell values to an array, then array transpose to another workbook 8
Copying cells and formula from closed workbook to all sheets in open workbook 0
vba to send multiple workbooks to different address 22
Excel 2007 Routing workbook to Outlook 1

Back
Top