Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    xlDialogSendMail syntax (Excel '97)

    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?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: xlDialogSendMail syntax (Excel '97)

    For a similar post in Excel recently see <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Cat=&Board=xl&Number=86896&page=1& view=collapsed&sb=5&o=0&vc=1#Post86896>Here</A>

    Andrew C[

  3. #3
    3 Star Lounger
    Join Date
    Aug 2001
    Location
    Darkest Kent, UK., Kent, England
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: xlDialogSendMail syntax (Excel '97)

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •