| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Multiple Elements
I need to send a message with that list unique iteams for each name. For
example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Hi Lindsey,
What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Hi Lindsey,
You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
So, tried this and it won't give me the name, but it will give me the iteam
after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Did you enter /all/ the pairs of {} using ctrl-F9 ? You can't just type
them on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Lindsey wrote: So, tried this and it won't give me the name, but it will give me the iteam after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Hi Lindsey,
Are you sure you got the field coding syntax correct? It appears the field coding you've posted is a copy of the coding suggested at: http://support.microsoft.com/kb/294686/, without being modified to suit your needs. What is the actual coding in your document? There's a macro for copying them to the clipboard at: http://www.gmayor.com/export_field.htm. The fields from the Microsoft article (which I deliberately didn't refer you to) aren't as easy to use as those in my mailmerge tutorial - which are already fully coded and ready for use. Plus, even once you've got the fields from the Microsoft article working, you won't be any better off regarding your email requirement. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... So, tried this and it won't give me the name, but it will give me the iteam after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Yes, I used ctrl-F9.
"Peter Jamieson" wrote: Did you enter /all/ the pairs of {} using ctrl-F9 ? You can't just type them on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Lindsey wrote: So, tried this and it won't give me the name, but it will give me the iteam after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Yes, I did look at the tutorial you suggested and I did not understand what
you are suppose to type into the blank word document, this is why I copied the other example. I did change some of the words in the example to fit my spread sheet. I was going to cut and paste these into the emails. I just want it to be: Dear Name, Message Iteam Quantity Date Iteam Quantity Date Iteam Quantity Date The number of iteams will change for each person. Thanks again! "macropod" wrote: Hi Lindsey, Are you sure you got the field coding syntax correct? It appears the field coding you've posted is a copy of the coding suggested at: http://support.microsoft.com/kb/294686/, without being modified to suit your needs. What is the actual coding in your document? There's a macro for copying them to the clipboard at: http://www.gmayor.com/export_field.htm. The fields from the Microsoft article (which I deliberately didn't refer you to) aren't as easy to use as those in my mailmerge tutorial - which are already fully coded and ready for use. Plus, even once you've got the fields from the Microsoft article working, you won't be any better off regarding your email requirement. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... So, tried this and it won't give me the name, but it will give me the iteam after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
I have also entered exactly the same fields here and the merge does
function. Whether it will give you want you want is another question. As an example, it doesn't appear to have done its job, so I'd stick with trying to make macropod's tutorial work for you. Peter Jamieson http://tips.pjmsn.me.uk Lindsey wrote: Yes, I used ctrl-F9. "Peter Jamieson" wrote: Did you enter /all/ the pairs of {} using ctrl-F9 ? You can't just type them on the keyboard. Peter Jamieson http://tips.pjmsn.me.uk Lindsey wrote: So, tried this and it won't give me the name, but it will give me the iteam after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
|
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Multiple Elements
Hi Lindsey,
Perhaps you should re-read the Introduction, especially the bit under the Heading "Using the Sample Data File & Mailmerge Main Document". -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... Yes, I did look at the tutorial you suggested and I did not understand what you are suppose to type into the blank word document, this is why I copied the other example. I did change some of the words in the example to fit my spread sheet. I was going to cut and paste these into the emails. I just want it to be: Dear Name, Message Iteam Quantity Date Iteam Quantity Date Iteam Quantity Date The number of iteams will change for each person. Thanks again! "macropod" wrote: Hi Lindsey, Are you sure you got the field coding syntax correct? It appears the field coding you've posted is a copy of the coding suggested at: http://support.microsoft.com/kb/294686/, without being modified to suit your needs. What is the actual coding in your document? There's a macro for copying them to the clipboard at: http://www.gmayor.com/export_field.htm. The fields from the Microsoft article (which I deliberately didn't refer you to) aren't as easy to use as those in my mailmerge tutorial - which are already fully coded and ready for use. Plus, even once you've got the fields from the Microsoft article working, you won't be any better off regarding your email requirement. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... So, tried this and it won't give me the name, but it will give me the iteam after the name then it stops. It then says "Error! Missing test condition." I have entered it exactly as the Microsoft tutorial had it. { 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 }}¶ Does this need to be modified? Thanks for your help! "macropod" wrote: Hi Lindsey, You can't use this to merge to email but, once merged, you can copy & paste the relevant outputs into the emails. Alternatively, you could automate the merge & email process with vba. -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I actually tried this but stopped because there was a page break. Will this work with emails? Thanks "macropod" wrote: Hi Lindsey, What you need is a Catalogue/Directory Mailmerge. To see how to do this kind of mailmerge, check out my Word 97-2007 Catalogue/Directory Mailmerge Tutorial at: http://www.wopr.com/index.php?showto...#entry731 107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it -- Cheers macropod [MVP - Microsoft Word] "Lindsey" wrote in message ... I need to send a message with that list unique iteams for each name. For example, my spreadsheet has a name column, email, and the type of product they purchased. However, some clients purchased more than one product and the number of products purchased varies by each client. The spreadsheet I have list each unique product bought with the name of the client and email. I do not want to send each client an email for each iteam they bought, I want to send an email with a list of all the iteams they purchased. Does anyone know how you do this? Thanks!!! |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to fix elements on a page? | Microsoft Word Help | |||
| I need to edit elements in a theme | Microsoft Word Help | |||
| Updating common elements across multiple documents | New Users | |||
| Dynamically Placing Elements | Page Layout | |||
| Dynamically Placing Elements | Page Layout | |||
Linear Mode
