Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic e-mail (Excel 97)

    I have a macro that thakes several files and breaks them down into the sheets applicable to a number of clients - creating separate files. Is there any way that I can then automate the e-mailing process - I have Outlook installed?

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Automatic e-mail (Excel 97)

    Hi,
    You should be able to do this fairly simply using the SendMail method - e.g.:
    activeworkbook.sendmail recipients:="Bill Gates"
    Hope that helps.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Oct 2001
    Location
    Suffolk, England
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (Excel 97)

    That was easy - thanks

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Automatic e-mail (Excel 97)

    Allison, you may also want to look into Application.Dialogs(xlDialogSendMail).Show

    This subject comes up occasionally and here are some old posts which may help you as they helped me: here, here.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Automatic e-mail (Excel 97)

    John

    How do you make the links in your message? I some times have a MSKB article that I want to tell the member about, and some other times it is just a thread that needs to be looked at, like in your reply.

    Thanks for your help.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  6. #6
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (Excel 97)

    Wassim,

    John doesn't seem to be around right now, so I'll answer for him.

    a) [ url=YourLinkHere]this thread[/url] - but leave out the spaces between [ and url=
    [img]/forums/images/smilies/cool.gif[/img] take a look at the help files - section 19

    HTH
    Brooke

  7. #7
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Automatic e-mail (Excel 97)

    Brooke

    Thanks for your reply, so if I enclose it between [ and ] then the messageing software knows that this is a URL and it will make it into a link, but then I guess in terms of threads you would need to know about them, and then add their URLs as before.

    Mkes sense.

    Thanks a lot

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Automatic e-mail (Excel 97)

    Wassim, I use the One-click tag Panel; it is the 2nd URL icon (globe and chain + the number 2). As Brooke says, you still have to manually insert the URL and desired descriptive text, so I often run a search for the threads I want to refer to (or other URL from Google or Favorites), capture the URL's to notepad if there's more than one, then create the post using cut-&-paste.

    We expect to see lots of these from you in the future! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Sorry for the delay, I have been in "meeting purgatory" today.
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (Excel 97)

    Allison,

    Try this XL file. I have been using it for over a year and it works with Outlook 98.

    John
    Attached Files Attached Files

Posting Permissions

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