Mialing label with report

[Ramesh]

Is it possible to print mailing labels from a report?

What are the advantages i have with using report for outputs vs using forms?
I have been using only forms so far for all my outputs and wonder if i am
actually missing out on reports.

thanks for any inputs.

Ramesh

 

[Ramesh]

To give further picture .. I figured out the Label wizard and selected a
query with the address fields. No matter what fields and stationery i use,
i get an error message first saying the width of the paper is not sufficient
but when i continue the labels are there. But just the Name field does not
work.

The design view shows a different entry only for the Name field. Like
=Trim([TITLE] & " " & [Report]!NAME). All the other lines simply have TRIM
[fieldname] and are displayed fine. What could the problem be the name
field? Without the name field, the other fields display without a problem.

Thanks
ramesh

 

[Ramesh]

this one got figured out too .. the fieldname Name had a problem. I changed
the name to SName and it works perfectly fine. though the error display
regarding Horizontal space not sufficient and Data may not be displayed
still persists.

thanks for being there and reading till here.

Ramesh

To give further picture .. I figured out the Label wizard and selected a
query with the address fields. No matter what fields and stationery i
use, i get an error message first saying the width of the paper is not
sufficient but when i continue the labels are there. But just the Name
field does not work.

The design view shows a different entry only for the Name field. Like
=Trim([TITLE] & " " & [Report]!NAME). All the other lines simply have
TRIM [fieldname] and are displayed fine. What could the problem be the
name field? Without the name field, the other fields display without a
problem.

Thanks
ramesh

Is it possible to print mailing labels from a report?

What are the advantages i have with using report for outputs vs using
forms? I have been using only forms so far for all my outputs and wonder
if i am actually missing out on reports.

thanks for any inputs.

Ramesh