A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Mailmerge multiple lines (invoice etc)



 
 
Thread Tools Display Modes
  #1  
Old December 19th 06, 05:46 PM posted to microsoft.public.word.mailmerge.fields
Andrew Kennard
external usenet poster
 
Posts: 4
Default Mailmerge multiple lines (invoice etc)

Hi all

At some point in the near future the application we are writing will need to
call/automate/workwith Word for the creation of invoices etc

I understand the basic mailmerge stuff and it is quite easy to put an
address block in etc.

But what do people do when they want to merge in an invoice style block
where they do not know howmany "lines" there will be ?

Does anyone out there use Word for invoices ? if so how do you deal with say
the four columns Item Description, Qty, Price, Total. As one invoice could
be a single line and another could be 20 or more ... even two pages.

Obviously I could setup masses of merge fields and have a fixed size records
but this seems too limiting.

I need my application to be 'in charge' so don't really want to go down the
VB script route to automate Word but this is not out of the question so long
as my app knows what was going on and VB could get at te SQL data in a
realitivly complex relational database without miles of code

Thanks in advance for any tips

Kind Regards

Andrew


Ads
  #2  
Old December 19th 06, 07:05 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,832
Default Mailmerge multiple lines (invoice etc)

That would amount to a "multiple items per condition (=key field)" mailmerge
which Word does not really have the ability to do,

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

--
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

"Andrew Kennard" wrote in message
...
Hi all

At some point in the near future the application we are writing will need
to call/automate/workwith Word for the creation of invoices etc

I understand the basic mailmerge stuff and it is quite easy to put an
address block in etc.

But what do people do when they want to merge in an invoice style block
where they do not know howmany "lines" there will be ?

Does anyone out there use Word for invoices ? if so how do you deal with
say the four columns Item Description, Qty, Price, Total. As one invoice
could be a single line and another could be 20 or more ... even two pages.

Obviously I could setup masses of merge fields and have a fixed size
records but this seems too limiting.

I need my application to be 'in charge' so don't really want to go down
the VB script route to automate Word but this is not out of the question
so long as my app knows what was going on and VB could get at te SQL data
in a realitivly complex relational database without miles of code

Thanks in advance for any tips

Kind Regards

Andrew




  #3  
Old December 19th 06, 08:00 PM posted to microsoft.public.word.mailmerge.fields
Andrew Kennard
external usenet poster
 
Posts: 4
Default Mailmerge multiple lines (invoice etc)

Doug

Thanks for the info. We'll probably be using Office XP or later but from the
link you have given me it does look like the way to get it to work is from
the Word side by either accessing the data direct from the database or merge
it in a single complex fields and then use VB to split it up.

What I'm really after is to use the power of Word for page layout placing
images etc etc and then just have simple markers where the varibales go.

Not all of the documents I want to produce will be invoices but the will
need the "muliple row" features.

I'm desparate not to go down the writing my own mini WP route as have been
here many many moons ago and whilst it gives maximum control it's just so
much code and your always have to add new features !

Thanks

Andrew


"Doug Robbins - Word MVP" wrote in message
...
That would amount to a "multiple items per condition (=key field)"
mailmerge which Word does not really have the ability to do,

See the "Group Multiple items for a single condition" item on fellow MVP
Cindy Meister's website at:

http://homepage.swissonline.ch/cindy...faq1.htm#DBPic

Or take a look at the following Knowledge Base Article

http://support.microsoft.com/default...b;en-us;211303

--
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

"Andrew Kennard" wrote in message
...
Hi all

At some point in the near future the application we are writing will need
to call/automate/workwith Word for the creation of invoices etc

I understand the basic mailmerge stuff and it is quite easy to put an
address block in etc.

But what do people do when they want to merge in an invoice style block
where they do not know howmany "lines" there will be ?

Does anyone out there use Word for invoices ? if so how do you deal with
say the four columns Item Description, Qty, Price, Total. As one invoice
could be a single line and another could be 20 or more ... even two
pages.

Obviously I could setup masses of merge fields and have a fixed size
records but this seems too limiting.

I need my application to be 'in charge' so don't really want to go down
the VB script route to automate Word but this is not out of the question
so long as my app knows what was going on and VB could get at te SQL data
in a realitivly complex relational database without miles of code

Thanks in advance for any tips

Kind Regards

Andrew






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge opens multiple Access RickLM Mailmerge 1 November 7th 06 06:11 PM
Mailmerge from multiple Files Sondra Mailmerge 2 August 31st 06 12:27 PM
adding same text to multiple lines Rick Microsoft Word Help 1 July 4th 06 08:23 PM
Why does a single mouse click select multiple lines? EL3888 Microsoft Word Help 1 May 18th 06 01:41 PM
How do I get multiple Access records into a single mailmerge lett. Wiley W. Mailmerge 1 December 18th 04 05:47 PM


All times are GMT +1. The time now is 12:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Copyright 2004-2014 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.