Home Forums SQL Server 2008 SQL Server 2008 - General Send email to different recipients RE: Send email to different recipients

  • October 10, 2012 at 4:21 pm

    #1547843

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!