Search : in
By :

Attach the activeworkbook to an email

Dany, on Nov 2, 2009 1:58:34 pm GMT 
 Report this message to moderators

Hello,
Could you please help me with a vb code to attach the activeworkbook (without saving it)to an email and write subject line and also the email text (email body) and send without the routing slips?

Please note that my system (excel 97) is not accepting the command "dim ol as outlook.application" or any other outlook commands.

I tried performing this task using

ActiveWorkbook.SendMail "person@wherever.com", "subject"

but I am not able to enter the email body in this code which is very important for me. Kindly help me with this.



Many thanks,

Dany

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Attach the activeworkbook to an email » in :
Unable to attach files Show Unable to attach files It may happen that when uploading files as attachment under Outlook Express, it takes a long time and finally do not send same to recipients. This may be due to high volume size of the file which however unable...
[Nokia N97] Configure your email Show[Nokia N97] Configure your email Yahoo Settings Hotmail Account Settings Configuring email for Nokia N97 Yahoo Settings Incoming e-mail: username: your email address password: your password Incoming mail server:...
Obtaining a disposable email address ShowKasmail Spambox Jetable mail Enterto spamless email Yopmail Firefox extension Obtaining a disposable email address A disposable email is an e-mail service enabling you to send and receive mail for a short period. This practice is...
Scan a file by email ShowScan a file by email You have a file, but no antivirus on hand for the scanner? Just send email with subject scan@virustotal.com "SCAN" Your file will be scanned by an antivirus quarantine different, and you receive the answer...
Download Bulk Email Sender ShowWith Bulk Email Sender you can send mass messages in html. You can use the original templates or create your own for re-use later. Advantage It is possible to import a list of addresses from a database, an Excel file, a text file or type all the...
Download Dynamic Email Validator ShowThis software checks and rehabilitates your mailing list. To do so, it checks each address and determines if the e-mail is valid. The program is connected directly to SMTP server contacts to check them without sending e-mail. Dynamic Email...
Structure of an email (Headers and bodies) ShowStructure of an email An email has three basic parts: The header, a set of lines containing information about the message's transportation, such as the sender's address, the recipient's address, or timestamps showing when the message was sent by...
Introduction to email ShowWhat is email? Electronic mail (also known as email or e-mail) is one of the most commonly used services on the Internet, allowing people to send messages to one or more recipients. Email was invented by Ray Tomlinson in 1972. Why use email? The...