formatting output of data

[mrdude]

i'm working on a program where one of the functions is to build mailing labels from a list of prospects. i'm having trouble figuring out how to set this up.
i'm using vb.net and an access database. all of the info on the prospects is in one table, and i'll pick out the name and address and have them output into a dataset so that i can export it to excel. i need the output to look like this:
firstname1 lastname1
address1
city1, state1 zip1

firstname2 lastname2
address2
city2, state2 zip2

etc.

so how would i structure the code in order to build a mailing list like this?

[hariharanmca]

i'm working on a program where one of the functions is to build mailing labels from a list of prospects. i'm having trouble figuring out how to set this up.
i'm using vb.net and an access database. all of the info on the prospects is in one table, and i'll pick out the name and address and have them output into a dataset so that i can export it to excel. i need the output to look like this:
firstname1 lastname1
address1
city1, state1 zip1

firstname2 lastname2
address2
city2, state2 zip2

etc.

so how would i structure the code in order to build a mailing list like this?

You want to desigen report or to display somewhere...?

[mrdude]

You want to desigen report or to display somewhere...?

yes, i'm designing a report. sorry if i was unclear

[hariharanmca]

yes, i'm designing a report. sorry if i was unclear

which report
1.Data Report
2.Crystal Report
3.DOS Print Report.
etc..,

Make it clear dear,,