How to email A file

  • Thread starter Thread starter Ussiddiqui
  • Start date Start date
U

Ussiddiqui

Hi can any buddy tell me that how to email an excel file using outloo
express or some other method
 
Activeworkbook.Sendmail is one method.

Snipped from the VBA Help File:

SendMail Method


Sends the workbook by using the installed mail system.

Syntax

expression.SendMail(Recipients, Subject, ReturnReceipt)

expression Required. An expression that returns a Workbook object.

Recipients Required Variant. Specifies the name of the recipient as text,
or as an array of text strings if there are multiple recipients. At least
one recipient must be specified, and all recipients are added as To
recipients.

Subject Optional Variant. Specifies the subject of the message. If this
argument is omitted, the document name is used.

ReturnReceipt Optional Variant. True to request a return receipt. False to
not request a return receipt. The default value is False.

HTH,
Geoff
 
In outlook , see the button that looks like a paperclip ?
Or use File / Send then choose as an attachment or just the sheet your looking
at.
 
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

Automatically Begin a new email 2
How to Export Gmail Emails to PST Format? 4
Which is the best MBOX Converter Tool different formats conversion? 4
How to Convert EML to PST? 2
How do I compare two sheets and output a report? 2
How to Restore Outlook Data Without .PST File? 8
How can I migrate MBOX to PST? 2
How can we convert OST to PDF file format? 1

Back
Top