Mail Merge from Excel
Solved/Closed
Émilie
-
lamasticot -
lamasticot -
Hello everyone!
I have an Excel file that contains about 500 names and contact details. I need to turn them into labels. At first, I armed myself with patience but I must admit it's taking longer than I thought...
I have no idea how to carry out mail merging, can someone help me??
Thank you in advance
Émilie
I have an Excel file that contains about 500 names and contact details. I need to turn them into labels. At first, I armed myself with patience but I must admit it's taking longer than I thought...
I have no idea how to carry out mail merging, can someone help me??
Thank you in advance
Émilie
15 réponses
Good evening,
You need to do your mail merge from Word, of course relying on your Excel file.
In your Excel file, you must enter the headers in the first row of your columns NAME FIRST NAME ADDRESS POSTAL CODE CITY, this is just an example to adapt to your file. Then you select the row where your column headers are located and apply the automatic filter from the DATA menu => FILTER => AUTOFILTER
and save your file
Next, in Word go to TOOLS => MAIL MERGE a window will open, step 1 click on CREATE on the next window on ACTIVE WINDOW
Step 2 click on GET DATA => OPEN DATA at this point you will search for your Excel file, remember to change the file type you are looking for, choose *.XLS, select the entire Worksheet it will open in the background under Excel, you stay in Word.
A window will open click on Prepare the main document, you have no choice, it's the only one.... At this point, you will choose your label type from the list. Confirm by clicking OK.
It's almost the end, hang in there....
A new window opens click on the Insert merge field button and there you will find the names of your columns.
In reality, you will create the layout of your label example:
"NAME" "FIRST NAME"
"ADDRESS"
"POSTAL CODE" "CITY"
Then confirm by clicking OK and move on to step 3 by clicking on Merge then again on Merge in the next window, this action will sweep through your entire Excel file and create your labels.
I hope I was clear enough, but if you need more information, the forum is here.....
You need to do your mail merge from Word, of course relying on your Excel file.
In your Excel file, you must enter the headers in the first row of your columns NAME FIRST NAME ADDRESS POSTAL CODE CITY, this is just an example to adapt to your file. Then you select the row where your column headers are located and apply the automatic filter from the DATA menu => FILTER => AUTOFILTER
and save your file
Next, in Word go to TOOLS => MAIL MERGE a window will open, step 1 click on CREATE on the next window on ACTIVE WINDOW
Step 2 click on GET DATA => OPEN DATA at this point you will search for your Excel file, remember to change the file type you are looking for, choose *.XLS, select the entire Worksheet it will open in the background under Excel, you stay in Word.
A window will open click on Prepare the main document, you have no choice, it's the only one.... At this point, you will choose your label type from the list. Confirm by clicking OK.
It's almost the end, hang in there....
A new window opens click on the Insert merge field button and there you will find the names of your columns.
In reality, you will create the layout of your label example:
"NAME" "FIRST NAME"
"ADDRESS"
"POSTAL CODE" "CITY"
Then confirm by clicking OK and move on to step 3 by clicking on Merge then again on Merge in the next window, this action will sweep through your entire Excel file and create your labels.
I hope I was clear enough, but if you need more information, the forum is here.....
I noticed that you’re quite good with Word, and I have a question for you... I need to prepare labels using mail merge with Word and Excel, and I'm having trouble getting the label numbers to follow on the same page.
Let me explain: Initially, I find the same data on each label on the page. I asked to move to the next label to have consecutive labels on the same page.
My problem is: I go from label 1 to 3, 6, 9, 12 ... and on the second page I start at 2, 4 ... In total, I have 121 labels to create on sheets of 8 labels, but I'm always ending up with 121 pages!!! (8 times too many)
Do you have a trick to ensure my mail merge works correctly? PS: It's Word 1997
Thank you in advance for your help.
Stéph