Solved

macro to alter end user report is due

Posted on 2013-11-07
3
238 Views
Last Modified: 2013-11-07
Hi Experts

I need a macro that sends an email to the end user on working day 6 each month starting Dec 13 onwards and also repeats the process mid month based on the computer calender.

with simple message " staff leavers report
 Is due kindly complete and distribute"
0
Comment
Question by:route217
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
etech0 earned 500 total points
ID: 39630276
I don't know if excel is necessarily the right tool for this. Do you want any excel attachments in the email?

If not, you might want to take a look at Blat
http://lifehacker.com/168156/geek-to-live--automatically-email-yourself-file-backups
0
 

Author Comment

by:route217
ID: 39630300
Hi etec0

no attachment just notification only....
0
 
LVL 10

Expert Comment

by:etech0
ID: 39630315
So you might want to take a look at the link above.

Also,  I think there are online services that can do that. Here's an example: http://www.sendrecurring.com/
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes a serious pitfall that can happen when deleting shapes using VBA.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question