Link to home
Start Free TrialLog in
Avatar of delacruz84
delacruz84

asked on

Mail Merge in Excel 2007

I'm trying to do a label mail merge using an excel sheet as my data source. I have followed the instructions provided in the article provided by Microsoft very carefully.  (http://office.microsoft.com/en-us/excel/HP102432671033.aspx)

My problem is when I insert the merged fields in the Word document the next step should be to update the labels. However the "Update Labels" is grayed out and I am not able to continue to create the mailing labels. Can someone please tell to me why the "Update Labels" icon may be grayed out?

Thanks in advance.

ASKER CERTIFIED SOLUTION
Avatar of Rartemass
Rartemass
Flag of Australia image

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 delacruz84
delacruz84

ASKER

Yes, when I clicked on preview only one contact appears. I believe I need to click on "Update Labels" to populate the rest of the document with the contacts taken from the Excel sheet.  
Is the Excel sheet open on your, or any other, PC?
This may cause some locking.
I have tried with the excel sheet open and closed.
could you attach the excel and word files for me to take a look at?