Jump to content

Mail Merge from Excel on custom label in Word 2010


sunnyimran

Recommended Posts

Hi there,


 


I am struggling to learn and use mail merge option in word for a specific need. Here is the scenario:


I have worksheet in excel 2010 ready with more than 20 fields in columns as shown below. there are approx 40 records in the excel table rows


 


post-364546-0-67459000-1457538566_thumb.


 


 I want to create a self repeating label strip say 1 inch x 5 inch for all records from excel like this shown below ( sample I drew using plain table of word2010):


 


post-364546-0-19681100-1457538620_thumb.


 


I played a lot with creating labels of custom size in word and using mail merge to populate its fields with my excel sheet. All works fine if i am using first label in its original format (one plain box only). When i draw a table structure in my first label as shown below this table does not replicate in subsequent labels nor any next records are pulled in other labels. only first label works fine.


post-364546-0-58417400-1457538674_thumb.


 


I tried the same this in publisher but somehow could not get what I needed. Can you suggest how to get this self updating strip?


Link to comment
Share on other sites

  • 2 weeks later...

OK guys, I got the solution to achieve my specific task.

 

Publisher's mail merge feature helped me and MS Word Mail merge too. At the moment I am using Publisher but in my free time I will fine tune MS Word hints.

 

Let me summarize it 

Task: To create a set of labels in which contents (data) is pulled from Data source 'MyExcel.xlsx'. These labels have a layout in table ( like MS-Word tables) and each row/col pulls data from my data source. Samples in my first post.

 

So far in MS-Word Mail merge feature has been very useful only hassle is I can't give labels a look like table structure.

 

Publisher did the trick. Actually in publisher, I was able to create a custom page size publication as the size of my label. Then I inserted a table structure on my publication as I would in MS-Word. Then connecting with my data source using Publisher's mail merge feature I inserted individual merge fields where needed inside the table. After running mail merge I was able to print my multiple publications all combined on A4 sized page. screenshot is shown below. Each strip is a separate label ready for my task. Here is the sample:

 

 

In MS-Word I was able to get similar result only problem is when I draw table on my label, subsequent mail merge was not working fine.

 

Anyway task is done

Print Preview Sample PUBLISHER 2.jpg

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...