[malhyp]

Hi there I have a database which I am mail merging from and then emailing the

results. The problem I have is that each client listed in the database has 5
results. An example of the end result in the database would be something like

this.

idResult idCategory idSupplier idProduct idEmail
1 Flowers Flower Shop Red Flowers
2 Trees Flower Shop Blue Trees
3 Flowers Flower Shop Pink Flowers
4 Shrubs Flower Shop Pink Shrubs
5 Shrubs Flower Shop Blue Shrubs

When I create the mail merge it creates a seperate email for each result, so
if I have 10 customers it creates 50 emails.

I beleive that the Microsoft Help file called "How to use mail merge to
create a list sorted by category in Word" is the way for me to go, but I dont

understand the whole process.

http://support.microsoft.com/kb/211303/

a) To test the idea I created a database called db1.mdb in Access and then
named the following.

Primary Key: id
Field City
Field Employee
Filed Sales
Field Category

I then started up word to create a letter, started mail merge, then looked
up the database when asked for. Then I pasted the following into the Word
document.

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" "" }{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } { Place1 }"¶
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Then clicked NEXt to view the document and of course nothing happens.

Can someone give me some pointers on what I need to do to get this happening.


Have been trying to sort this mail merge issue for months now.

TA
Mally

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200702/1

[Graham Mayor]

Read the answer to the same question you posted less than an hour ago - and
have some patience. It can take several hours to get a response.

--

Graham Mayor - Word MVP

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


malhyp wrote:
Hi there I have a database which I am mail merging from and then
emailing the

results. The problem I have is that each client listed in the
database has 5 results. An example of the end result in the database
would be something like

this.

idResult idCategory idSupplier idProduct idEmail
1 Flowers Flower Shop Red Flowers
2 Trees Flower Shop Blue Trees
3 Flowers Flower Shop Pink Flowers
4 Shrubs Flower Shop Pink Shrubs
5 Shrubs Flower Shop Blue Shrubs

When I create the mail merge it creates a seperate email for each
result, so if I have 10 customers it creates 50 emails.

I beleive that the Microsoft Help file called "How to use mail merge
to create a list sorted by category in Word" is the way for me to go,
but I dont

understand the whole process.

http://support.microsoft.com/kb/211303/

a) To test the idea I created a database called db1.mdb in Access and
then named the following.

Primary Key: id
Field City
Field Employee
Filed Sales
Field Category

I then started up word to create a letter, started mail merge, then
looked up the database when asked for. Then I pasted the following
into the Word document.

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" "" }{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } { Place1 }"¶
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE
} { MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Then clicked NEXt to view the document and of course nothing happens.

Can someone give me some pointers on what I need to do to get this
happening.


Have been trying to sort this mail merge issue for months now.

TA
Mally

[Peter Jamieson]

You should be able to see my reply to your previous post by now.

Peter Jamieson

"malhyp" u16552@uwe wrote in message news:6d5a679705db3@uwe...
Hi there I have a database which I am mail merging from and then emailing
the

results. The problem I have is that each client listed in the database has
5
results. An example of the end result in the database would be something
like

this.

idResult idCategory idSupplier idProduct idEmail
1 Flowers Flower Shop Red Flowers
2 Trees Flower Shop Blue Trees
3 Flowers Flower Shop Pink Flowers
4 Shrubs Flower Shop Pink Shrubs
5 Shrubs Flower Shop Blue Shrubs

When I create the mail merge it creates a seperate email for each result,
so
if I have 10 customers it creates 50 emails.

I beleive that the Microsoft Help file called "How to use mail merge to
create a list sorted by category in Word" is the way for me to go, but I
dont

understand the whole process.

http://support.microsoft.com/kb/211303/

a) To test the idea I created a database called db1.mdb in Access and then
named the following.

Primary Key: id
Field City
Field Employee
Filed Sales
Field Category

I then started up word to create a letter, started mail merge, then looked
up the database when asked for. Then I pasted the following into the Word
document.

{ IF { MERGESEQ } = "1" "{ MERGEFIELD CITY }¶
" "" }{ SET Place1 { MERGEFIELD CITY }}¶
{ If { Place2 } { Place1 }"¶
{ MERGEFIELD CITY }¶
¶
{ MERGEFIELD EMPLOYEE } { MERGEFIELD SALES }" "{ MERGEFIELD EMPLOYEE } {
MERGEFIELD SALES }" }{ SET Place2 { MERGEFIELD CITY }}¶

Then clicked NEXt to view the document and of course nothing happens.

Can someone give me some pointers on what I need to do to get this
happening.


Have been trying to sort this mail merge issue for months now.

TA
Mally

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...merge/200702/1