Quote:
Originally Posted by macropod
I assume this is a continuation of the project discussed here: https://www.msofficeforums.com/mail-...-header-2.html CORRECT
Your post refers to macros, but there don't appear to be any in either document (even though the RPT.doc gives a macro warning). Apologies... I have deleted and renamed some sensitive info and files. This should now be resolved. Likewise, your post refers to INCLUDETEXT fields, but there are none in either document. And, yes, INCLUDETEXT fields do work - even for mailmerges - as previously discussed. Furthermore, the Mailmerge SQL prompt refers to what is, ostensibly, yet another document that you're presumably using as a datasource.
As it stands, I have no idea what the problem is. What is the origin of all the data? An excel workbook, perhaps?
|
the two attached amended and corrected documents should now give a better idea of what I am hoping to achieve. That macro bm001 assigns bookmarks to a number of fields in the header and footer. I am looking to use includetext to reference this data in each label of the mailmerge.
the attached should work better for you now. You should see I have included two different forms of
INCLUDETEXT but neither works - Both did initially but not now and I changed nothing in the meantime. Is there a solution within word or could I/should I write the data to excel and then it would be very simple MM
Apologies again for any wasted time.
Regards
Mary
Ps RPT.doc is the data source and flash is the (incomplete) mail merge template