SOLVED IT!
I created the following macro to run after the merge. I had to insert a continuous section break after each service section, as the bookmarks didn't get inserted in the merge. Thanks for the help, I really appreciate your efforts!
Sub abba()
'
' abba Macro
' Macro recorded...
Because each client record is different, I can't run the "clean-up" portion of the code (macro) until after I have run the merge into a new document. This removes the bookmark (because we can't have 100+ bookmark(1)s in a document), and that gets rid of my reference points for the bookmark...
So lost. I started with your hint, and I have tried a dozen things since. I (briefly) had it working using in the template displaying a single record, but upon merging, the bookmarks disappear, and it doesn't work anymore. Have any hints as to where to begin with this?
I really don't know where to start. I tried creating an if/then field to place the text DELETE BOOKMARK within the bookmark to be removed. I then tried a CASE ELSE vba sub to find and delete the so marked bookmarks. I couldn't get the syntax right. I just don't know enough about the options...
Thanks.
Of course, that would be the easy way, but my company is not licensed for Access. Word, Excel, PowerPoint and Outlook only. I have to work with what I've got.
Hello,
I have a Word2002 .dot I am creating that will create a letter using mail merge (source is an excel file). I have created portions of the letter (I'll call them paragraphs) that include if/then fields (not macros) to display text dependent on the contents of the field. I created...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.