How to create Multiple Mailing Labels Per Page in Word Without Using the Mail Merge Wizard.

Hi, Friends, Again a Simple Office Idea…to Work Small and Do It smartly.

I just wanted to create  mailing labels one for each recipient but multiple records on each A4 Size Paper so that I can cut them and paste to my envelopes since the Printer was not accepting large envelopes.

Just Like this…..

 

Here is my data sheet in Excel.

So my first option was to create labels in word mail merge.

I did open my data base in mail merge and started creating the Labels.

But to my surprise I can get only one Label per page ….or more labels on one page with same…data…i.e. one label at once or same label on full page.

How to remove…words or digits from a line in MS Word or Excel

Hi, Friends…another useful post…for you..
Here is a simple line…containing words and digits.

Salary for the Month of APR Is Rs 2000

Salary for the Month of MAY Is Rs 3000

Salary for the Month of JUN Is Rs 4000

Salary for the Month of JUL Is Rs 5000

Salary for the Month of AUG Is Rs 6000

Salary for the Month of SEP Is Rs 8000

Salary for the Month of OCT Is Rs 9000

Salary for the Month of NOV Is Rs 105000

Salary for the Month of DEC Is Rs 2300

Salary for the Month of JAN Is Rs 25800

Salary for the Month of FEB Is Rs 22556

Salary for the Month of MAR Is Rs 224

Now I would like to just get the nos in above paragraph.
First Select the Paragraph.
Start with Alt+E+E (Find & Replace Shortcut)

Click on More..