Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    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...
  2. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    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...
  3. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    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?
  4. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    Thanks, I'll give that a try. Just in case, can you give me a link to the previous thread? Colleen Thomas
  5. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    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...
  6. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    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.
  7. CMTHOMAS

    macro/vba to search, analyze, and act in a merge

    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...

Part and Inventory Search

Back
Top