VBA DDE commands to Outlook

[jimgrin]

I am trying to automate the mailing of some Excel spreadsheets from some existing VBA code within Excel. I have had a look at the help for DDE commands and can see how this works for Word etc. but can you get this to work for Outlook?
What do you put in the "topic" string of the DDEinitiate command, as below from the help?

expression.DDEInitiate(App, Topic)

For Word, Excel this is the filename that you want to open.

Any help much appreciated,
JimG

 

[bondm007]

Unfortunately DDE does not work for Outlook 97, I am not sure about 98,2K,XP though? Maybe check the Microsoft Knowledgebase

http://support.microsoft.com