+ Reply to Thread
Results 1 to 7 of 7

Auto email from Excel

  1. #1
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Auto email from Excel

    Hi
    I have a request to send emails direct from Excel. The excel file can have between 10 to 50 sheets in it.

    I'd like to generate the email on the Monday of every week.

    Is it possible to have an email automatically generated, BUT only for one of the sheets in the file?
    I can place an email address inside each sheet (and each sheet may have a different email recipient), but can it export that sheet only and not send the whole file?

    Rather than upload a file, my example would be ONE file, with Sheets 1 to 10, a different email address in cell A1, and when the email sends, it sends "Sheet1 only" to the email for the recipient of Sheet 1 in A1.
    Then Sheet 2 would go to the recipient in A1 of "Sheet 2" ..... and continuing until sheet 10 (or the last sheet as some files will have maybe 50 sheets).

    Any ideas??
    Last edited by Christopherdj; 04-29-2015 at 09:40 PM.

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Auto email from Excel

    Can be possible.....
    Upload the sample workbook.....
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Auto email from Excel

    File uploaded, there is an instruction/request page for what I'm seeking.
    I found a macro that sends the email and also password to run the macro (for safety) passwword is "run" (without the "")
    Also included the site I got it from. Hope someone can help.

    HTML Code: 
    Attached Files Attached Files

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Auto email from Excel

    I'll know whether I can help you tomorrow
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  5. #5
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Auto email from Excel

    Well - it now runs try it and see whether the outlook, which I don't use, engages:


    *Uncomment the red to only run on Mondays

    The Format Code that Ron had used to work and that was the only thing I fixed


    Site won't let me post the code - but when I can - I will


    Try this:https://www.dropbox.com/s/90lfcu3j8s...orum.xlsm?dl=0
    Last edited by xladept; 05-01-2015 at 03:50 PM.

  6. #6
    Forum Contributor
    Join Date
    10-13-2011
    Location
    Australia
    MS-Off Ver
    Office 16
    Posts
    329

    Re: Auto email from Excel

    Got the file, I assume the
    *'If Weekday(Date............... is where I remove the '.

    Please Login or Register  to view this content.
    It generates in Outlook, now wondering if it is possible to have two codes (Macro's) but only password protect one?
    I need users to generate a different Macro in the file regularly.
    But this current code would be ideal if made invisible - or at worst, password protected.

    any thoughts?

  7. #7
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Auto email from Excel

    To the first question - yes, that's the one to remove.

    To the second question - you could have the code in a different workbook. I often give my clients a book with just the code as well as their processed spreadsheets.:|

+ 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. Auto Email from Excel Help
    By daveb86 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2014, 01:51 PM
  2. Auto email from Excel
    By parvinder in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2014, 02:08 AM
  3. Auto email from excel
    By Rose Mendoza in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2012, 02:26 AM
  4. Auto Email from within Excel
    By mrcasado in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2010, 11:18 AM
  5. auto paste/forward email to folder/excel/wordreceive from a particular email ID
    By tariqnaz2005 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 10-22-2009, 06:31 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