Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jace Jace is offline
external usenet poster
 
Posts: 3
Default Merging from CSV; data problem

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   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Merging from CSV; data problem

The place to look is at the datasource.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"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

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove the leading zero from mergefield . Joergen Bondesen Mailmerge 15 December 9th 06 03:29 AM
Fonts changing when merging data Chuck Jurgens Mailmerge 1 September 12th 06 04:36 AM
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
Merging Data into Differently-Sized Tables Mike Mailmerge 1 July 27th 06 04:03 PM
How do keep blank lines when merging a document with the data and. ftroop Mailmerge 1 March 30th 05 04:27 PM


All times are GMT +1. The time now is 07:27 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"