print command

[anbusathya2003]

dear sir,

sheet1 is mailing format
sheet2 is mailing data


iam using vlookup command, only single entry to print

how to mail merge all records (or) from to records (or) filter records to print

please help me,

[ChuckYeager]

Hi Anbu,

Depends upon the mailing format. Are you using an address label format or a letter format.

The mailing format needs to be copied or composed in a word document and a mail merge set up needs to be completed. Inserting the mailmerge fields in the document. The mail merge process would automatically allow you to both filter by from to as well as skip select records.

Further more it can be exported into a document, which can act as your print file.

If you need help with mailing format, please attach a sample copy of spreadsheet.

Having said that, this question is more appropriate for a Word related forum.

Regards

Chuck.