Hello,

I am trying to do a mail merge using the data from Outlook. As I store all
my addresses there, they are not all relevant for this specific merge. All
addresses are classified using categories. However, I have not find the
option where I can filter by categories in the interface in Word.

Any idea?

Thanks

Philippe

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by categories
in the interface in Word.

Any idea?

Thanks

Philippe

Well, I follow the steps, but Word would then merge only one label (one per
page), ignoring the other one on the page (even though I have «Next Record»
in the next record entry).

"Graham Mayor" wrote:

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by categories
in the interface in Word.

Any idea?

Thanks

Philippe

You have not completed the merge. You are viewing the merge source document.
Merge to a new document or the printer.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Well, I follow the steps, but Word would then merge only one label
(one per page), ignoring the other one on the page (even though I
have «Next Record» in the next record entry).

"Graham Mayor" wrote:

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by categories
in the interface in Word.

Any idea?

Thanks

Philippe

Sure I have completed the merge. I have 24 stickers on a page. If I have more
than 24 addresses, it will create a new page, but it only displays the 1st
address on each page (I mean on the 1st page, it is merging with address 1,
on the second page, it is merging with address 25th, and so on)

"Graham Mayor" wrote:

You have not completed the merge. You are viewing the merge source document.
Merge to a new document or the printer.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Well, I follow the steps, but Word would then merge only one label
(one per page), ignoring the other one on the page (even though I
have «Next Record» in the next record entry).

"Graham Mayor" wrote:

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by categories
in the interface in Word.

Any idea?

Thanks

Philippe

Actually, this was my mistake: the following labels where not configured
correctly.

I have another question: when I select address block, I use the function:
"Format address according to the destination country/region. However, it does
not format it correctly for Switzerland, as it put the ZIP code after the
City, whereas the correct format for Switzerland is to put the ZIP before the
City. Is this possible to change this in the config?

To avoid this problem, I tried to define the labels myself using individual
fields, but I could not setup a rule to display the country for all countries
but Switzerland.

Thanks

Philippe

"Philippe" wrote:

Sure I have completed the merge. I have 24 stickers on a page. If I have more
than 24 addresses, it will create a new page, but it only displays the 1st
address on each page (I mean on the 1st page, it is merging with address 1,
on the second page, it is merging with address 25th, and so on)

"Graham Mayor" wrote:

You have not completed the merge. You are viewing the merge source document.
Merge to a new document or the printer.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Well, I follow the steps, but Word would then merge only one label
(one per page), ignoring the other one on the page (even though I
have «Next Record» in the next record entry).

"Graham Mayor" wrote:

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by categories
in the interface in Word.

Any idea?

Thanks

Philippe

You are correct to use individual fields, but it is easy enough to avoid
printing Switzerland by using a conditional field
{IF {Mergefield Country} "Switzerland" "{Mergefield Country}"} You can
enter this directly in your document in place of the Country field, using
CTRL+F9 for each field boundary pair. {}

Make the change to the first label in your source document and click the
propagate button on the mailmerge toolbar
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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


Philippe wrote:
Actually, this was my mistake: the following labels where not
configured correctly.

I have another question: when I select address block, I use the
function: "Format address according to the destination
country/region. However, it does not format it correctly for
Switzerland, as it put the ZIP code after the City, whereas the
correct format for Switzerland is to put the ZIP before the City. Is
this possible to change this in the config?

To avoid this problem, I tried to define the labels myself using
individual fields, but I could not setup a rule to display the
country for all countries but Switzerland.

Thanks

Philippe

"Philippe" wrote:

Sure I have completed the merge. I have 24 stickers on a page. If I
have more than 24 addresses, it will create a new page, but it only
displays the 1st address on each page (I mean on the 1st page, it is
merging with address 1, on the second page, it is merging with
address 25th, and so on)

"Graham Mayor" wrote:

You have not completed the merge. You are viewing the merge source
document. Merge to a new document or the printer.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Well, I follow the steps, but Word would then merge only one label
(one per page), ignoring the other one on the page (even though I
have «Next Record» in the next record entry).

"Graham Mayor" wrote:

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by
categories in the interface in Word.

Any idea?

Thanks

Philippe

Thanks for your help. This has been very useful !
Best regards,
Philippe

"Graham Mayor" wrote:

You are correct to use individual fields, but it is easy enough to avoid
printing Switzerland by using a conditional field
{IF {Mergefield Country} "Switzerland" "{Mergefield Country}"} You can
enter this directly in your document in place of the Country field, using
CTRL+F9 for each field boundary pair. {}

Make the change to the first label in your source document and click the
propagate button on the mailmerge toolbar
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm

--

Graham Mayor - Word MVP

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


Philippe wrote:
Actually, this was my mistake: the following labels where not
configured correctly.

I have another question: when I select address block, I use the
function: "Format address according to the destination
country/region. However, it does not format it correctly for
Switzerland, as it put the ZIP code after the City, whereas the
correct format for Switzerland is to put the ZIP before the City. Is
this possible to change this in the config?

To avoid this problem, I tried to define the labels myself using
individual fields, but I could not setup a rule to display the
country for all countries but Switzerland.

Thanks

Philippe

"Philippe" wrote:

Sure I have completed the merge. I have 24 stickers on a page. If I
have more than 24 addresses, it will create a new page, but it only
displays the 1st address on each page (I mean on the 1st page, it is
merging with address 1, on the second page, it is merging with
address 25th, and so on)

"Graham Mayor" wrote:

You have not completed the merge. You are viewing the merge source
document. Merge to a new document or the printer.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Well, I follow the steps, but Word would then merge only one label
(one per page), ignoring the other one on the page (even though I
have «Next Record» in the next record entry).

"Graham Mayor" wrote:

See http://www.gmayor.com/mailmerge_from_outlook.htm
Filter the view in Outlook first.

--

Graham Mayor - Word MVP

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


Philippe wrote:
Hello,

I am trying to do a mail merge using the data from Outlook. As I
store all my addresses there, they are not all relevant for this
specific merge. All addresses are classified using categories.
However, I have not find the option where I can filter by
categories in the interface in Word.

Any idea?

Thanks

Philippe