Excel vs Outlook macro

Paste it where? In a message?

Paste in a new message and the object section to.

Hi,

Try this code. It copies the value of cell A1 to the body of a new message and either displays it or sends it depending on what you want.


Let me know if this suits your needs,

Dan

Thank you Dan, Thats working, but I would like to know how to add someting in the Object field and the C.C. field by excel macro.

Thank in advance.

Claude

under the olmail.To put this
olMail.Cc = "andeveryonelse@everywhere.com"

it will send as Cc
This message was edited by Qroozn on 2002-05-30 18:16

Thanks, but what about the Object field, the title of my message ?

To:
C.c.:
Object: ??????????

Sorry, forget the last message. Because i use a french version of Office the thing i was looking for was Subject and it work in the macro.

Now How cant i add a attachement file in the macro.

Now How cant i add a attachement file in the macro

Click to expand...

You can add attachments. Use this line before you send it:-

olMail.Attachments.Add "C:Your folderYour File.xls"

HTH,
Dan

Hello all,

As a follow up to this question and a similar one here ( http://www.mrexcel.com/board/viewtopic.php?topic=10079&forum=2&3 ) here is something which may help you.

The original code I used above used 'late binding'. This is where the code creates objects without knowing in advance what they might be - such as the Outlook application itself and the message. You may notice that when I dimensioned the variables I declared them as Object -

Dim olApp As Object, olMail As Object

Now a better way of doing this is to use early binding. This is where you include the Outlook object library in your Excel project. You do this by clicking Tools, References in the VB Editor and choosing Microsoft Outlook Object Library. You can the dimension your variables like this:-

Dim olApp As Outlook.Application, olMail as Outlook.MailItem

This has several advantages:-

• The code will run quicker.
• Any errors can be picked up at design time by clicking Debug, Compile e.g. invalid constant names.
• Perhaps most importantly you can now list all the members of an Outlook object in the same way you can an Excel object. E.g. change the above code so that it includes references to the Outlook library and dimension the variables as above. Now when you hit the . of olMail. you will be presented with a dropdown list of all properties and methods of the MailItem object (there are loads) and you can do practically anything to a message that you could do if you were in Outlook itself. Also, the objects will all appear in the Object Browser.

I hope this is of some use. Please post if something's not clear.

Dan