#1
|
|||
|
|||
Moving addresses from a letter in word into access or excel
My database of 1700 addresses was corrupted somehow. I found an old word file with all of the names and addresses on 1700 letters. Is there a way to get these addresses into one of the above programs without manually typing it in?
Last edited by docwilll; 02-21-2014 at 11:52 AM. Reason: typos |
#2
|
||||
|
||||
Probably, but without seeing how they're structured in the Word document, it's hard to say for sure or how much effort will be involved. Can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Moving addresses from a letter in word into access or excel
Thanks Macropod,
Here is a sample letter |
#4
|
||||
|
||||
I would need a wider range of sample data than for just one record - samples representing the whole range of possibilities would be required. The one you posted has only three address lines. If, for example, some letters go to people in companies or outside the US, I imagine you could have as many as eight address lines:
Addressee Name Position/Title Division/Branch Company Name Floor/Room/Unit Building Name Street Address City, State Zip Country
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to stop letter body moving up and down | alankempster | Mail Merge | 2 | 09-13-2012 08:09 AM |
Word/Excel letter templates | TracyW | Mail Merge | 3 | 04-04-2012 02:21 PM |
Replace is capitalizing the first letter of the first word | Beachhouse | Word | 1 | 02-07-2012 03:36 PM |
Merge excel info into word letter. | curatorfm | Mail Merge | 1 | 03-20-2011 04:26 AM |
Word Letter Template Issue | Swarv | Word | 1 | 02-19-2010 08:03 AM |