[David]

I would like to email customer statements- how can I create a mail merge that
has different content (different qty's of invoices outstanding) to one email
address.
Query exists in access- but can only get it to mail inv by inv- and not all
inv for that customer.
--
Thanks for your help

[Graham Mayor]

See How to use mail merge to create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


David wrote:
I would like to email customer statements- how can I create a mail
merge that has different content (different qty's of invoices
outstanding) to one email address.
Query exists in access- but can only get it to mail inv by inv- and
not all inv for that customer.

[David]

Graham,
Thanks for the link however I still can't get the merge to work correctly.
In the example- where do you input the code- should it be in a macro- if so
how do you link it to the dtata source- or should it be on the word doc?- but
when I pasted it - it read it as text on the letter!?
--
Thanks for your help


"Graham Mayor" wrote:

See How to use mail merge to create a list sorted by category in Word 2002 -
http://support.microsoft.com/?kbid=294686

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


David wrote:
I would like to email customer statements- how can I create a mail
merge that has different content (different qty's of invoices
outstanding) to one email address.
Query exists in access- but can only get it to mail inv by inv- and
not all inv for that customer.

[Graham Mayor]

I don't understand what you mean by 'input the code'. The example uses merge
fields eg

{ If { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" ""}{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } { Place1 }"¶
----------------------------Page Break--------------------------------
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

which should reflect the content of your data source. You attach the data
source to the document containing the fields from the merge wizard, the
merge toolbar or the old mailmerge helper - see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

As indicated on the web page the example produces
Atlanta

Galos $3,000
Delaney $50,000
Henningsen $10,000

----------------------------Page Break-----------------------------
Houston

Johnson $8,000
Kelly $9,000
Pak $0

You need to modify that layout to suit your requirements. No-one said it
would be easy

-
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


David wrote:
Graham,
Thanks for the link however I still can't get the merge to work
correctly. In the example- where do you input the code- should it be
in a macro- if so how do you link it to the dtata source- or should
it be on the word doc?- but when I pasted it - it read it as text on
the letter!?

See How to use mail merge to create a list sorted by category in
Word 2002 - http://support.microsoft.com/?kbid=294686

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org


David wrote:
I would like to email customer statements- how can I create a mail
merge that has different content (different qty's of invoices
outstanding) to one email address.
Query exists in access- but can only get it to mail inv by inv- and
not all inv for that customer.