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
|
|||
|
|||
Mail merge field size
I'm having trouble with the whole field prining on some entries. I have
addresses up to 30 positions. Some only display 15 characters and then end with a "dash" other display up to 25 characters, so I know font size is not the solution. Excel is the data source, and the field is defined as text. Using the len built in function in Excel gives correct field lengths. Both Excel and Publisher are 2003. Any Ideas? Thanks, Lee |
#2
|
|||
|
|||
Mail merge field size
Expand the merge text box. Scroll through the entries in Step 4 of the merge
wizard, adjust the text box(es) so all the entries fit. I have no idea what the "dash" means, it could have something to do with the entry contents. I do know if there is overflow the overflow icon is shown on the merge text box. -- Mary Sauer http://msauer.mvps.org/ "Lee Hunter" wrote in message ... I'm having trouble with the whole field prining on some entries. I have addresses up to 30 positions. Some only display 15 characters and then end with a "dash" other display up to 25 characters, so I know font size is not the solution. Excel is the data source, and the field is defined as text. Using the len built in function in Excel gives correct field lengths. Both Excel and Publisher are 2003. Any Ideas? Thanks, Lee |
#3
|
|||
|
|||
Mail merge field size
I have just imported the Excel file into an Access DB and repeated the
Publisher mail merge with exactly the same results. So rule out that option. "Lee Hunter" wrote: I'm having trouble with the whole field prining on some entries. I have addresses up to 30 positions. Some only display 15 characters and then end with a "dash" other display up to 25 characters, so I know font size is not the solution. Excel is the data source, and the field is defined as text. Using the len built in function in Excel gives correct field lengths. Both Excel and Publisher are 2003. Any Ideas? Thanks, Lee |
#4
|
|||
|
|||
Mail merge field size
Are you getting an error message? Do you think it could have to do with the
amount of entries? There was a registry fix that addressed batch size. The Registry Fix for changing the Mail Merge Batch Size Courtesy of KATMA http://ed.mvps.org/Static.aspx?=Publisher/registryfix -- Mary Sauer http://msauer.mvps.org/ "Lee Hunter" wrote in message news I have just imported the Excel file into an Access DB and repeated the Publisher mail merge with exactly the same results. So rule out that option. "Lee Hunter" wrote: I'm having trouble with the whole field prining on some entries. I have addresses up to 30 positions. Some only display 15 characters and then end with a "dash" other display up to 25 characters, so I know font size is not the solution. Excel is the data source, and the field is defined as text. Using the len built in function in Excel gives correct field lengths. Both Excel and Publisher are 2003. Any Ideas? Thanks, Lee |
#5
|
|||
|
|||
Mail merge field size
Thanks, Mary.
Increasing the size of the text box made no difference. The result is the same. I aslo did decrease the font size, significantly, with no effect. Here's what I meant about the dash. 1234 Same street would appear in full, but 1234 Any street would appear as 1234 Any str- So sometimes, the longer address appears in full, while the shorter one is truncated. Any further thoughts? "Mary Sauer" wrote: Expand the merge text box. Scroll through the entries in Step 4 of the merge wizard, adjust the text box(es) so all the entries fit. I have no idea what the "dash" means, it could have something to do with the entry contents. I do know if there is overflow the overflow icon is shown on the merge text box. -- Mary Sauer http://msauer.mvps.org/ "Lee Hunter" wrote in message ... I'm having trouble with the whole field prining on some entries. I have addresses up to 30 positions. Some only display 15 characters and then end with a "dash" other display up to 25 characters, so I know font size is not the solution. Excel is the data source, and the field is defined as text. Using the len built in function in Excel gives correct field lengths. Both Excel and Publisher are 2003. Any Ideas? Thanks, Lee |
#6
|
|||
|
|||
Mail merge field size
There is a 255 character limit in merge fields; if your field goes over this
limit it will be truncated. You would have to setup two fields. -- Mary Sauer http://msauer.mvps.org/ "Lee Hunter" wrote in message ... Thanks, Mary. Increasing the size of the text box made no difference. The result is the same. I aslo did decrease the font size, significantly, with no effect. Here's what I meant about the dash. 1234 Same street would appear in full, but 1234 Any street would appear as 1234 Any str- So sometimes, the longer address appears in full, while the shorter one is truncated. Any further thoughts? "Mary Sauer" wrote: Expand the merge text box. Scroll through the entries in Step 4 of the merge wizard, adjust the text box(es) so all the entries fit. I have no idea what the "dash" means, it could have something to do with the entry contents. I do know if there is overflow the overflow icon is shown on the merge text box. -- Mary Sauer http://msauer.mvps.org/ "Lee Hunter" wrote in message ... I'm having trouble with the whole field prining on some entries. I have addresses up to 30 positions. Some only display 15 characters and then end with a "dash" other display up to 25 characters, so I know font size is not the solution. Excel is the data source, and the field is defined as text. Using the len built in function in Excel gives correct field lengths. Both Excel and Publisher are 2003. Any Ideas? Thanks, Lee |
Thread Tools | |
Display Modes | |
|
|