Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Have a look at these:
For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
http://word.mvps.org/FAQs/MailMerge/...DataSource.htm
You probably figured it out already.) This is good too: http://word.mvps.org/FAQs/InterDev/C...WordFromXL.htm I use this code regularly, and with great success. Regards, Ryan--- -- RyGuy "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Hi Bernard,
Thanks for the prompt reply. I've looked through the links but cannot find an answer to my query there. I think I've got the actual creation of the mail-merge process correct - I've done it several times before. But i can't find an explanation as to why a few of my EXCEL column headings do not appear in the 'Insert Merge Field' tab in my Word document. As I said, I have 55 field headings called "A" through to "BC" but only the letters "A" to "AT" appear on the 'Insert Merge Field' tab and the info contained under mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was not found in header record of data source' message (which seems to be logical). Somewhere along the line, not all the columns of data are being transferred from EXCEL to WORD. Hope this makes it a little clearer. Yendorian "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Hi Ryan,
Thanks for the prompt reply. I've looked through the links but cannot find an answer to my query there. I think I've got the actual creation of the mail-merge process correct - I've done it several times before. But i can't find an explanation as to why a few of my EXCEL column headings do not appear in the 'Insert Merge Field' tab in my Word document. As I said, I have 55 field headings called "A" through to "BC" but only the letters "A" to "AT" appear on the 'Insert Merge Field' tab and the info contained under mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was not found in header record of data source' message (which seems to be logical). Somewhere along the line, not all the columns of data are being transferred from EXCEL to WORD. Hope this makes it a little clearer. Yendorian "ryguy7272" wrote: http://word.mvps.org/FAQs/MailMerge/...DataSource.htm You probably figured it out already.) This is good too: http://word.mvps.org/FAQs/InterDev/C...WordFromXL.htm I use this code regularly, and with great success. Regards, Ryan--- -- RyGuy "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Well, start by posting the code that doesn't work.
-- RyGuy "Yendorian" wrote: Hi Bernard, Thanks for the prompt reply. I've looked through the links but cannot find an answer to my query there. I think I've got the actual creation of the mail-merge process correct - I've done it several times before. But i can't find an explanation as to why a few of my EXCEL column headings do not appear in the 'Insert Merge Field' tab in my Word document. As I said, I have 55 field headings called "A" through to "BC" but only the letters "A" to "AT" appear on the 'Insert Merge Field' tab and the info contained under mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was not found in header record of data source' message (which seems to be logical). Somewhere along the line, not all the columns of data are being transferred from EXCEL to WORD. Hope this makes it a little clearer. Yendorian "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Sorry - I'm not with you as I am not using any code to do the mail merge.
Which code are you referring to? "ryguy7272" wrote: Well, start by posting the code that doesn't work. -- RyGuy "Yendorian" wrote: Hi Bernard, Thanks for the prompt reply. I've looked through the links but cannot find an answer to my query there. I think I've got the actual creation of the mail-merge process correct - I've done it several times before. But i can't find an explanation as to why a few of my EXCEL column headings do not appear in the 'Insert Merge Field' tab in my Word document. As I said, I have 55 field headings called "A" through to "BC" but only the letters "A" to "AT" appear on the 'Insert Merge Field' tab and the info contained under mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was not found in header record of data source' message (which seems to be logical). Somewhere along the line, not all the columns of data are being transferred from EXCEL to WORD. Hope this makes it a little clearer. Yendorian "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Sorry for the delayed response, and sorry that I can't be of more help. I'm
not sure what the issue is there. Without VBA code, the procedure should be pretty simple, just follow the prompts, right. Make sure all of your columns have headings and make sure there is no 'nonsense' data in there (data that looks correct but is actually just garbage). It sounds liek you knwo what you're doing. Maybe just take a look at this: http://www.csd509j.net/district_info...erge_excel.pdf and give it another shot. Regards, Ryan--- -- RyGuy "Yendorian" wrote: Sorry - I'm not with you as I am not using any code to do the mail merge. Which code are you referring to? "ryguy7272" wrote: Well, start by posting the code that doesn't work. -- RyGuy "Yendorian" wrote: Hi Bernard, Thanks for the prompt reply. I've looked through the links but cannot find an answer to my query there. I think I've got the actual creation of the mail-merge process correct - I've done it several times before. But i can't find an explanation as to why a few of my EXCEL column headings do not appear in the 'Insert Merge Field' tab in my Word document. As I said, I have 55 field headings called "A" through to "BC" but only the letters "A" to "AT" appear on the 'Insert Merge Field' tab and the info contained under mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was not found in header record of data source' message (which seems to be logical). Somewhere along the line, not all the columns of data are being transferred from EXCEL to WORD. Hope this makes it a little clearer. Yendorian "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Word Mail Merge
Hi Ryan,
Thanks for your ideas on this. Your term garbage led me to check the data being merged. I started with the last field to be transferred over - no problem. Then in the next column that would not merge, I found a negative figure (-£200) which I changed to a positive one to try. And no more problem. It seems that in the format that I have, negative figures are not easily merged as such. With a bit of Maths, I have managed to get round the problem. But it might be useful to bear this in mind if any other people come across the same problem in the future! Thanks once again. Yendorian "ryguy7272" wrote: Sorry for the delayed response, and sorry that I can't be of more help. I'm not sure what the issue is there. Without VBA code, the procedure should be pretty simple, just follow the prompts, right. Make sure all of your columns have headings and make sure there is no 'nonsense' data in there (data that looks correct but is actually just garbage). It sounds liek you knwo what you're doing. Maybe just take a look at this: http://www.csd509j.net/district_info...erge_excel.pdf and give it another shot. Regards, Ryan--- -- RyGuy "Yendorian" wrote: Sorry - I'm not with you as I am not using any code to do the mail merge. Which code are you referring to? "ryguy7272" wrote: Well, start by posting the code that doesn't work. -- RyGuy "Yendorian" wrote: Hi Bernard, Thanks for the prompt reply. I've looked through the links but cannot find an answer to my query there. I think I've got the actual creation of the mail-merge process correct - I've done it several times before. But i can't find an explanation as to why a few of my EXCEL column headings do not appear in the 'Insert Merge Field' tab in my Word document. As I said, I have 55 field headings called "A" through to "BC" but only the letters "A" to "AT" appear on the 'Insert Merge Field' tab and the info contained under mergefields "AU" to "BC" in the WORD doc appears as a 'Error! MergeField was not found in header record of data source' message (which seems to be logical). Somewhere along the line, not all the columns of data are being transferred from EXCEL to WORD. Hope this makes it a little clearer. Yendorian "Bernard Liengme" wrote: Have a look at these: For help on Word mail merge using Excel as the data source have a look here http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...ateADataSource. 50 min MS tutorial http://office.microsoft.com:80/train...RC011205671033 Debra Dalgleish posted this: There's an article on the Microsoft web site that might help you: Answer Box: Numbers don't merge right in Word http://office.microsoft.com/en-ca/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Yendorian" wrote in message ... 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 azm merging using DDE as I want to preserve the formatting from the EXCEL file. Can anyone help, please? Yendorian |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Mail merge two word | Excel Worksheet Functions | |||
mail merge from Excel to Word | Excel Discussion (Misc queries) | |||
how do I use mail merge in excel for word documents | Excel Discussion (Misc queries) | |||
Merge mail excel to word | Excel Discussion (Misc queries) | |||
Word mail merge with Excel data | Excel Worksheet Functions |