Thread: [Solved] Mail merge bookmark (again)
View Single Post
 
Old 10-14-2014, 12:45 PM
Nisio07 Nisio07 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Sep 2014
Posts: 21
Nisio07 is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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
Attached Files
File Type: doc RPT.doc (81.0 KB, 10 views)
File Type: docx flash.docx (19.0 KB, 9 views)
Reply With Quote