xlDialogSendMail syntax (Excel ’97)

Topic

New Reply

Pinch and a punch, first of the month.

What’s the correct syntax for using the xlDialogSendMail command in Excel?

At the end of a macro I need to mail the workbook to two specific colleagues with a subject line. The subject on really needs to be the file name but to be able to have it as “ABC.xls @ Oct-2001” or “ABC.xls @ 0110″ (as in ‘yymm’) would be an extra bonus.

I have tried looking through Help and tried the following examples:

Application.Dialogs(xlDialogSendMail).Show Recipients:=”Marc”, Subject:=”ABC.xls @ 0110″

and

Application.Dialogs(xlDialogSendMail).Show
.Recipients = (“Marc”)
.Subject = (“ABC.xls @ 0110”)

Am I even getting close?

Reply | Quote

Replies

For a similar post in Excel recently see Here

Andrew C[

Reply | Quote

Thanks Andrew. I do try looking around a bit before I submit a post….honest.

Reply | Quote