Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data being altered
I have a CSV file w/ 100 rows containing data as follows:
A1 B1 C1 ......................Z1 A2 B2 C2.......................Z2 etc. When I connect to the CSV file as a DataSource (using File - Open Data Source), and then look at the Mail Merge Recipients, the cell that should say "F1" just says "1". The cell that should say "K1" also says "1". And the cell that should contain "S1" also contains just a "1". In fact, every data cell that begins with F, K, or S has that letter dropped from the front of the string. Every other cell is ok. Am I nuts??? What is going on here??? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Merge data being altered
Yes, this is a bizarre result that occurs when Word connects to the .csv
file using ODBC. I don't know why exactly, but I think ODBC decides that some columns are "numeric" and changes e.g. "F1" to 1. You may have been unaware that Word was connecting using ODBC, or may not know what ODBC is. It's just one of the methods that Word can use to connect to data sources. In the case of text and csv files, Word may use either ODBC or its own internal "Text converter" depending on various factors. In Word 2002/2003 it can use another thing, OLEDB, too. My guess is that you're using Word 97/2000 in which you can probably fix this by going into "Open Data Source" again, checking Select method, selting your .csv and clicking the Open button. You should then see an additional dialog box called "Confirm Data Source. In there, select "Text Files (*.txt)" and click the OK button. If you don't see the Text files option, check the Show all box. (If you happen to be using Word 2002 or later, you have to check Word Tools|Options|General|"Confirm conversion at open", then go into Select Data Source and follow approximately the same procedure as above. Peter Jamieson "Jace" wrote in message ... I have a CSV file w/ 100 rows containing data as follows: A1 B1 C1 ......................Z1 A2 B2 C2.......................Z2 etc. When I connect to the CSV file as a DataSource (using File - Open Data Source), and then look at the Mail Merge Recipients, the cell that should say "F1" just says "1". The cell that should say "K1" also says "1". And the cell that should contain "S1" also contains just a "1". In fact, every data cell that begins with F, K, or S has that letter dropped from the front of the string. Every other cell is ok. Am I nuts??? What is going on here??? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save the data form for merge documents? | Mailmerge | |||
Data Trucated in word merge with excel source | Mailmerge | |||
Format Fractions in Mail Merge. | Mailmerge | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |