xlDialogMailEditMailer

[FrankFischer]

Hi Folks

I am trying to send an Excel file with a variable name as an attachment.

The subject and file name will vary by day. The "To:" and "CC:" fields are constant.

I have most of the macro mechanics down, but need some assitance with the syntax on the mailer statement.

Any help would be most appreciated.

Thanks.
This message was edited by FrankFischer on 2002-12-13 18:24

 

[Hero-0952]

Hi Frank.

Check out this wonderful thread with a 'ton' of email info by Brian. This is good stuff.

http://www.mrexcel.com/board/viewtopic.php?topic=7311&forum=2

Regards,

ViperGTS