Mail Merge help - address list in Excel Sheet - how to merge?

Question

Hi,

I have 3000 addresses in an excel sheet. The address is in 5 columns - with separate columns for number, street, area, town, city etc., ect.

I have typed the letter in MS Word. When I try to open the address list to merge, as the data source, it doesnt pick excel sheets (although mail merge tutorial says that its possible to have excel sheets for data source :address list)

How do I mail merge the letter I have in word, with these 3000 addresses that I have in excel?

A step by step instruction would be greatly, greatly GREEEEAATLY appreciated!!

Thank you!!!

Answer 1

You have to create format in Word.



For Data select the file in excel.



Then add the feild.



In case you require more clarification then mail me.



Reuben

Answer 2

Here's a great step by step: http://mistupid.com/technical/mailmerge/



When you get to the "Data Source" part of the mail merge, just choose a different folder from the "LOOK IN" area at the top. Hope this helps!!

Answer 3

right this is what I even tend to do when I also have a difficulty resembling yours. Step a million: form the record. records > form... This places comparable values close at the same time. Step 2: filter out the concepts via picking each and every of the concepts (commonly I gain this via picking the gray block between A and a million in the coolest perfect corner) then go with. records > filter out > AutoFilter. Step 3: Use a formula to ensure if the cellular above or below is the comparable. for the reason that your Addresses are in Column I, permit's placed an Excel formula in the subsequent colum to the ideal to evaluate the cellular row below. as an occasion enter the formula below in cellular J2: =IF(I2 = I1, "duplicate", "no longer duplicate") The IF formula works like this: First permit's smash it down somewhat into section A, section B, section C. = IF(section A, section B, section C) section A - you employ to study 2 or greater issues and get a real or fake answer. section B - is what Excel reflects in the cellular if the assessment evaluates as actual section C - is what's displayed if the assessment evaluates as fake Your first row could be a header. So once you enter that, cellular J2 could state "no longer duplicate". reproduction that formula down into the remainder of the cells for that column. and it will record each and everything as to whether that's a replica or no longer. Step 4: clean out the duplicates. bypass to the coolest of column J and decide the little filter out arrow for a drop down record. you are able to now the two do one in each and every of two issues. Have it coach the duplicates and delete out the duplicates. Or have it coach the non-duplicates and reproduction them over to the different sheet. Step 5: Delete out the column with the formula in it. Excel commonly will in basic terms reproduction the rows that are seen. in spite of the incontrovertible fact that, each and every now and returned it does go with to be a discomfort and needs to repeat each and everything. If it does reproduction the hidden rows there is something you're able to do to supply up that. once you go with the concepts, bypass to Edit on the Menu Bar and decide Edit > bypass to... > particular > seen cells in basic terms > ok This selects in basic terms the seen cells and rows. Then reproduction and paste your records. once you get good at this in Excel, you're able to have the means to get rid of the repeated values on a catalogue that long in below a minute or so.