ChatterBank2 mins ago
Excel to Word Mail Merge error message
0 Answers
Hi AB'ers
I have an excel spreadsheet full of data which I wish to use in a mail merge to a word doc. I have done it many times before, but for some reason when I attempt to 'edit individual letters' and select 'all' (or anything) I get the error message 'word could not merge the main document with the data source because the data records were empty or no data records matched your query options'. I have tried everything I can think of, including trying to understand some very technical suggestions I have come across online but to no avail!
Can anyone help? I need to 'extract' the individual records to a multi-page word doc to then convert to a PDF (and onto a disc) for a client, otherwise I'll need to type them all manually...and there's over 200 of them and will probably take me the best part of a week! O_o
Thanks in advance,
Chatterbox
I have an excel spreadsheet full of data which I wish to use in a mail merge to a word doc. I have done it many times before, but for some reason when I attempt to 'edit individual letters' and select 'all' (or anything) I get the error message 'word could not merge the main document with the data source because the data records were empty or no data records matched your query options'. I have tried everything I can think of, including trying to understand some very technical suggestions I have come across online but to no avail!
Can anyone help? I need to 'extract' the individual records to a multi-page word doc to then convert to a PDF (and onto a disc) for a client, otherwise I'll need to type them all manually...and there's over 200 of them and will probably take me the best part of a week! O_o
Thanks in advance,
Chatterbox
Answers
Best Answer
Nobody has yet answered this question. Once some answers have been given, Chatterbox84 will be able to select one answer as the best. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.There are no answers available for this question.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.