I need help!!!! Please someone HELP

larainalton

New Member
Joined
Jan 29, 2004
Messages
2
I have over 300 address that I want to mail merge but they are in a list and I can't figure out how to make them so that I can do a mail merge in word. PLease help!!!

This is an example of the list:
Afghanistan
Canadian Embassy
Street No. 15, House No. 256, Wazir Akbar Khan, Kabul, Afghanistan     
(93) 70-294-281, 79-305-464    
canadakabul@yahoo.com

Albania
Consulate of Canada
Bulevardi Zhan d'Ark, Kulla Teknoprojekt, No. 2, Apt. 1, Tirana, Albania            
355 (42) 57254/ 355 (42) 57275  
355 (42) 275273
canadalb@canada.gov.al

Algeria
Canadian Embassy
18, rue Mustapha-Khalef, Ben Aknoun, Alger, Algeria     
Postal P.O. Box 48, Alger-Gare, 16000 Alger, Alger, Alger-Gare 16000, Algeria
(213) 2191-4951, 2191-4960  
(213) 2191-4973
alger@dfait-maeci.gc.ca

Angola
Consulate of Canada
Rua Rei Katyavala 113, Luanda, Angola  
244 (2) 448-371, 448-377, 448-366  
244 (2) 449-494
consul.can@angonet.org

Argentina  

Canadian Embassy
2828 Tagle, C1425EEH Buenos Aires, Argentina    
Postal P.O. Box 1598, C1000WAP , Buenos Aires, C1000WAP Correo Central, Argentina
54 (11) 4808-1000  
54 (11) 4808-1012
bairs@dfait-maeci.gc.ca    
www.dfait-maeci.gc.ca/bairs

Armenia
Consulate of Canada
25 Demirjian Street, No. 21, Yerevan, Armenia     
374 (1) 56-79-03  
374 (1) 56-79-03

Australia - Canberra  

Canadian High Commission
Commonwealth Avenue, Canberra ACT 2600, Australia   
61 (2) 6270-4000  
61 (2) 6270-4081
cnbra@dfait-maeci.gc.ca    
www.dfait-maeci.gc.ca/australia

Australia - Melbourne  

Consulate of Canada
Level 50, 101 Collins Street, Melbourne, Victoria 3000, Australia  
61 (3) 9653-9674

Australia - Perth  

Consulate of Canada
3rd Floor, 267 St. George's Terrace, Perth, Western Australia 6000, Australia    
61 (8) 9322-7930  
61 (8) 9261-7706

Australia - Sydney  

Consulate General of Canada
Level 5, Quay West, 111 Harrington Street, Sydney, New South Wales 2000, Australia    
61 (2) 9364-3000  
61 (2) 9364-3098
sydny@dfait-maeci.gc.ca

Austria  

Canadian Embassy
Laurenzerberg 2, 1010 Vienna, Austria  
43 (1) 531-38-3000  
43 (1) 531-38-3905
vienn@dfait-maeci.gc.ca    
www.kanada.at


If anyone can tell me how to break this up so it can be mail merged I would be greatful. Please keep in mind I don't really know what im doing.

Thanking you in advance for any sort of ideas. Plea
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

Forum statistics

Threads
1,214,789
Messages
6,121,593
Members
449,038
Latest member
Arbind kumar

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top