Results 1 to 12 of 12
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Automatic e-mail (2000 SR1)

    Can anyone help please. I have an Excel spreadsheet that I need to send via the internet on a daily basis. Assuming that Outlook is running on the desktop and the .xls is available on the hard disc, can this be done automatically without user intervention, assuming that the connection to the ISP needs to be dialled as well?

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    yes - start here
    <A target="_blank" HREF=http://www.slipstick.com/dev/olforms/skedrpt.htm>http://www.slipstick.com/dev/olforms/skedrpt.htm</A>

  3. #3
    New Lounger
    Join Date
    Jun 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    Excellent - looks good. Thanks very much. Gary

  4. #4
    New Lounger
    Join Date
    Jun 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    I have now managed to succesfully send a mail and attachment automatically with the scheduler, but only if I am connected to the internet. Otherwise the e-mail just sits in the outbox. How can I get the Dial UP Connection to connect as soon as a mail enters the outbox - including clicking on "connect" automatically. Any help will be appreciated

    I need to automate the process of connecting to my ISP if the dial up connection is not active at the time the scheduled item runs

  5. #5
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    are you using corp or IMO mode and are you set for send immediately?

  6. #6
    New Lounger
    Join Date
    Jun 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    IMO? I am in a stand alone PC situation with a dial up connection - i.e. I connect when I want to use the net. I cannot see any setting within O/L 2000 that allows for send immediately - meaning that nothing will appear to make Outlook dial the Internet provider automatically. Still looking for help please.

  7. #7
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    look in tools > options, maybe mail services tab? there should be a checkbox for send immediately.

    i'm pretty sure since you are using IMO that outlook will load long enough for the message to send. But it might not work since the dialer needs to connect first.

    however - you can set a second task in scheduler - run outlook. if outlook is set to check mail every xx minutes, it'll trigger DUN. I would set this task to happen a few minutes after the message task runs.

    scheduler can end tasks it opened - sometimes it messes up with outlook though and a WSH to close outlook properly is better.

  8. #8
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    BTW - look in help > about for your mode. internet mail only or corp/workgroup.

  9. #9
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    Shoot - I'm not with it today. If you couldn't find a send immediately option, it's very likely you are using Corp. My bad <img src=/S/sad.gif border=0 alt=sad width=15 height=15> Lex is gonna swat me with his tail. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    If you are in corp, you need to set the connection type to LAN. Unfortunately, DUN will never hang up after you are finished sending and recieving then. You'd need to use after xx minutes of no activity.

  10. #10
    New Lounger
    Join Date
    Jun 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    I have those days sometimes! The only option under Tools, Options, Mail Delivery is "Send messages immediately when connected". The only other one that could be of use would be "Automatically Dial wehn checking for new messages". So if I start Outlook and click on "Send/Recieve", my modem automatically dials the Internet provider, checks for new messages and if I have the "Hang up when finished sending, receiving or updating" box ticked, it will cut the phone connection.
    What I need is an automatic process that when me mail is created, the modem dials, connects, and the mail is sent. One way would be to enter a command in VB that is equivalent to clicking the "Send/Recieve" button but I cant find anything relating to that.
    Unless, of course you can think of any other way??

  11. #11
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    the best way is to use a WSH - windows scripting host - to handle the connection. you can set a delay in the script to allow the modem time to connect then have the script create the email. it's best if the connection is made before outlook loads - and if outlook is set for check every xx minutes - it'll want to do a mail pass while connected.

    i'll see if i can dig one up at the scripting host site on MSDN.

  12. #12
    New Lounger
    Join Date
    Jun 2005
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Automatic e-mail (2000 SR1)

    OK, thanks. I haven't used WSH but like a challenge! Will look out for your info.

Posting Permissions

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