Word Report Template - Mail Label

See Microsoft ® Word ® Report

Function and SQL

/* Mail Label */
@F1=Report(table=1 type=var cell=B7,B8,B9,B10 
copyrange=1:11 pagebreak = 4r)
SELECT CompanyName
,Address
,CityName & ', ' & CountryName
,PostalCode
FROM Customers, Cities, Countries
WHERE Customers.CityCode = Cities.CityCode
AND Customers.CountryCode = Cities.CountryCode
AND Customers.CountryCode = Countries.CountryCode
ORDER BY CompanyName
;

These sample reports are generated by WDReportGen (Report Generator for Microsoft Word). The sample reports in Microsoft Word document format can be download for your report templates, and changed to adapt to your own needs. It is free.

Download the report samples in Microsoft Word document format  DOC (472KB)