Multiple Elements

[Lindsey]

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!!!

 

[macropod]

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

 

[Lindsey]

I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]

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!!!

 

[macropod]

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]

I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]

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!!!

 

[Lindsey]

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!

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]

I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!

 

[Peter Jamieson]

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

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!

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]

I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

:

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!

 

[macropod]

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]

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!

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]

I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

:

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!

 

[Lindsey]

Yes, I used ctrl-F9.

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

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!

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]


I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

:

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!

 

[Lindsey]

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!

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]

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!

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]


I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

:

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!

 

[Peter Jamieson]

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

Yes, I used ctrl-F9.

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

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!

:

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]


I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

:

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!

 

[macropod]

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]

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!

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]

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!

:

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]


I actually tried this but stopped because there was a page break. Will this
work with emails? Thanks

:

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?showtopic=731107&st=0&p=731107&#entry731107
or
http://www.gmayor.com/Zips/Catalogue Mailmerge.zip
Do read the tutorial before trying to use the mailmerge document included with it

--
Cheers
macropod
[MVP - Microsoft Word]


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!!!