Creating Mailing Labels (Generic)

Can anyone advice on how to create mailing labels using SQL reporting
services?
Thank you in advanceI would use Word or other proprietary software like Page O Labels or similar :)
"Rahul Chatterjee" wrote:
> Can anyone advice on how to create mailing labels using SQL reporting
> services?
> Thank you in advance
>
>|||create a list report and export to excel and use it as a source for a mail
merge. Better yet, set up your database as a data source in Excel and do it
directly in Excel w/ microsoft Query
"Rahul Chatterjee" <rahul@.benesysinc.com> wrote in message
news:OsOMwYszHHA.5408@.TK2MSFTNGP02.phx.gbl...
> Can anyone advice on how to create mailing labels using SQL reporting
> services?
> Thank you in advance
>

Creating mailing label using database

Hi!

I have these tables:

DB1
MID
IIN
Title
FullName
Address
Apt
City
Province
PostalCode

DB2
MID
Lang
Version

How can I output a text file formatted like the one below?

(05) 01046 (F 05)
Mr. Sylvain Cote
123 Sesame Street
Apt 6
Charny, BC
L8T 5G6

where
(05)-MID
01046-IIN
(F 05) - LangConcatenate the various address components, separated by carriage return characters.|||Could you please post a sample code?

Thanks.|||select Title + ' ' + FullName + char(13)
+ Address + Char(13)
+ 'Apt ' + Apt + char(13)
+ City + ', ' + Province + char(13)
+ PostalCode + Char(13)
from YourTable