Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-29-2015, 04:10 PM
michael37150 michael37150 is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Novice
numbering invoices
 
Join Date: Oct 2015
Posts: 6
michael37150 is on a distinguished road
Default numbering invoices


I'm using Word 2010. I created a word document that I use for an invoice. I keep it attached to an email so I can conveniently double click it and make a few changes and the send it. I a place that I named Invoice in the document. Beside that word I insert a number. I want to automate the sequential numbering. I have searched but have found nothing that meets my specific need. Can anyone help? Thanks
Reply With Quote
  #2  
Old 10-29-2015, 04:41 PM
macropod's Avatar
macropod macropod is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

There have been numerous topics along these lines. See, for example:
https://www.msofficeforums.com/word/...html#post19265
https://www.msofficeforums.com/word/...html#post43283
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 10-29-2015, 05:32 PM
michael37150 michael37150 is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Novice
numbering invoices
 
Join Date: Oct 2015
Posts: 6
michael37150 is on a distinguished road
Default

Thanks for the post. None of the information from the links worked for me. I'm not sure how to explain more of what I need.
Reply With Quote
  #4  
Old 10-29-2015, 05:37 PM
macropod's Avatar
macropod macropod is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

You can't really work with a document that's permanently attached to an email - you need to create & use a template.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 10-29-2015, 05:59 PM
michael37150 michael37150 is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Novice
numbering invoices
 
Join Date: Oct 2015
Posts: 6
michael37150 is on a distinguished road
Default

I see. Yep, that is my dilemma
Reply With Quote
  #6  
Old 10-29-2015, 09:23 PM
Charles Kenyon Charles Kenyon is offline numbering invoices Windows 8 numbering invoices Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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

Quote:
Originally Posted by michael37150 View Post
I'm using Word 2010. I created a word document that I use for an invoice. I keep it attached to an email so I can conveniently double click it and make a few changes and the send it. I a place that I named Invoice in the document. Beside that word I insert a number. I want to automate the sequential numbering. I have searched but have found nothing that meets my specific need. Can anyone help? Thanks
A bit off-topic. editing documents attached to emails has been a very good way for people to lose their work. I would strongly urge you to consider using a template, creating a new document based on the template, and using Save and Send to send as an email attachment.
Reply With Quote
  #7  
Old 10-30-2015, 07:37 AM
michael37150 michael37150 is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Novice
numbering invoices
 
Join Date: Oct 2015
Posts: 6
michael37150 is on a distinguished road
Default

Thank you for your post. I thought that is what I was doing. I have a folder with a saved email with a document attached to it. When I need to send an invoice, I open the email, then I open the attached document. I edit the document, click save, then close the document. I then enter the email address, click save and the send. I just wish I could automate the invoice numbering.
I am open to a new way if it is as simple.
Reply With Quote
  #8  
Old 10-30-2015, 07:23 PM
macropod's Avatar
macropod macropod is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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 michael37150 View Post
Quote:
Originally Posted by Charles Kenyon View Post
I would strongly urge you to consider using a template, creating a new document based on the template, and using Save and Send to send as an email attachment.
I thought that is what I was doing. I have a folder with a saved email with a document attached to it. When I need to send an invoice, I open the email, then I open the attached document. I edit the document, click save, then close the document. I then enter the email address, click save and the send.
Templates and documents are two entirely different things. What you've described so far is a document. And, as you're working from an email attachment, you're just as likely to be sending the unedited document, since editing email attachments typically doesn't update the attachment, but only the temporary copy of it that you've opened. Hence Charles' comment:
Quote:
editing documents attached to emails has been a very good way for people to lose their work.
In any event, working with a proper template (which is what the zip file in https://www.msofficeforums.com/word/...html#post34444 contains) and attaching the document generated from it to an email is hardly any more difficult - it also gives you a permanent copy of the invoice without having to troll through your emails.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 10-31-2015, 08:30 AM
michael37150 michael37150 is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Novice
numbering invoices
 
Join Date: Oct 2015
Posts: 6
michael37150 is on a distinguished road
Default

Thank you for your post. I started with a blank Word document. I then copied my old document and pasted it to my New document and Saved it As a Word Macro-Enabled Document. When I opened the New Document I got a Runtime error 5. When I ran debug it had highlighted a portion of the code. I am attaching a copy of what debug reported. I guess I need to change something, but I am not quite sure what to do. Thanks for the help.
Attached Files
File Type: docx Debug copy.docx (13.5 KB, 7 views)
Reply With Quote
  #10  
Old 10-31-2015, 12:11 PM
macropod's Avatar
macropod macropod is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

You need to add the Custom Document Property named "InvNum" to the document, as discussed in post #2 of the thread in the link (https://www.msofficeforums.com/word/...html#post19265)

You will also need to add the DOCPROPERTY field for the numbering to your file, as per the Invoice.dot demo.

Alternatively, you could have simply edited the Invoice.dot demo by adding your own content to it.

Finally, you should also be saving the Word file as a Macro-Enabled Template, not as a Document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #11  
Old 10-31-2015, 01:00 PM
Charles Kenyon Charles Kenyon is offline numbering invoices Windows 8 numbering invoices Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,124
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

Quote:
Originally Posted by michael37150 View Post
Thank you for your post. I started with a blank Word document. I then copied my old document and pasted it to my New document and Saved it As a Word Macro-Enabled Document. When I opened the New Document I got a Runtime error 5. When I ran debug it had highlighted a portion of the code. I am attaching a copy of what debug reported. I guess I need to change something, but I am not quite sure what to do. Thanks for the help.
A macro-enabled document is still a document, not a template. You really do want to be using a template for this.
Templates in Microsoft Word
Reply With Quote
  #12  
Old 10-31-2015, 11:24 PM
michael37150 michael37150 is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Novice
numbering invoices
 
Join Date: Oct 2015
Posts: 6
michael37150 is on a distinguished road
Default

Sorry, I mistakenly said document when I really meant to say template. The code was from the invoice.zip file. I just copied it and pasted it into my new "template".
I tried just adding content to the invoice.zip, it just moved the numbers around. Once I added anything to it it would not work anymore. The other things list above, I do not know how to do those things. It seems to me that invoice auto numbering should be a simple task, but it is not for me. I can continue the way I have been doing it for about 3 years now, but it would make it a little bit easier if I could figure this out. Thanks
Reply With Quote
  #13  
Old 11-01-2015, 01:43 AM
macropod's Avatar
macropod macropod is offline numbering invoices Windows 7 64bit numbering invoices Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

As I said in post #10, the steps required for implementation in a different template are detailed in post #2 of the linked thread.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
numbering invoices Help with numbering struggling Word 4 05-18-2014 12:17 PM
Numbering issue gap bettween 1.1 and text lower and higer numbering leave no gap Turtlesrun Word 3 02-21-2014 04:48 AM
numbering invoices Creating Invoices using data from a spreadsheet tjcusick Excel Programming 3 12-05-2013 08:36 AM
Help making invoices easier wbowles Office 0 07-17-2013 10:39 AM
numbering invoices Creating Invoices from CSV iansan5653 Excel 5 02-07-2012 05:05 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:26 AM.


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