If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Address Labels
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): divThank 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. |
#2
|
|||
|
|||
Address Labels
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 -- Wayne Manchester, England. "J.Bennett" wrote: 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): divThank 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. |
Thread Tools | |
Display Modes | |
|
|