Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
When I attempt to do a mail merge from excel to word I get as far as select
recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
To be used as a mailmerge data source, I am (99.999%) sure that the first
row in the spreadsheet must contain the field names and that the data must commence immediately in the next row. It sounds like your data may be otherwise arranged. See the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I attempt to do a mail merge from excel to word I get as far as select recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
Mr. Doug Robbins is absolutely right.
Note; If you get the field names and data correct, then you can "Define' your data as "print area" as well as "Define a Name" for your print area. Either way you will be able associate it to the document for merging. In your case the data structure is wrong. I tried it and it works. Challa Prabhu "Doug Robbins - Word MVP" wrote: To be used as a mailmerge data source, I am (99.999%) sure that the first row in the spreadsheet must contain the field names and that the data must commence immediately in the next row. It sounds like your data may be otherwise arranged. See the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I attempt to do a mail merge from excel to word I get as far as select recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
Once again, I was not the one with the problem so please do not respond to
my threads. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "challa prabhu" wrote in message ... Mr. Doug Robbins is absolutely right. Note; If you get the field names and data correct, then you can "Define' your data as "print area" as well as "Define a Name" for your print area. Either way you will be able associate it to the document for merging. In your case the data structure is wrong. I tried it and it works. Challa Prabhu "Doug Robbins - Word MVP" wrote: To be used as a mailmerge data source, I am (99.999%) sure that the first row in the spreadsheet must contain the field names and that the data must commence immediately in the next row. It sounds like your data may be otherwise arranged. See the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I attempt to do a mail merge from excel to word I get as far as select recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
When I try to preview my labels it comes up blank on word. What am I doing
wrong? "challa prabhu" wrote: Mr. Doug Robbins is absolutely right. Note; If you get the field names and data correct, then you can "Define' your data as "print area" as well as "Define a Name" for your print area. Either way you will be able associate it to the document for merging. In your case the data structure is wrong. I tried it and it works. Challa Prabhu "Doug Robbins - Word MVP" wrote: To be used as a mailmerge data source, I am (99.999%) sure that the first row in the spreadsheet must contain the field names and that the data must commence immediately in the next row. It sounds like your data may be otherwise arranged. See the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I attempt to do a mail merge from excel to word I get as far as select recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
How is your data source arranged? From your original post, it sounded like
it might not be correct. See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I try to preview my labels it comes up blank on word. What am I doing wrong? "challa prabhu" wrote: Mr. Doug Robbins is absolutely right. Note; If you get the field names and data correct, then you can "Define' your data as "print area" as well as "Define a Name" for your print area. Either way you will be able associate it to the document for merging. In your case the data structure is wrong. I tried it and it works. Challa Prabhu "Doug Robbins - Word MVP" wrote: To be used as a mailmerge data source, I am (99.999%) sure that the first row in the spreadsheet must contain the field names and that the data must commence immediately in the next row. It sounds like your data may be otherwise arranged. See the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I attempt to do a mail merge from excel to word I get as far as select recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
I am having problems doing a mail merge between word & excel
I printed what you recommended and went through the steps. The problem now
is that it is giving me old data. I only print labels once a year and its giving me label data I printed two years ago. What am I missing? "Doug Robbins - Word MVP" wrote: How is your data source arranged? From your original post, it sounded like it might not be correct. See the article "Mail Merge to Labels with Word XP" on fellow MVP Graham Mayor's website at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I try to preview my labels it comes up blank on word. What am I doing wrong? "challa prabhu" wrote: Mr. Doug Robbins is absolutely right. Note; If you get the field names and data correct, then you can "Define' your data as "print area" as well as "Define a Name" for your print area. Either way you will be able associate it to the document for merging. In your case the data structure is wrong. I tried it and it works. Challa Prabhu "Doug Robbins - Word MVP" wrote: To be used as a mailmerge data source, I am (99.999%) sure that the first row in the spreadsheet must contain the field names and that the data must commence immediately in the next row. It sounds like your data may be otherwise arranged. See the article "Creating a Mail Merge Data Source" at: http://www.word.mvps.org/FAQs/MailMe...DataSource.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Vanessa" wrote in message ... When I attempt to do a mail merge from excel to word I get as far as select recipients, I pick the print area of the spreadsheet I'm working with. It gives me table which is blank and it changes the file name I am working with. What am I doing wrong |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word should catalog misspelled words to study. | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Mail merge in Word from Outlook Catagories | Mailmerge | |||
Why can't I get Multiple instances of word? | Microsoft Word Help | |||
WP merge file to Word | Tables |