(Msg. 1) Posted: Wed Feb 20, 2008 10:26 am
Post subject: EXCEL - WORD Merge Problem Archived from groups: microsoft>public>word>mailmerge>fields (more info?)
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
(Msg. 2) Posted: Wed Feb 20, 2008 12:04 pm
Post subject: RE: EXCEL - WORD Merge Problem [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 3) Posted: Wed Feb 20, 2008 12:35 pm
Post subject: RE: EXCEL - WORD Merge Problem [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 4) Posted: Fri Feb 22, 2008 2:56 pm
Post subject: RE: EXCEL - WORD Merge Problem [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
(Msg. 5) Posted: Mon Sep 28, 2009 6:42 am
Post subject: Another solution [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
RE: 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
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office