Link to home
Start Free TrialLog in
Avatar of Farah Mohammed
Farah MohammedFlag for United States of America

asked on

Mail Merge Question Microsoft Word 2013

I have an excel file with columsn labeled Employee Name, Employee Last Name, Guest Name and Guest Last Name.
I want to print out labels (name tags) where first label will have the Employee Name and Employee Last Name and the next label has the Guest Name and Guest Last Name. The first label on the second row will have the next Employee Name and Employee Last Name and the next label on the same row has the next Guest Name and Guest Last Name.

There are 300 lines so you can appreciate I do not want to have to write the name tags out.

Any ideas with mail merge and labels? Thank you in advance.
ASKER CERTIFIED SOLUTION
Avatar of dpsully07
dpsully07

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Farah Mohammed

ASKER

So for the first run, I would set the second column of lables to be blank, run the first merge with the employees name in the first column. Then the second run, leave first column blank and do the merge on the second column with the guest name?

Thank you
Avatar of dpsully07
dpsully07

Yes
You can select/deselect the fields in "match fields option" while in the merge wizard.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you for the suggestions above.