Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Mar 2011
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Post additional data to a bookmark

    I have a excel report that when I click the merge data places the information onto a word document. I'm trying to see if there is anyway to have additional information added to the word document. It now will list the total in any given section: Assaults; OtherAssaults; Incidents; and Force. I also wish it to have the corresponding report #. example on word document bookmark would look something like
    Assaults: total 2 Report Number(s) 111, 118
    Other Assaults: total 2 Report Number(s) 112, 117
    Incidents: total 2 Report Number(s) 113, 116
    Force: total 2 Report Number(s) 114, 115

    Any ideas would be helpful!!!!
    Attached Files Attached Files
    Last edited by RonNCmale; 2011-10-25 at 03:45.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    Could you attach a copy of the template called "Monthly_Report.dot"? or at least sample copy that works with the macro?

    Steve

  3. #3
    New Lounger
    Join Date
    Mar 2011
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I can't seem to attach it. It is not showing up in the attachment so I can upload it. Any other ideas or email I can send to?

    got it! zipped
    Attached Files Attached Files
    Last edited by RonNCmale; 2011-10-26 at 03:59.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Cross-posted here.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    New Lounger
    Join Date
    Mar 2011
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I apologize for cross posting. I didn't mean any harm. I still am looking for a solution.
    Last edited by RonNCmale; 2011-11-03 at 01:03.

  6. #6
    New Lounger
    Join Date
    Mar 2011
    Posts
    15
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Attached is a zip file that has the excel workbook and word dot file, also included is a word doc that shows what the template should end up with. Any help would be appreciated.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •