Word, Excel Mail Merge Issues….
March 19, 2008
Came across a problem with a user at work today, where she was wanting to merge some excel DATA into word. Word wasn’t merging the format that the excel spreadsheet was in. So when the data was merging it was coming across as 9.2 etc where it should have been 92%. The work around is quite simple and i could have kicked my self for not knowing, but i suppose if you have never come across it before then it cant be helped!
In word click on Tools, General and put a tick in the next next to Confirm Conversion At Open
I also came across this document about merging data.
Click Here PDF File
