Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Send email to different recipients Expand / Collapse
Author
Message
Posted Wednesday, October 10, 2012 2:35 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 12,744, Visits: 31,078
change your query to select distinct email, notes.

when you merge them with FOR XML, you often have duplicates.


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1371120
Posted Wednesday, October 10, 2012 3:33 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 30, 2012 7:51 AM
Points: 13, Visits: 34
My friend,

Now it's very goood,

Do you know as to show result of the NOTE field vertically in the Email Body?

for example as this one:

JOSE ASUNCION FIGUEROA ESTRADA
JAIME SALAZAR CORDERO
JAVIER BRISEÑO GARCIA

Thank so much!!!



Post #1371142
Posted Wednesday, October 10, 2012 4:21 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 8:42 AM
Points: 12,744, Visits: 31,078
come on, you should know this.
html does not respect whitespace!

find and replace char(13)(char10) with <br />, and isnert <br /> wherever else you want new lines to appear.

sanmon_11 (10/10/2012)
My friend,

Now it's very goood,

Do you know as to show result of the NOTE field vertically in the Email Body?

for example as this one:

JOSE ASUNCION FIGUEROA ESTRADA
JAIME SALAZAR CORDERO
JAVIER BRISEÑO GARCIA

Thank so much!!!





Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1371157
Posted Thursday, October 11, 2012 6:42 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, November 30, 2012 7:51 AM
Points: 13, Visits: 34
ok my friend,

thank so much for your time and support

excellent contribution!!!
Post #1371427
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse