+ Reply to Thread
Results 1 to 4 of 4

Send an email on the first of every month

  1. #1
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Send an email on the first of every month

    In outlook, I recognize the developer tab and I assume it's not like VBA.

    I have tasks that I do in outlook like for example

    Scheduling an e-mail to be sent out on the 1st of every month.

    Can i record that and run it?

    Any good source where I can find macro templates for outlook?

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2404
    Posts
    24,757

    Re: Outlook Macros Inquiry

    The developer tab is for VBA--Outlook supports a full VBA object model, just like the other Office applications. However, for reasons that I have never seen sufficiently explained, Outlook does not offer a macro recorder. There are books and web sites available that discuss Outlook VBA solutions. We also have an Outlook VBA forum, and so I have moved your question. Unfortunately your problem turns out to be a little more complicated than it sounds I in a few minutes of searching I have been unable to find a solution that doesn't involve third-party apps or plug-ins. Perhaps someone else here can contribute.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-27-2006
    Posts
    136

    Re: Send an email on the first of every month

    This is an example of how it could be done.

    http://www.vboffice.net/sample.html?...0&cmd=showitem

    Create a Task with a unique subject with a reminder. (An appointment can generate a reminder but you will have to revise the code.)

    You can set the recurrence manually rather than doing so in the code.

    Please Login or Register  to view this content.
    More here http://www.slipstick.com/developer/s...minders-fires/. Describes how to use a template.

    With the BeforeReminderShow event you can cancel so you do not display the reminder. http://www.jpsoftwaretech.com/outloo...vent-handling/
    To mark "Solved" go to Thread Tools.

  4. #4
    Forum Contributor
    Join Date
    03-14-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    491

    Re: Outlook Macros Inquiry

    Quote Originally Posted by 6StringJazzer View Post
    The developer tab is for VBA--Outlook supports a full VBA object model, just like the other Office applications. However, for reasons that I have never seen sufficiently explained, Outlook does not offer a macro recorder. There are books and web sites available that discuss Outlook VBA solutions. We also have an Outlook VBA forum, and so I have moved your question. Unfortunately your problem turns out to be a little more complicated than it sounds I in a few minutes of searching I have been unable to find a solution that doesn't involve third-party apps or plug-ins. Perhaps someone else here can contribute.
    Thanks Jeff, I was going to route my question but there's like only 4 people viewing that thread at the time hahaha

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Automatic send an email at the specific date of the month
    By thuydo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-18-2013, 02:26 AM
  2. code to send an email from outlook on last working day of a month
    By Shanthuday in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2013, 11:23 AM
  3. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  4. Send an auto email if the expiry date is 1 month away
    By jy7788 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-24-2013, 11:29 AM
  5. send same email once a month
    By mania112 in forum Outlook Formatting & Functions
    Replies: 0
    Last Post: 10-27-2009, 11:37 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1