Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-21-2020, 06:06 AM
PBartlett PBartlett is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2019
Novice
Last Page Only Footer
 
Join Date: Aug 2020
Posts: 10
PBartlett is on a distinguished road
Default Last Page Only Footer

Hi all



I have a Word document that contains a table with a variable number of rows (populated by raising an invoice on Xero accounting software). In the footer is another table which is fixed i.e. cannot vary in rows.

When an invoice is created, if there aren't many rows it works just fine and won't overlap the footer table, if however the invoice is long it will go onto two pages (which is fine) but the footer just 'disappears' underneath the variable table and doesn't show on the second page in the footer.

I've tried entering:

"If page = numpages " - without quotes
Highlight page, press Ctrl F9. Highlight numpages , press Ctrl F9
Add a quote after numpages
Add an end quote below the variable table
Select all of footer, press Ctrl F9

It then looks like this:

Code:
{ If 1 = 1 "

table is here

" }
So it needs to work in either scenario if the invoice is one page or more.

Not sure what I'm missing / doing wrong but any help would be hugely appreciated! I've had a look at this post but don't fully understand - this 'code' stuff is new to me: https://www.msofficeforums.com/word/...t-working.html

I'm running Microsoft 2013.

Thank you!!
Reply With Quote
  #2  
Old 08-21-2020, 06:48 AM
gmayor's Avatar
gmayor gmayor is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The field structure should look like


{ IF { PAGE } = { NUMPAGES } "Table is here" }


where each pair of brackets is created with CTRL + F9.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 08-21-2020, 07:47 AM
PBartlett PBartlett is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2013
Novice
Last Page Only Footer
 
Join Date: Aug 2020
Posts: 10
PBartlett is on a distinguished road
Default

Thank you Graham, it now looks like this:

{ If { page } = { numpages } "

table is here

"}

I've tried this with a short and long invoice but the footer isn't showing at all on the invoice? Possibly something needs correcting with the table properties?
Reply With Quote
  #4  
Old 08-21-2020, 08:18 AM
Charles Kenyon Charles Kenyon is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Any chance that you restart numbering at some point in your document (i.e. "front matter" before you start numbering)?
Perhaps a note or cover letter with the invoice?
Those pages would count in the NUMPAGES field but not in the PAGE field and the two would never be equal.
Reply With Quote
  #5  
Old 08-21-2020, 08:34 AM
PBartlett PBartlett is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2013
Novice
Last Page Only Footer
 
Join Date: Aug 2020
Posts: 10
PBartlett is on a distinguished road
Default

Hi Charles

Not sure I fully understand (I'm not a pro with Word!) but you may have pointed me in the right direction...

I clicked into the header and clicked 'Remove Page Numbers' under the Header & Footer section of the toolbar - this has solved the missing footer for invoices that are short, but for long invoices that go onto a second page the footer is still missing?
Reply With Quote
  #6  
Old 08-21-2020, 05:35 PM
Charles Kenyon Charles Kenyon is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

You can always post a sample document here.
How to attach a screenshot or file in this forum.
Reply With Quote
  #7  
Old 08-24-2020, 02:38 AM
PBartlett PBartlett is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2013
Novice
Last Page Only Footer
 
Join Date: Aug 2020
Posts: 10
PBartlett is on a distinguished road
Default Attached

Hi Charles, file attached.

Thank you
Attached Files
File Type: docx MS Forum.docx (21.6 KB, 6 views)
Reply With Quote
  #8  
Old 08-24-2020, 05:25 AM
julaeico julaeico is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2019
Novice
 
Join Date: Aug 2020
Posts: 1
julaeico is on a distinguished road
Default

سایت راز موفقیت سایت قانون جذب تقویت عزت نفس اعتماد به نفس و راز موفقیت افراد جهان
Reply With Quote
  #9  
Old 08-24-2020, 06:18 AM
gmayor's Avatar
gmayor gmayor is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

The problem with the invoice document is that you have the different first page option set. You will have to insert a temporary page break and copy the footer from the first page footer range to the primary footer range. Then you can delete the temporary page break. If the document stretched to more than one page the footer will now appear only on the last page.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #10  
Old 08-24-2020, 06:20 AM
gmayor's Avatar
gmayor gmayor is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Quote:
Originally Posted by julaeico View Post
سایت راز موفقیت سایت قانون جذب تقویت عزت نفس اعتماد به نفس و راز موفقیت افراد جهان
این بدون شک صحیح است ، اما به سختی به مشکل موجود مربوط است
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #11  
Old 08-26-2020, 07:52 AM
PBartlett PBartlett is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2013
Novice
Last Page Only Footer
 
Join Date: Aug 2020
Posts: 10
PBartlett is on a distinguished road
Default

Hi gmayer,

I've tried what you suggested, I think, but it's not working - I probably did something wrong.

Are you able to correct the document I previously attached or provide steps as to how to accomplish your above post?

Thank you and sorry to be a pain!
Reply With Quote
  #12  
Old 08-27-2020, 02:34 AM
gmayor's Avatar
gmayor gmayor is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Provided you don't insert any section breaks, the attached will work.
Attached Files
File Type: docx MS Forum.docx (24.2 KB, 10 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #13  
Old 08-27-2020, 07:34 AM
PBartlett PBartlett is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2013
Novice
Last Page Only Footer
 
Join Date: Aug 2020
Posts: 10
PBartlett is on a distinguished road
Default

Hi gmayer,

This has worked beautifully - thank you!

Still one issue though

I put it through the invoice software and for a short invoice it has the correct text in the footer but for a long invoice (which now correctly shows the footer on the last page) it shows the "Text here" example in the document I previously attached even though I've overwritten it?

Not sure how to correct this.

Thank you for all your help
Reply With Quote
  #14  
Old 08-27-2020, 08:46 PM
gmayor's Avatar
gmayor gmayor is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,105
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

If you insert a page break (Layout tab) in your original one page document, you will have access to both the first page footer and the primary footer, which is where the long document footer resides. Make your changes to the primary footer then remove the page break (Ctrl+H > find ^m replace with nothing).
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #15  
Old 08-27-2020, 10:04 PM
Charles Kenyon Charles Kenyon is offline Last Page Only Footer Windows 10 Last Page Only Footer Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,138
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Or, while on the first page, uncheck the option for different first page. Make your changes, then check the box again.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Separate footer in Word 2013 for each page while having page numbers msbegin Word 3 09-21-2019 01:04 PM
Don't want page number or date in footer on first page, do want graphic in header. dianahbr Word 2 02-23-2018 09:25 AM
I have 20 page word document with a footer. Can i change page # 10 footer only? aligahk06 Word 2 10-25-2017 04:53 AM
Last Page Only Footer begin each section with page 1 in header PLUS continuous page numbering in footer onemorecupofcoffee Word 18 09-04-2013 04:31 PM
How to save the current page in a new file with all the page settings (header, footer Jamal NUMAN Word 6 03-15-2012 03:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:04 PM.


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