Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-28-2015, 02:42 AM
msnarayanan msnarayanan is offline how to copy addresses in word document to excel/mailmerge list Windows 8 how to copy addresses in word document to excel/mailmerge list Office 2013
Advanced Beginner
how to copy addresses in word document to excel/mailmerge list
 
Join Date: Jul 2015
Posts: 37
msnarayanan is on a distinguished road
Default how to copy addresses in word document to excel/mailmerge list

dear all

i have a created a file in ms word 2013 which consists of addresses
of all relatives/friends. these are in different sizes (from 3 to 5 lines.

the addresses are in three columns and the spaces between the
addresses are not uniform.

for eg:
xxxxxxxxxxxxxxxxx yyyyyyyy zzzzzzzzzzz
16 cantonment 12 big st nandigram


chennai off ring road near hospital
bombay metro
kalkatta

i just wanted to include these addressed in excel so that it can be
used as mailmerge list.

i think the doc file has to be converted to txt and then to excel.
i am unable to fix the delimit symbol.
please help me out

m s narayanan
Reply With Quote
  #2  
Old 09-28-2015, 03:50 AM
gmayor's Avatar
gmayor gmayor is offline how to copy addresses in word document to excel/mailmerge list Windows 7 64bit how to copy addresses in word document to excel/mailmerge list Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Without knowing how the individual addresses are separated, it is impossible to separate them.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-28-2015, 04:51 AM
msnarayanan msnarayanan is offline how to copy addresses in word document to excel/mailmerge list Windows 8 how to copy addresses in word document to excel/mailmerge list Office 2013
Advanced Beginner
how to copy addresses in word document to excel/mailmerge list
 
Join Date: Jul 2015
Posts: 37
msnarayanan is on a distinguished road
Default copying word document to excel

dear sir

the individual addresses are separated by :
Title: Mrs
Name: Johan
address1: Block 1 - Heavens Flat 404
address2: Cantonment area
address3: City
Zip: 5600070

as i mentioned earlier, there are three columns
with 3 to 5 rows for each address.

will transpose method help? if so, please help me
how can it be done.

thanks

m s narayanan
Reply With Quote
  #4  
Old 09-28-2015, 05:22 AM
gmayor's Avatar
gmayor gmayor is offline how to copy addresses in word document to excel/mailmerge list Windows 7 64bit how to copy addresses in word document to excel/mailmerge list Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,101
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

You miss the point. One address is insufficient. As the addresses are of different lengths, we need to know how the addresses are separated from one another, otherwise how do you determine where one address ends and the next starts?

What sort of columns are involved? Table? Snaking columns? Or just spaced texts, in which case you might as well forget it.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 10-17-2015, 03:17 PM
ScottA ScottA is offline how to copy addresses in word document to excel/mailmerge list Windows 7 64bit how to copy addresses in word document to excel/mailmerge list Office 2010 32bit
Advanced Beginner
 
Join Date: Apr 2014
Posts: 30
ScottA is on a distinguished road
Default

Here is a link to a tutorial that may do what you wish:

http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy addresses in word document to excel/mailmerge list copy a specific words to excel list romanticbiro Word VBA 12 12-03-2014 05:12 AM
how to copy addresses in word document to excel/mailmerge list Moving addresses from a letter in word into access or excel docwilll Office 3 02-22-2014 03:40 PM
how to copy addresses in word document to excel/mailmerge list Find all email addresses in word document and delete Chayes Word VBA 14 10-22-2013 06:30 AM
how to copy addresses in word document to excel/mailmerge list seach an Excel list elements in word document 7ajar Word VBA 5 03-16-2011 12:38 PM
Creating a Map From a List of Addresses aleccamp Excel 0 11-19-2005 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:12 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft