K
Kirby
Hi I'm trying to set up an e-mail form in excel.
There are multiple jobs each requiring it's own e-mail; the jobs run at
different times and get e-mailed to different groups. On sheet1 I have each
job listed by row; the row includes job name, job #, form, recipeint, etc. On
sheet2 I have generic text that will be included in the e-mail. I'd like to
copy specific cells from sheet1 into specific cells in sheet2 and then e-mail
sheet2 (Outllook) as the e-mail body rather than an attachment. Users will be
updating the the job# and then sending the e-mail so i'd like to make it as
automated as possible. Any suggestions would be greatly appreciated.
Thank you in advance
Kirby
There are multiple jobs each requiring it's own e-mail; the jobs run at
different times and get e-mailed to different groups. On sheet1 I have each
job listed by row; the row includes job name, job #, form, recipeint, etc. On
sheet2 I have generic text that will be included in the e-mail. I'd like to
copy specific cells from sheet1 into specific cells in sheet2 and then e-mail
sheet2 (Outllook) as the e-mail body rather than an attachment. Users will be
updating the the job# and then sending the e-mail so i'd like to make it as
automated as possible. Any suggestions would be greatly appreciated.
Thank you in advance
Kirby