Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-21-2014, 11:48 AM
docwilll docwilll is offline Moving addresses from a letter in word into access or excel Windows XP Moving addresses from a letter in word into access or excel Office 2007
Novice
Moving addresses from a letter in word into access or excel
 
Join Date: Feb 2014
Location: Grovetown GA
Posts: 2
docwilll is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-21-2014, 03:30 PM
macropod's Avatar
macropod macropod is offline Moving addresses from a letter in word into access or excel Windows 7 32bit Moving addresses from a letter in word into access or excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
  #3  
Old 02-22-2014, 01:35 PM
docwilll docwilll is offline Moving addresses from a letter in word into access or excel Windows XP Moving addresses from a letter in word into access or excel Office 2007
Novice
Moving addresses from a letter in word into access or excel
 
Join Date: Feb 2014
Location: Grovetown GA
Posts: 2
docwilll is on a distinguished road
Default Moving addresses from a letter in word into access or excel

Thanks Macropod,
Here is a sample letter
Attached Files
File Type: docx Test to Macropod.docx (10.3 KB, 11 views)
Reply With Quote
  #4  
Old 02-22-2014, 03:40 PM
macropod's Avatar
macropod macropod is offline Moving addresses from a letter in word into access or excel Windows 7 32bit Moving addresses from a letter in word into access or excel Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving addresses from a letter in word into access or excel How to stop letter body moving up and down alankempster Mail Merge 2 09-13-2012 08:09 AM
Moving addresses from a letter in word into access or excel Word/Excel letter templates TracyW Mail Merge 3 04-04-2012 02:21 PM
Moving addresses from a letter in word into access or excel Replace is capitalizing the first letter of the first word Beachhouse Word 1 02-07-2012 03:36 PM
Moving addresses from a letter in word into access or excel 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:28 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