How to get autonumbering and save in a file

[Irshad Alam]

I am making a fax message document. On the top of the page I have inserted a
table in which the first field is for CompanyName and just below that Field
FaxReferenceNo. My requirement is as follows :

a) Every Time I run the Macro/Code it should give me a auto-increment number
(I mean if the last number was 5, next time it should give me 6).

b) I want a file to be saved separately with 2 field – one by company name,
another with reference number. So that whenever I need, I can filter, how
many fax sent to which company and what were the reference number. (lets the
file be in .txt or .xls or .doc any – no problem. But when I will run the
code/Macro – it will collect the company name and paste in that file company
column and collect the reference number and paste to the same file in the
reference number column).

Please advise me in detail the code for the above two. This will help me a
lot to complete my complicated job more and more easier.

Thanking you all.

Regards.

Irshad

 

[Doug Robbins - Word MVP]

See the article "Creating sequentially numbered documents (such as
invoices)" at:

http://www.word.mvps.org/FAQs/MacrosVBA/NumberDocs.htm


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Irshad Alam]

Thanks for your advise.

But the second parts is not cleared. That it has to pick the details from
the active document and paste to another document in the Customer Column or
reference number and paste to a column, so that I can trace later which
customer how many fax message sent- whata were the numbers

regards.

Irshad

 

[Doug Robbins - Word MVP]

If you want to be able to do that, you will need to master a bit of visual
basic.

Take a look at:

"How to create a Userform" at:

http://word.mvps.org/FAQs/Userforms/CreateAUserForm.htm

"Getting To Grips With VBA Basics In 15 Minutes" at:

http://www.word.mvps.org/FAQs/MacrosVBA/VBABasicsIn15Mins.htm

and

http://www.mousetrax.com/techpage.html#autoforms


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP