+ Reply to Thread
Results 1 to 16 of 16

looking to email individul rosters

  1. #1
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    looking to email individul rosters

    Pleas review the attachment. I have a list of employee emails addresses and shift they are to work for the week. I would like to mail merge the week roster but all i can get it do to is email each day (using Word). Is the any way of collecting all the data for the employee week and then email individually?
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    Hi..

    The Attached should do what you want..

    Heres the code.. check out the Functions (RangetoHTML and UniqueList) code in the file..

    Please Login or Register  to view this content.
    Attached Files Attached Files

  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

    Re: looking to email individul rosters

    Hello tvt029,

    Here is another way that sends the schedule from Excel without having to use Word. The attached zip file contains a picture of an actual email I sent to myself. This macro will send this same table to all the employees on the worksheet. The data is first sorted by employee number and then by date. The macro below has been added to the attached workbook.

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

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  4. #4
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    Thanks very much Leith. You have a great mind into this as i am just starting out. Question what if i wanted to email individual so employee could not see another employee shifts.

  5. #5
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    HI..

    Question what if i wanted to email individual so employee could not see another employee shifts.
    Did you try my code/attachment..? it does exactly that..

  6. #6
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    Thank you apo,
    The sheet i posted has a limited number of employees. i have tired to merge your VBA into a bigger file but have trouble allocating the work sheets. The file i have is bigger but will tri and work with the formula thank you have done. Thanks again it works as i want it just need to tweek it to my roster file.

  7. #7
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    Apo,
    i get a debug error. i am trying to change the name of the sheet but have had no luck
    Attached Images Attached Images

  8. #8
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    What is the error message..?

    Do you actually have a sheet named "Sheet1" in your workbook.. and is that the sheet where your list is on?

  9. #9
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    The sheet the information comes from is called EmailSend

  10. #10
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    I notice in the VBA area the Sheet has a number and teh name i call it in brackets. which one do i use?

  11. #11
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    Do a find and replace.. (CTRL + F)..

    Replace: "Sheet1"

    With : "EmailSend"

  12. #12
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    Thanks apo I think i have got it. Question if i decided to include another column of data to the email to be shown at the start of their shift. Would it involve any more coding?

  13. #13
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    Hi..

    Just a modification of the code already done..

    I am guessing you want to show something like the Task they will be doing for that shift or something like that?

    So do you want to insert a new column at column D and show that value to the left of the Shift_Start in the email body?

  14. #14
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    Yes that is correct.
    attach is the columnheading
    Attached Images Attached Images

  15. #15
    Registered User
    Join Date
    02-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    15

    Re: looking to email individul rosters

    Thanks for your assistance so far. I can get this far but when i click on email nothing happens. Do you mind have a look for me.?
    Attached Files Attached Files

  16. #16
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    Hi..

    Try the attached..
    Attached Files Attached Files

  17. #17
    Valued Forum Contributor
    Join Date
    03-22-2013
    Location
    Australia,NSW, Wirrimbi
    MS-Off Ver
    Excel 2013
    Posts
    1,057

    Re: looking to email individul rosters

    Hi..

    Try the attached..

+ 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. Setting up Rosters
    By ian.clark in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-21-2013, 02:53 AM
  2. 40 hours perweek Rosters
    By darellharrison in forum Excel General
    Replies: 1
    Last Post: 04-18-2012, 10:54 PM
  3. Creating Individual Rosters from RAW Data
    By grumpyrogue in forum Excel General
    Replies: 3
    Last Post: 12-14-2011, 10:19 PM
  4. Replies: 1
    Last Post: 01-15-2006, 11:50 PM
  5. Staff Rosters.
    By Delma in forum Excel General
    Replies: 1
    Last Post: 12-12-2005, 11:10 PM

Tags for this Thread

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