Address Labels

[J.Bennett]

I am trying to create some labels to print thank you notes. I plan to stick
these labels on the back of photo cards. I also want to print envelopes. As
such, I have created a table and corresponding querry for my information. I
planned on using WORD 2007 to print the labels and the envelopes. However,
the codes? show up on the labels. So, I tried to create lables in ACCESS.
The same thing happens when I preview the labels.

The two fields that I am using are the named "salutation" and "Note for
Cards". I have tried setting these to text fields and have tried setting
these to memo fields. However I get the same thing. Below is an example of
what I get (in both WORD and ACCESS):

<div>Thank you so much for the beautiful 4 pc. Set. Cloey will look
fantastic in this outfit!</div>

What should be displayed is:
Thank you so much for the beautiful 4 pc. Set. Cloey will look fantastic in
this outfit!

How do I get rid of the <div>, </div> and all the other garbage. Any
special character, such as quotes, double spaces, etc. all have codes.

Any help would be greatly appreciated. I would prefer using ACCESS to set
up and enter all the data, but use WORD to print the final product. I
already have the lables created in WORD that uses the ACCESS data from a
query.

Please help. I need to get these cards done!
James Bennett

P.S. I shortened all my notes to be less than 255 characters for text fields.

 

[Wayne-I-M]

Hi

Sound to me like you may have <Div> actualy in the field (have a look at the
table and see. If you "do" have this in the field then you can remove it
like this - in an update query (Make a full backup first)

Replace([TableName]![FieldName],"<div>","")

To create some address label is very simple.
You say you want this

Thank you so much for the beautiful 4 pc. Set. Cloey will look fantastic in
this outfit!

So I take it you have fields with this information
The number of orders (4 pc)
The Name (Cloey)

Use the wizard to create the lable for you using these fields.
Something like this in the report
="Thank you so much for the beautiful " & [OrderNumberField] & ". " &
[NameField] & " will look fantastic in this outfit!"

use the Page Setup to choose the mail.address lables you want (in the report
in design view)

hope this helps but if you have any problems then post back with details

good luck