Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-30-2020, 04:35 AM
macropod's Avatar
macropod macropod is offline Using Mailmerge To Include Grouped Information In a Letter Windows 7 64bit Using Mailmerge To Include Grouped Information In a Letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


Your second screenshot shows that Word has given you a macro security alert, next to which is an Options button. Click on that and enable macros.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 06-01-2020, 08:32 AM
Tesla Tesla is offline Using Mailmerge To Include Grouped Information In a Letter Windows 7 32bit Using Mailmerge To Include Grouped Information In a Letter Office 2007
Advanced Beginner
Using Mailmerge To Include Grouped Information In a Letter
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

Thank you macropod , the code works, but as a beginner I don't understand why concluding phrase is put before introductory phrase in the code. I will keep trying to make a desired content (putting totals) and font (Bold, Italics, font style). I will come back after some time to tell you that I have been able to produce desired letter. Thank you abundantly. God bless you.
Reply With Quote
  #3  
Old 06-02-2020, 09:57 AM
Tesla Tesla is offline Using Mailmerge To Include Grouped Information In a Letter Windows 7 32bit Using Mailmerge To Include Grouped Information In a Letter Office 2007
Advanced Beginner
Using Mailmerge To Include Grouped Information In a Letter
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

Hello, thank you again for the help, but I still have one difficulty. Some debtors have may invoices which cover two or three pages. The code i have enables me to list those invoices but concluding information below the list is not seen. I wish I could generate a letter which lists invoices and the message below the invoices. I attach an example of invoices I have and the code to generate the letter.
Thank you for helping me to make a code that will enable me to produce a letter of one or more pages containing the list of invoices and concluding information.
Attached Files
File Type: doc letter-3.doc (47.0 KB, 15 views)
File Type: xls invoice list.xls (33.5 KB, 10 views)
Reply With Quote
  #4  
Old 06-02-2020, 03:28 PM
macropod's Avatar
macropod macropod is offline Using Mailmerge To Include Grouped Information In a Letter Windows 7 64bit Using Mailmerge To Include Grouped Information In a Letter Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,362
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Tesla View Post
Hello, thank you again for the help, but I still have one difficulty. Some debtors have may invoices which cover two or three pages. The code i have enables me to list those invoices but concluding information below the list is not seen.
The number of pages a particular group might span is of no consequence; anything that doesn't fit on the first page will appear on the second or later page, as appropriate.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 06-02-2020, 10:56 PM
Tesla Tesla is offline Using Mailmerge To Include Grouped Information In a Letter Windows 7 32bit Using Mailmerge To Include Grouped Information In a Letter Office 2007
Advanced Beginner
Using Mailmerge To Include Grouped Information In a Letter
 
Join Date: Sep 2018
Posts: 59
Tesla is on a distinguished road
Default

Thank you macropod, may be I explained less clearly my problem. If I can summarize what I want is this:

Introductory comment
Invoice 1
Invoice 2
Invoice 3

page break

Invoice 4
Invoice 5
Invoice 6

page break

Invoice 7
Invoice 8
Invoice 9

concluding comment

The problem I have is that "concluding comment" desapears when invoices are on more than one pages. Any help is welcome
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Mailmerge To Include Grouped Information In a Letter Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? Jake93 Mail Merge 3 07-02-2019 05:38 PM
Using Mailmerge To Include Grouped Information In a Letter Use L and R arrow to move cursor letter to letter, not top of the line mellowkitten Word 2 05-12-2016 07:23 PM
How to replace a letter to random letter with different color? cikanoz87 Word 7 06-18-2015 09:43 PM
Using Mailmerge To Include Grouped Information In a Letter Mailmerge with grouped data Keith Henderson Mail Merge 14 02-04-2015 01:45 PM
Directory MailMerge with Category Grouped Lists on Labels screech Mail Merge 3 06-18-2014 11:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft