Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting 0's when merging
I'm trying to merge addresses from excel to word and although all the columns
are labelled, the information in two of them comes up as '0's and not the information that is contained. No idea why its doing this as I have used simular formatting for merging before and it was fine. Can anyone help? |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting 0's when merging
Check Word Tools|Options|General|"COnfirm conversion at open", reconnect to
your data source, and choose the DDE option when it is offered. This occurs because when the data types in an Excel column are mixed (e.g. some things look like numbers and some things look like text), the OLEDB provider that Word uses to get the data makes a choice based on which data type predominates in the first 25 rows of the column. So even if it worked before, changes to the data can change the behaviour. There are one or two other approaches that may help, but the DDE one is generally the best starting point. Peter Jamieson "thandy" wrote in message ... I'm trying to merge addresses from excel to word and although all the columns are labelled, the information in two of them comes up as '0's and not the information that is contained. No idea why its doing this as I have used simular formatting for merging before and it was fine. Can anyone help? |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting 0's when merging
Thanks, thats sorted that. But now its putting the address in the wrong
order. Eg, it says: Ms M Weston Atone Digital, London 30-46 Folgate Street E1 6AY Its in the right order in the excel work sheet and I've tried changing the order when you initially select the list to use, but it always comes up wrong. Can you help again? "Peter Jamieson" wrote: Check Word Tools|Options|General|"COnfirm conversion at open", reconnect to your data source, and choose the DDE option when it is offered. This occurs because when the data types in an Excel column are mixed (e.g. some things look like numbers and some things look like text), the OLEDB provider that Word uses to get the data makes a choice based on which data type predominates in the first 25 rows of the column. So even if it worked before, changes to the data can change the behaviour. There are one or two other approaches that may help, but the DDE one is generally the best starting point. Peter Jamieson "thandy" wrote in message ... I'm trying to merge addresses from excel to word and although all the columns are labelled, the information in two of them comes up as '0's and not the information that is contained. No idea why its doing this as I have used simular formatting for merging before and it was fine. Can anyone help? |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Getting 0's when merging
Strange.
Are the addresses complete addresses in a single column in the Excel sheet, or is each part (name, company, city, postcode etc. in a separate column in the sheet? Are you using an ADDRESSBLOCK field to insert your addresses? If so, a. you may need to "re-map" the column names in your Excel sheet (you should be able to get to the right place in the Addressblock dialog) as it's possible that the coumn names are coming into Word slightly differently (It's the only thing I can think of that makes sense). b. consider using the individual fields instead Peter Jamieson "thandy" wrote in message ... Thanks, thats sorted that. But now its putting the address in the wrong order. Eg, it says: Ms M Weston Atone Digital, London 30-46 Folgate Street E1 6AY Its in the right order in the excel work sheet and I've tried changing the order when you initially select the list to use, but it always comes up wrong. Can you help again? "Peter Jamieson" wrote: Check Word Tools|Options|General|"COnfirm conversion at open", reconnect to your data source, and choose the DDE option when it is offered. This occurs because when the data types in an Excel column are mixed (e.g. some things look like numbers and some things look like text), the OLEDB provider that Word uses to get the data makes a choice based on which data type predominates in the first 25 rows of the column. So even if it worked before, changes to the data can change the behaviour. There are one or two other approaches that may help, but the DDE one is generally the best starting point. Peter Jamieson "thandy" wrote in message ... I'm trying to merge addresses from excel to word and although all the columns are labelled, the information in two of them comes up as '0's and not the information that is contained. No idea why its doing this as I have used simular formatting for merging before and it was fine. Can anyone help? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error in merging to a word doc. would merge only 2 pages worth | Microsoft Word Help | |||
Merging documents | Mailmerge | |||
Merging of cells within a table | Tables | |||
How to mail merging with MSword 2003? | Mailmerge | |||
How to prevent Word from merging tables? | Tables |