Moving data from Access to Word

Posted by peter_sheedy December 2, 2011
peter_sheedy's picture
New user

I wish to move a list of names from MS Access 2007 to MS Word 2007 such that they display in Word as a paragraph, with names separated by comma & space, and not as a list:
eg
Access:
John Smith
Mary Jones
Bill Harris

Word:
John Smith, Mary Jones, Bill Harris . . .

Thank you

Answers

#1
Posted by spruce_goose on December 3, 2011
spruce_goose's picture
New user

Use mail merge wizard and select the option to create a directory.

#2
Posted by Reg Orwell on December 4, 2011
Reg Orwell's picture
Power user

Here's the help file on making a directory as mentioned above, and you won't see the actual directory until the last step.
http://support.microsoft.com/kb/294693

#3
Posted by peter_sheedy on December 4, 2011
peter_sheedy's picture
New user

Thank you for that - you have been a great help
Peter S

Email Facebook Reddit Digg AddThis