+ Reply to Thread
Results 1 to 4 of 4

Auto Generate MS Outlook Email Message from Excel

  1. #1
    Registered User
    Join Date
    08-18-2008
    Location
    Manila
    MS-Off Ver
    Office 2003, Office 2007
    Posts
    26

    Auto Generate MS Outlook Email Message from Excel

    Hi Exceltip,

    First of all, my problem is not related solely to Excel.

    I maintain a book borrowing tracker in an excel file. I need to email the book usage summary everyday. Now, I need a Macro code (VBA or Excel Function Combinations) to generate the summary to another sheet.

    Basically, the summary table and the tracker table has the same columns and formats. From the tracker table, the summary table would display books only borrowed today (e.g. Sept-10) or borrowed date earlier than today, or loaned, (e.g. Sept-1) that is not yet returned or returned today (Sept-10). Summary table will not display books that are borrowed and returned earlier than today (e.g. Borrowed: Sept-9, Returned: Sept:-9).

    I will attach a sample file to clarify my inquiry.

    Next, if someone knows how to do it, I would like some help to make a template message for Outlook (a VBA Coded Message) so that whenever I open the template, it will get data from the summary table and will be ready for mailing.

    I know the last part is out of scope or maybe impossible but if we can find solution to it, I know it will greatly help, not only me, but also to other Microsoft Office users who sends reports daily.

    Cheers,
    Attached Files Attached Files

    __________
    LordMarcus

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Why not just use AutoFilter? It seems pointless to duplicate data.

    Ask the email question separately, although a search of the forum should provide code.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    08-18-2008
    Location
    Manila
    MS-Off Ver
    Office 2003, Office 2007
    Posts
    26
    Hi RoyUK,

    Thanks for the prompt reply.

    I'm reading the post of aravindhan_31.

    It looks promising.

    Cheers,

  4. #4
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Leith's email code is generally spot on, if that one doesn't work then search for more of his.

    You can check out Ron de Bruins website.

+ 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. excel macro for sending emails
    By aravindhan_31 in forum Excel Programming / VBA / Macros
    Replies: 21
    Last Post: 12-11-2009, 08:50 AM
  2. Microsoft Excel to Email
    By alextsg in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-29-2008, 02:09 AM
  3. Excel 2007/ Outlook 2007 mail Problem
    By Bostock in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2007, 04:26 PM
  4. Problem Sending embedded image via outlook 2003 from Excel 2003 vba
    By sy278 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-23-2007, 06:13 AM
  5. Putting Links in Email from Attached Excel File ?
    By nbaj2k in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2006, 02:07 PM

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