Wonderfull article although it does not work for me :-(
I copied all the code to excel to make a workbook that sends out order emails when a stock gets below a threshold. It should take the orderform from an embedded word.doc but I get an runtime error 424 Object required.
In your last sub where the
‘ Now we have EmbeddedFileName, you can play this with something like Call sndPlaySound32(EmbeddedFileName, 0)