Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
EXCEL - WORD Merge Problem
I've already posted this on the 'EXCEL Worksheet Functions' pages but
wondered if anyone from the WORD community can help with this one. Working with Office 2003, I am trying to merge data from an EXCEL file to use in a WORD doc. and getting an intermittent fault. In all, I have 55 column headings in my EXCEL workbook but when I try to merge these into my WORD doc only 49 of them appear in the 'Insert Merge Field' tab and in the document. I have tried using simple letters instead of full words as column headings (e.g. "A" through to "BC" instead of "Surname", "Address" etc.) and there are no hidden columns or spaces before the letters. On occasions I do get all the required merge fields but only after closing down and starting the programme again. I am merging using DDE as I want to preserve the formatting from the EXCEL file. My regional Settings are set to English (United Kingdom). Can anyone help, please? Yendorian |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
EXCEL - WORD Merge Problem
I'm not an MVP, but I did encounter this same problem last week as I was
trying to work out some weird Excel to Word date conversions. Is the first cell in your missing column empty? I assume, based on what I encountered, that when using DDE to merge, Word will stop looking for data when it encounters an empty cell. I also found DDE froze my PC and/or frequently refused the connection. Whatever the case, you may have to put aside the DDE and re-format your Excel data to force Word to pull it in properly (e.g., my Excel dates are now 'Custom: ##-##-####); or consider creating your report forms in Excel. Suzanne "Yendorian" wrote: I've already posted this on the 'EXCEL Worksheet Functions' pages but wondered if anyone from the WORD community can help with this one. Working with Office 2003, I am trying to merge data from an EXCEL file to use in a WORD doc. and getting an intermittent fault. In all, I have 55 column headings in my EXCEL workbook but when I try to merge these into my WORD doc only 49 of them appear in the 'Insert Merge Field' tab and in the document. I have tried using simple letters instead of full words as column headings (e.g. "A" through to "BC" instead of "Surname", "Address" etc.) and there are no hidden columns or spaces before the letters. On occasions I do get all the required merge fields but only after closing down and starting the programme again. I am merging using DDE as I want to preserve the formatting from the EXCEL file. My regional Settings are set to English (United Kingdom). Can anyone help, please? Yendorian |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
EXCEL - WORD Merge Problem
Thanks for that, Suzanne,
I'll wait a bit longer to see if there are any other suggestions but I fear I might have to reformat my EXCEL data at some stage. Yendorian "Suzanne" wrote: I'm not an MVP, but I did encounter this same problem last week as I was trying to work out some weird Excel to Word date conversions. Is the first cell in your missing column empty? I assume, based on what I encountered, that when using DDE to merge, Word will stop looking for data when it encounters an empty cell. I also found DDE froze my PC and/or frequently refused the connection. Whatever the case, you may have to put aside the DDE and re-format your Excel data to force Word to pull it in properly (e.g., my Excel dates are now 'Custom: ##-##-####); or consider creating your report forms in Excel. Suzanne "Yendorian" wrote: I've already posted this on the 'EXCEL Worksheet Functions' pages but wondered if anyone from the WORD community can help with this one. Working with Office 2003, I am trying to merge data from an EXCEL file to use in a WORD doc. and getting an intermittent fault. In all, I have 55 column headings in my EXCEL workbook but when I try to merge these into my WORD doc only 49 of them appear in the 'Insert Merge Field' tab and in the document. I have tried using simple letters instead of full words as column headings (e.g. "A" through to "BC" instead of "Surname", "Address" etc.) and there are no hidden columns or spaces before the letters. On occasions I do get all the required merge fields but only after closing down and starting the programme again. I am merging using DDE as I want to preserve the formatting from the EXCEL file. My regional Settings are set to English (United Kingdom). Can anyone help, please? Yendorian |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
EXCEL - WORD Merge Problem
Hi Suzanne,
I've solved the problem. It seems as if it was caused by a negative figure in one of the first records to be merged (-£ 200). I changed this to a positive number and it worked. Could be a useful tip for anybody in the future - it's such a simple error that has caused me hours of research! Still - it's all godd fun! Yendorian "Suzanne" wrote: I'm not an MVP, but I did encounter this same problem last week as I was trying to work out some weird Excel to Word date conversions. Is the first cell in your missing column empty? I assume, based on what I encountered, that when using DDE to merge, Word will stop looking for data when it encounters an empty cell. I also found DDE froze my PC and/or frequently refused the connection. Whatever the case, you may have to put aside the DDE and re-format your Excel data to force Word to pull it in properly (e.g., my Excel dates are now 'Custom: ##-##-####); or consider creating your report forms in Excel. Suzanne "Yendorian" wrote: I've already posted this on the 'EXCEL Worksheet Functions' pages but wondered if anyone from the WORD community can help with this one. Working with Office 2003, I am trying to merge data from an EXCEL file to use in a WORD doc. and getting an intermittent fault. In all, I have 55 column headings in my EXCEL workbook but when I try to merge these into my WORD doc only 49 of them appear in the 'Insert Merge Field' tab and in the document. I have tried using simple letters instead of full words as column headings (e.g. "A" through to "BC" instead of "Surname", "Address" etc.) and there are no hidden columns or spaces before the letters. On occasions I do get all the required merge fields but only after closing down and starting the programme again. I am merging using DDE as I want to preserve the formatting from the EXCEL file. My regional Settings are set to English (United Kingdom). Can anyone help, please? Yendorian |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Another solution
I had the same problem, and was prompted by your solution to have a look at what was different. Mine was simply that I had autofilter enabled for the first X columns but not subsequent. Selecting the top row and turning autofilter off then on (thus autofiltering all rows) did the trick.
Yendoria wrote: EXCEL - WORD Merge Problem 22-Feb-08 Hi Suzanne, I've solved the problem. It seems as if it was caused by a negative figure in one of the first records to be merged (-?? 200). I changed this to a positive number and it worked. Could be a useful tip for anybody in the future - it's such a simple error that has caused me hours of research! Still - it's all godd fun! Yendorian "Suzanne" wrote: EggHeadCafe - Software Developer Portal of Choice WPF DataGrid Custom Paging and Sorting http://www.eggheadcafe.com/tutorials...tom-pagin.aspx |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with using Excel data in a Word mail merge | Microsoft Word Help | |||
Link Excel to Word Mail Merge - found problem for mix data type | Mailmerge | |||
Problem with mail merge from Excel sheet to Word, HELP? | Mailmerge | |||
Insert Merge Field problem with Word-Mail Merge from Excel documen | Microsoft Word Help | |||
Word-Excel 2003 - Mail Merge Recipients problem | Mailmerge |