Labels

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

Hi! I want to use the Labels wizard in Access to create
labels for mass mailing. My only problem is that I have
two address fields, Address1 and Address2. In the Query
that I use as my data source, some clients have addresses
in both fields, some have only Address1, and some have
only Address2.

I want to use the 5160 address labels which allows for
three address lines. MS Word will allow you to input two
addresses, but it will always take the first address
unless there is none given, then it will take the second
address. The output will not show two addreses even if
there are two given. Is there any way to do this in MS
ACCESS? Here are three examples that I am referring to:

This is the information that you have in the query:
ABC COMPANY
XYZ Street
P.O. Box 123
Anywhere, Anystate 12345

This is when you have an address1 or two addresses:
ABC COMPANY
XYZ Street
Anywhere, Anystate 12345

This is when you have no address1 and address two is used:
ABC COMPANY
P.O. Box 123
Anywhere, Anystate 12345

Thanks in advance you any help given!

Julie
 
Yes, this can be done in Access or in Word. I haven't done this in Word in a
while, so I couldn't talk you through it there. In Access, use the label
wizard to create the report. In the report, set the 2 Address textbox
properties AllowShrink to Yes. This will allow them to collapse down if
there isn't any data for them. Don't set the detail section to AllowShrink
because to print on labels you need to maintain a fixed size of the detail
so that everything will line up with the labels.
 
Thanks for the question Julie and Thanks Wayne for the answer! It was "a question" on my list.
 
Hi! I want to use the Labels wizard in Access to create
labels for mass mailing. My only problem is that I have
two address fields, Address1 and Address2. In the Query
that I use as my data source, some clients have addresses
in both fields, some have only Address1, and some have
only Address2.

I want to use the 5160 address labels which allows for
three address lines. MS Word will allow you to input two
addresses, but it will always take the first address
unless there is none given, then it will take the second
address. The output will not show two addreses even if
there are two given. Is there any way to do this in MS
ACCESS? Here are three examples that I am referring to:

This is the information that you have in the query:
ABC COMPANY
XYZ Street
P.O. Box 123
Anywhere, Anystate 12345

This is when you have an address1 or two addresses:
ABC COMPANY
XYZ Street
Anywhere, Anystate 12345

This is when you have no address1 and address two is used:
ABC COMPANY
P.O. Box 123
Anywhere, Anystate 12345

Thanks in advance you any help given!

Julie
Click to expand...
Julie,
I would add a new column in the query itself:
GetAddress:IIf(IsNull([Address1]),[Address2],[Address1])

Use this GetAddress field when you create the labels using the wizard.
You'll get the 1st address (if there is one) otherwise the 2nd.
 
-----Original Message-----
Hi! I want to use the Labels wizard in Access to create
labels for mass mailing. My only problem is that I have
two address fields, Address1 and Address2. In the Query
that I use as my data source, some clients have addresses
in both fields, some have only Address1, and some have
only Address2.

I want to use the 5160 address labels which allows for
three address lines. MS Word will allow you to input two
addresses, but it will always take the first address
unless there is none given, then it will take the second
address. The output will not show two addreses even if
there are two given. Is there any way to do this in MS
ACCESS? Here are three examples that I am referring to:

This is the information that you have in the query:
ABC COMPANY
XYZ Street
P.O. Box 123
Anywhere, Anystate 12345

This is when you have an address1 or two addresses:
ABC COMPANY
XYZ Street
Anywhere, Anystate 12345

This is when you have no address1 and address two is used:
ABC COMPANY
P.O. Box 123
Anywhere, Anystate 12345

Thanks in advance you any help given!

Julie
Click to expand...
Julie,
I would add a new column in the query itself:
GetAddress:IIf(IsNull([Address1]),[Address2],[Address1])

Use this GetAddress field when you create the labels using the wizard.
You'll get the 1st address (if there is one) otherwise the 2nd.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...

Hi Fred,
Thanks for your response. I just wanted to let you know
that the GetAddress worked for me in this situation. I
appreciate your time. Do you know if there is a way that
you can create a mocro to do the same as "Merge it with
Microsoft Word" or "Publish it with Microsoft Word"? It
is under Tools--> Office Links. TIA!

Thanks,
Julie
 
Back
Top