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:...
Checking the format of an email address ShowChecking the format of an email address Using a filter Using regular expressions Implementation Here below you chould find sp techniques to determine if a variable contains a valid email address. Using a filter Using these type of...
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 Email Notifier ShowIt is frequent that you receive an e-mail which you do not want to download or to see on your POP3 account . Even if you use the unwanted mail function, the e-mail is downloaded. Email to Notify is the solution for this inconvenience. First of all,...
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...