Mail merge - wrong information being picked

[siddsg]

Hello,
Would like to give a solution to a problem I was facing in Mail Merge where wrong information was getting picked.
Some others might face the same issue so this might be useful for them...

My data in excel is as follows:

	Apples	Oranges
No of orders	10	20

<tbody>
</tbody>

When I was mail merging into word, data was showing as:
<apples>Apples = No of orders
<oranges>Oranges = 10

After much of head scratching and experimenting, I found that this is due to the fact that the No of Orders column had no column header, causing the wrong field to be picked up.
Why? I don't know but thats how it behaves!

Solution: add a dummy column header to the 'No of Orders' column as below:

Header	Apples	Oranges
No of orders	10	20

<tbody>
</tbody>

Thanks,
Siddharth Gangoli</oranges></apples>