Follow via:
RSS
Email Alert
Question
0 Votes
+ -

I want to make a tracking sheet where on selected date excel send mail

I wanted to have a macro code by which from an excel sheet on specified date a mail should generate and send to the assigned email address through outlook
Tags: programming
31st Dec 2009

Answers (1)

0 Votes
+ -
Scheduling
See here for info on sending mail from excel;

http://msdn.microsoft.com/en-us/library/aa203718%28office.11%29.aspx

As for sending mail at a predetermined date/time you'd need to use an external scheduler and logic to interact with the spreadsheet which suggests that excel is not the tool for the job..
1st Jan 2010
Answer the question
Formatting +
BB Codes - Note: HTML is not supported in forums
  • [b] Bold [/b]
  • [i] Italic [/i]
  • [u] Underline [/u]
  • [s] Strikethrough [/s]
  • [q] "Quote" [/q]
  • [ol][*] 1. Ordered List [/ol]
  • [ul][*] · Unordered List [/ul]
  • [pre] Preformat [/pre]
  • [quote] "Blockquote" [/quote]

Join the TechRepublic Community and join the conversation! Signing-up is free and quick, Do it now, we want to hear your opinion.