Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-12-2012, 02:24 PM
e.roberts e.roberts is offline Challenge for a genius ? Windows XP Challenge for a genius ? Office 2007
Novice
Challenge for a genius ?
 
Join Date: Jul 2012
Posts: 2
e.roberts is on a distinguished road
Exclamation Challenge for a genius ?

i have a word document that i need to use in a mail merge, i would like it to be in excel preferably but when i try to import the data it come out very strange, could some one please take a look for me ? i can email the document if needed

Thanks alot
Attached Images
File Type: jpg Untitled1.jpg (63.2 KB, 9 views)
Reply With Quote
  #2  
Old 07-12-2012, 05:41 PM
macropod's Avatar
macropod macropod is offline Challenge for a genius ? Windows 7 64bit Challenge for a genius ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

The data in your Word document would need some pre-processing before it would be suitable for use as a mailmerge data source, in Word or Excel.

Firstly, all the data for each record should be on one row - you have it spread out over multiple lines/paragraphs
Secondly, you would need to have the same number of fields per record - some of your records have more lines (fields) than others.
Thirdly, you'd need a header row to tell the mailmerge what each field represents.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-13-2012, 01:23 AM
e.roberts e.roberts is offline Challenge for a genius ? Windows XP Challenge for a genius ? Office 2007
Novice
Challenge for a genius ?
 
Join Date: Jul 2012
Posts: 2
e.roberts is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
The data in your Word document would need some pre-processing before it would be suitable for use as a mailmerge data source, in Word or Excel.

Firstly, all the data for each record should be on one row - you have it spread out over multiple lines/paragraphs
Secondly, you would need to have the same number of fields per record - some of your records have more lines (fields) than others.
Thirdly, you'd need a header row to tell the mailmerge what each field represents.
Dont want to be a pain but could i send you the doc and you do the first one for me so i can then repeat the process for the rest theres over 1000 of these addresses and i need them all in a mail merge for a uni project.

many thanks
Reply With Quote
  #4  
Old 07-13-2012, 01:36 AM
macropod's Avatar
macropod macropod is offline Challenge for a genius ? Windows 7 64bit Challenge for a genius ? Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

Getting each block of data into a single line is the easy part. The difficult part is going to be in getting it aligned properly, so that you can end up with all the fields properly separated. Some have two email addresses, others have one, those with two email addresses will have everything after the first email address out of alignment with those that have only one email address. And that's without knowing whether the physical addresses all habe the same number of lines. You would do better to get the data output from whatever system generated it, with all the fields properly aligned and delineated.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
mail, merge, word document

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Challenge for a genius ? Sorting Challenge gbaker Excel Programming 11 06-22-2012 09:39 AM
Challenge for a genius ? Word Challenge jpotter2 Word 3 03-22-2011 02:07 PM
Challenge!! Need help though. (Conditional formatting) knuckles70 Excel 2 02-05-2010 12:24 PM
Challenge for a genius ? CHALLENGE! Issue sorting data containing relative references on a separate tab lax828 Excel 3 01-07-2010 11:28 AM
Challenge: Get Custom Form to Show up in Reader Pane in 2007 JohnGG Outlook 0 08-21-2009 05:44 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:20 PM.


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