Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge
I tried to complete a mail merge from an excel spreadsheet to a Word 2003
envelope. Each entry has a space before the first letter of the first word. I can't seem to remove it with out going through each individual envelope after completing the merge and deleting it. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge
Are you using ADDRESSBLOCK?
If so, then for example, if you chose the Mr. Josh Q. Randall Jr. layout and the title (Mr.) and "Nickname" (Josh) are either blank or not matched, the layout will stil insert a space before the "Q.". IN essence, the layout expects there to be either a title or a nickname. Incidentally, if there is a title, no nickname, and a "middle name" you will get Mr. Q. Randall Jr. (i.e. two spaces before the Q). You can either try reinserting your ADDRESSBLOCK with a different layout that matches your data better, or use individual merge fields instead - see Graham Mayor's pages at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm and http://www.gmayor.com/formatting_word_fields.htm Peter Jamieson "Candice" wrote in message ... I tried to complete a mail merge from an excel spreadsheet to a Word 2003 envelope. Each entry has a space before the first letter of the first word. I can't seem to remove it with out going through each individual envelope after completing the merge and deleting it. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
mail merge
THANK YOU!! That solved the problem. My supervisor says to tell you we love
you haha! But thanks again for describing the reasoning behind it not just telling me what to do. We understand why it was adding the space now. "Peter Jamieson" wrote: Are you using ADDRESSBLOCK? If so, then for example, if you chose the Mr. Josh Q. Randall Jr. layout and the title (Mr.) and "Nickname" (Josh) are either blank or not matched, the layout will stil insert a space before the "Q.". IN essence, the layout expects there to be either a title or a nickname. Incidentally, if there is a title, no nickname, and a "middle name" you will get Mr. Q. Randall Jr. (i.e. two spaces before the Q). You can either try reinserting your ADDRESSBLOCK with a different layout that matches your data better, or use individual merge fields instead - see Graham Mayor's pages at http://www.gmayor.com/mail_merge_lab...th_word_xp.htm and http://www.gmayor.com/formatting_word_fields.htm Peter Jamieson "Candice" wrote in message ... I tried to complete a mail merge from an excel spreadsheet to a Word 2003 envelope. Each entry has a space before the first letter of the first word. I can't seem to remove it with out going through each individual envelope after completing the merge and deleting it. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. | Mailmerge | |||
collate pages in mail merge vs mail merge being single document | Mailmerge | |||
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe | Microsoft Word Help | |||
mail merge doc with further linked/embedded mail merge docs not playing the game | Mailmerge |