Football League Predictions Email Reminder

[keawyed]

Is it possible for an email reminder to be sent out a couple of days before games to all competitors in my Fantasy League through Excel?

I have been browsing this site and it appears that I may have to do it via Outlook.

Can anyone confirm or advise?

Thanks in advance

[Richard Buttrey]

Hi

The following is a posting I made on another forum a while ago. The only modification you'll need to make is to set up a string variable to hold the email address, then with a Do..Loop update the variable with each name in turn and use the variable in the .To instruction. i.e.

Please Login or Register  to view this content.

Then just have a macro that reacts to a Timer command which is set two days before your matches. Comment out the .Attach instruction if you don't need to attach a workbook

...original email
If people are using MS Outlook as the email client then the following should work. Add the following VBA macro to the workbook and link it to whatever button/logo/icon you want to use.

Please Login or Register  to view this content.

HTH