+ Reply to Thread
Results 1 to 3 of 3

Make a sheet with selectable info, send email using info selected

  1. #1
    Registered User
    Join Date
    04-17-2007
    Posts
    3

    Make a sheet with selectable info, send email using info selected

    Good Morning Everyone,

    I am wondering if i can get some help on this issue.

    Every night, at work, we send out an email to all the representatives. For this email we are manually typing in all the information. I am wondering how i can make it so that this is automatically set up.

    This is the format of the email

    Recipents: Eastgate text message (an outlook name for all the reps)

    Subject: Nightly numbers

    Body:

    Eastgate

    Rev: (Value from sheet, that changes cell depending on day)
    WTD Rev: Standard for the week but changes once a week
    H/S: (Value from sheet, that changes cell depending on day)
    WTD H/S: Standard for the week but changes once a week
    IPS: (Value from sheet, that changes cell depending on day)
    WTD IPS: Standard for the week but changes once a week
    Att Rate: (Value from sheet, that changes cell depending on day)
    WTD Att Rate: Standard for the week but changes once a week
    New Activations: Value from cell for that day

    That is the email, now to make things more complicated, The info will change each day and each week from cells on the sheet that is manually entered each day

    i had an idea, to make a cell Validation, with a list that includes Sunday through saturday, and another cell next to it, with week1 through 5, and whne someone selects sunday and week 1 it will provide the information from the cells i will go through and set up, (either an array or some other way) not too sure how yet though.
    Then the email can be sent from the sheet that has the specific info on it.

    If there is any help anyone can recommend, i would greatly appreciate it. Thank you all very much in advance.

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    There are many possibilities, perhaps you could familiarize yourself with:
    RonDeBruin
    j-walk
    Best regards,

    Ray

  3. #3
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello DwayneHeight,

    We'll start off taking care of the most complicated part of your request first, and go from there. This macro copys a Worksheet you choose and places it in the body of the email in HTML format. After you copy the macro code, insert a Standard VBA Module into your workbook, and paste the code into it.

    Invoking the Email macro:
    The format is EmailWorksheet Recipient, Subject Line
    EmailWorksheet "[email protected]", "This worksheet was sent in HTML format."

    Please Login or Register  to view this content.
    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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