Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LarryC74
Yak Posting Veteran
94 Posts |
 Posted - 2009-12-02 : 12:09:02
|
| Hi All,Is it possible to set up a report (which I could do by a creating a table function) to send an e-mail to one or more people with that report attached as an excel spreadsheet?What would be my first step in doing that? (other than writing the query...I can do that :) )Larry |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
LarryC74
Yak Posting Veteran
94 Posts |
Posted - 2009-12-02 : 13:23:50
|
| I use a replication database for reports. There is really NO data entry or "front ends" for users.There are After Action meetings that happen after a hospital event. The lady who sets up the meeting would get a long winded e-mail from personnel that says the same thing as what was entered in the website. I have an Access database that pulls the info down for her during the meeting with some questions that she answers in Access. What she wants is an automatic e-mail that will send her the information that is in the Electronic medical records website we use, so she can copy and paste that info into a meeting planner to send to everyone. I am trying to stop the "triple" work my employees have to do. So I thought, after replication happened I could get the SQL server agent to send her an e-mail with the information.She will not have access to the Website...She is not to keen on having to look for information, she wants it all "in front" of her. This is all new, since they were using paper for the past 8 years.Larry |
 |
|
|
|
|
|
Send email with report as excel spreadsheet