M
Malhyp
Hi there I have a database which I am mail merging from and then emailing the
results. The rroblem 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 (e-mail address removed)
2 Trees Flower Shop Blue Trees (e-mail address removed)
3 Flowers Flower Shop Pink Flowers (e-mail address removed)
4 Shrubs Flower Shop Pink Shrubs (e-mail address removed)
5 Shrubs Flower Shop Blue Shrubs (e-mail address removed)
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.
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
results. The rroblem 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 (e-mail address removed)
2 Trees Flower Shop Blue Trees (e-mail address removed)
3 Flowers Flower Shop Pink Flowers (e-mail address removed)
4 Shrubs Flower Shop Pink Shrubs (e-mail address removed)
5 Shrubs Flower Shop Blue Shrubs (e-mail address removed)
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.
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