Send a single worksheet via Outlook

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

Michael Lanier

I'm wanting to send a single worksheet via Outlook based on the
following parameters:

1. Upon entry of an email address in a merged cell to trigger the
event
2. Not to be resent unless the email address is deleted and reentered
in the cell
3. The worksheet is to be sent as an attachment

Thanks in advance.

Michael
 
Be aware that a worksheet cannot be sent as an attachment.

The sheet must be copied to a new workbook for attaching.

Ron's code or sendmail add-in looks after that step.


Gord Dibben MS Excel MVP
 

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

consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet 4
Sending e-mails from specific email address 2
Emailing Worksheet - adding muliple reciepients 3
Method to automate page numbers on single worksheet 1
Macro to Email specific fields in a worksheet 1
single user form with multiple worksheets 1
Controlling worksheet protection via VBA 0
Email worksheets via name on worksheet 4

Back
Top