#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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 |
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
Here is a link to a tutorial that may do what you wish:
http://www.word.mvps.org/FAQs/MailMe...ToDatafile.htm |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copy a specific words to excel list | romanticbiro | Word VBA | 12 | 12-03-2014 05:12 AM |
Moving addresses from a letter in word into access or excel | docwilll | Office | 3 | 02-22-2014 03:40 PM |
Find all email addresses in word document and delete | Chayes | Word VBA | 14 | 10-22-2013 06:30 AM |
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 |