Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to use mail merge to create a list sorted by category in Word
If you paste the code in, it defintely won't work, because the field code
braces {} can't be "typed" on the keyboard. You can enter them using ctrl-F9 but bear in mind that every pair needs to be entered that way. One other thing is that this probably will not preview the way you expect because MERGESEQ only works correctly when you actually merge. Peter Jamieson "Malhyp" wrote in message ... 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 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. 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 |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to use mail merge to create a list sorted by category in W
Hi there, I cant figure how to complete this process. Going back to my first
post id be willing to pay someone if they help my through the whole process. Please let me know if anyone is interested. Cheers Malcolm "Peter Jamieson" wrote: If you paste the code in, it defintely won't work, because the field code braces {} can't be "typed" on the keyboard. You can enter them using ctrl-F9 but bear in mind that every pair needs to be entered that way. One other thing is that this probably will not preview the way you expect because MERGESEQ only works correctly when you actually merge. Peter Jamieson "Malhyp" wrote in message ... 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 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. 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 |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
How to use mail merge to create a list sorted by category in W
Despam my e-mail (remove "KillMaps") and e-mail me and I'll see what I can
do. Peter Jamieson "Malhyp" wrote in message ... Hi there, I cant figure how to complete this process. Going back to my first post id be willing to pay someone if they help my through the whole process. Please let me know if anyone is interested. Cheers Malcolm "Peter Jamieson" wrote: If you paste the code in, it defintely won't work, because the field code braces {} can't be "typed" on the keyboard. You can enter them using ctrl-F9 but bear in mind that every pair needs to be entered that way. One other thing is that this probably will not preview the way you expect because MERGESEQ only works correctly when you actually merge. Peter Jamieson "Malhyp" wrote in message ... 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 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. 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 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Mailmerge directories not working Word 2003 | Mailmerge | |||
Mail merge in Word from Outlook Catagories | Mailmerge | |||
Mail Merge to Create a List Sorted by Category | Mailmerge |