Address labels list
 

Where do i start to look for making an address label list

Will this list be used for Mail Merges?
If so:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

These are good places to get information.

tj

"sally" wrote:

Where do i start to look for making an address label list

Good place to start AND finish!

http://www.mvps.org/dmcritchie/excel/mailmerg.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"sally" wrote in message
...
Where do i start to look for making an address label list

From the point of view of someone charged with supporting and trouble
shooting approximately 125 mail mergers, I would caution you to add one
feature that is often neglected by Excel experts, normalize your data as much
as possible.
Break it up into first name, last name , several address fields as well as
separate city, stat and zip fields. This will allow far more flexibility in
sorting and filtering if required, although if you are using Offec 2002 or
later, you will be able to filter from the recipients list in the word mail
merge wizard, or toolbar. Normalizing may save you future headaches that
will require more sophisiticated parsing. You never know what the future of
you data requirments and uses will require.

"sally" wrote:

Where do i start to look for making an address label list

PA

I would disagree with your statement "often neglected by Excel experts".

Setting up proper fields and names is foremost in most Excel experts
instructions for mailmerge.

See these two sites for example...........

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben Excel MVP

On Sun, 19 Dec 2004 10:39:10 -0800, "PA" wrote:

From the point of view of someone charged with supporting and trouble
shooting approximately 125 mail mergers, I would caution you to add one
feature that is often neglected by Excel experts, normalize your data as much
as possible.
Break it up into first name, last name , several address fields as well as
separate city, stat and zip fields. This will allow far more flexibility in
sorting and filtering if required, although if you are using Offec 2002 or
later, you will be able to filter from the recipients list in the word mail
merge wizard, or toolbar. Normalizing may save you future headaches that
will require more sophisiticated parsing. You never know what the future of
you data requirments and uses will require.

"sally" wrote:

Where do i start to look for making an address label list

With all due respect, I must disagree with you. The example of a data source
at
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
is not normalized. Even the Mail Merge Wizard in MS Word leads the user to
a more normalized set of fields. The example you cite combines frist and
last name and also combines city, state and zip.
The heavy mailmerge user needs much flexibility in sorting, by last name, or
city or state or someother field. They are also mainly Word users and not
power users of Excel. While sorting by State in a field of combined City,
State, Zip data would be easy for you (even I can do it). an administrative
assistant, under the gun to get out 800 form letters does not have time to
learn.

For further clarification on this and other MailMerge issues, you should
refer to microsoft.public.word.mailmerge

"Gord Dibben" wrote:

PA

I would disagree with your statement "often neglected by Excel experts".

Setting up proper fields and names is foremost in most Excel experts
instructions for mailmerge.

See these two sites for example...........

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben Excel MVP

On Sun, 19 Dec 2004 10:39:10 -0800, "PA" wrote:

From the point of view of someone charged with supporting and trouble
shooting approximately 125 mail mergers, I would caution you to add one
feature that is often neglected by Excel experts, normalize your data as much
as possible.
Break it up into first name, last name , several address fields as well as
separate city, stat and zip fields. This will allow far more flexibility in
sorting and filtering if required, although if you are using Offec 2002 or
later, you will be able to filter from the recipients list in the word mail
merge wizard, or toolbar. Normalizing may save you future headaches that
will require more sophisiticated parsing. You never know what the future of
you data requirments and uses will require.

"sally" wrote:

Where do i start to look for making an address label list

PA

You are correct in your summation of the material presented at David's site.

I did not look closely enough. He does combine some fields as you point out.

Please accept apologies and thanks for your observations on this subject.

Gord

On Sun, 19 Dec 2004 16:31:01 -0800, "PA" wrote:

With all due respect, I must disagree with you. The example of a data source
at
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
is not normalized. Even the Mail Merge Wizard in MS Word leads the user to
a more normalized set of fields. The example you cite combines frist and
last name and also combines city, state and zip.
The heavy mailmerge user needs much flexibility in sorting, by last name, or
city or state or someother field. They are also mainly Word users and not
power users of Excel. While sorting by State in a field of combined City,
State, Zip data would be easy for you (even I can do it). an administrative
assistant, under the gun to get out 800 form letters does not have time to
learn.

For further clarification on this and other MailMerge issues, you should
refer to microsoft.public.word.mailmerge

"Gord Dibben" wrote:

PA

I would disagree with your statement "often neglected by Excel experts".

Setting up proper fields and names is foremost in most Excel experts
instructions for mailmerge.

See these two sites for example...........

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm

Gord Dibben Excel MVP

On Sun, 19 Dec 2004 10:39:10 -0800, "PA" wrote:

From the point of view of someone charged with supporting and trouble
shooting approximately 125 mail mergers, I would caution you to add one
feature that is often neglected by Excel experts, normalize your data as much
as possible.
Break it up into first name, last name , several address fields as well as
separate city, stat and zip fields. This will allow far more flexibility in
sorting and filtering if required, although if you are using Offec 2002 or
later, you will be able to filter from the recipients list in the word mail
merge wizard, or toolbar. Normalizing may save you future headaches that
will require more sophisiticated parsing. You never know what the future of
you data requirments and uses will require.

"sally" wrote:

Where do i start to look for making an address label list