Share via

Filling out an id card with data from excel into word.

Anonymous
2023-12-15T11:10:21+00:00

Hi

I want to make ID tags for an larger company meeting I have a template, just an table in word with spaces for the information, and an excel spreadsheet with the name and position of an individual

I can copy everything from the excel manually, but it will tacke time. So i am wondering if its possible to automate it with excel. I can’t make any formatting changes in the data,

Example on how things looks like in the excel spreadsheet

NAME Position
NAME A Position A
Name B Position B
Name C Position C

An this I how I want the ID tags

Name A Name B
Position A Position B
Name C
Position C
Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2023-12-15T13:51:49+00:00

    Hi VB_606,

    Thanks for posting in the Microsoft Community.

    Yes, it is possible to automate the process of filling out the ID tags using data from Excel. You can use the mail merge feature in Microsoft Word to accomplish this. Just a heads up that in regards to this kind of issue, our option is limited and we can only perform basic troubleshooting steps. For now, please allow me to ask some questions to better understand your concern.

    • May I know what version and edition of Office installed in your computer? Is it for Business or for Personal?
      • You can open any Office apps
      • Go to File > Accounts - on the right side you can see Product Information
    • Are you using Excel and word application or you open it via Online version?

    While waiting for your response. Here are the steps:

    1. Open your Excel spreadsheet and select the data you want to use for the ID tags.
    2. Click on the “Insert” tab and select “Table” to convert your data into a table.
    3. Click on the “Design” tab and select “Table Name” to give your table a name.
    4. Open a new Word document and create a table with spaces for the information you want to include in your ID tags.
    5. Click on the “Mailings” tab and select “Start Mail Merge” and then “Labels”.
    6. In the “Label Options” dialog box, select the type of label you want to use and click “OK”.
    7. Click on “Select Recipients” and choose “Use Existing List”.
    8. Browse to your Excel spreadsheet and select the table you created earlier.
    9. Drag and drop the fields from your Excel spreadsheet into the appropriate spaces in your Word document.
    10. Click on “Finish & Merge” and select “Edit Individual Documents”.
    11. Click “OK” to create a new document with your ID tags.

    Please send us a reply if there are any confusions or clarifications to our description. I hope this helps!

    Regards,

    John Lloyd

    Microsoft Moderator

    6 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-12-15T15:06:59+00:00

    Hi, It worked. I going to need to find out how to arrange them on the page in a good way but that is homework

    0 comments