sp_send_dbmail Question - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

sp_send_dbmail Question

Author

Topic

helixpoint
Constraint Violating Yak Guru

291 Posts

Posted - 2009-05-19 : 08:32:34

Is it possible to add a recipients display name with the email address?

Dave
Helixpoint Web Development
http://www.helixpoint.com

jholovacs
Posting Yak Master

163 Posts

Posted - 2009-05-19 : 11:36:11

I think the format is something like @recipients = 'George Smith <george@smith.com>' kind of thing, but don't quote me on that.

SELECT TOP 1
w.[name]
FROM
dbo.women w
INNER JOIN
dbo.inlaws i
ON
i.inlaw_id = w.parent_id
WHERE
i.net_worth > 10000000
AND
i.status IN ('dead', 'dying')
AND
w.husband_id IS NULL
ORDER BY
w.hotness_factor DESC

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources