Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-18-2010, 10:11 AM
Mr_Luke Mr_Luke is offline Mail Merge question:  Using fields connected to a CSV file in Word 2007 Windows 7 Mail Merge question:  Using fields connected to a CSV file in Word 2007 Office 2007
Novice
Mail Merge question:  Using fields connected to a CSV file in Word 2007
 
Join Date: Jun 2010
Posts: 1
Mr_Luke is on a distinguished road
Default Mail Merge question: Using fields connected to a CSV file in Word 2007


Hello,

I’m not sure if this is a mail merge question or not. I am wondering if I can “link” fields in word to CSV files and have the fields in word automatically change, on a reopen or refresh, when the CSV files change. Or is Word only capable of doing this with MySQL or MS Access?

I tried doing this in Open Office but became so frustrated I switched to Word 2007.

I’m trying to create a document which contains data from about 9 different CSV files and includes about 16 different fields. I would like to stick with CSV because that is the output of a few different programs from which I am getting the data.

Unlike a mail merge I do not require separate data from each “tab” in a CSV file to then be placed into separate labels (like addresses) or separate documents to print (for example salutations; one letter to Mr. Smith, the next to Mr. Adams ect.).

I just want to be able to have a form letter, rich with fields linked to CSV, in which I can change the CSV files and not have to manually mess with the fields in my word document. As well, preserve all the neat formatting features of my fields—including what “cells” to include.

Or is the only way to do this to:

1.) Buy MS Access

2.) Create a database in MS Access made up of my 9 CSV files

3.) Manually reload the CSV files into MS Access after each change in data

4.) Have my Word fields linked to my one MS Access database.

It seems that it should be easy for Word to reload data from a bunch of different CSV files after I reopen my document. I understand a “real time” refresh linking to a simple tax comma delimitated file is unrealistic, but why isn’t there a button like reload “all field data sources”?

Spreadsheet software seems to often include a button like “refresh all data sources” which works fine In Open Office calc for reloading data from multiple CSV files. Shouldn’t it be the same in Word?

Thank you so very much for your time, it is very much appreciated. I apologize in advance if I’m writing too much about a very simple question.

Best, Luke

P.S. Perhaps there is another open source software solution I have not thought of? I’m still in the trial of Word and would like to avoid buying both Word and MS Access.
Reply With Quote
Reply

Tags
csv, fields, mail merge

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set up the fields in mail merge word 07 from my data base mbcrabber Mail Merge 4 06-06-2010 01:25 PM
Mail Merge Fitting Text to Fields frnk4760 Mail Merge 1 05-18-2010 04:51 PM
Mail Merge--different connections of Access in Single Word File. Goldenbird Mail Merge 3 06-12-2009 06:42 AM
Mail Merge question:  Using fields connected to a CSV file in Word 2007 Word 2007 Mail Merge halfempty Mail Merge 1 03-03-2009 07:45 PM
Paragraph Breaks In Mail Merge Fields SamuelT Mail Merge 0 09-25-2008 06:38 AM

Other Forums: Access Forums

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