 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2007Word 2007 Address Block and Suppress Blank Lines
I have several difficulties with Word 2007 and Merging The Address Block when merged prints in 1.5 line spacing I can't make it print single space. I can't map the fields correctly because we use Prefix Fname LName Suffix BusinessTitle Company Addr1 Addr2 City State Zip fields in my data. The mapping choices don't accompdate this many fields (at least I can't see any way to map and get the address block to display progerly) I can't find anywhere/way to suppress blank fields (addr2) if I build my own address block manually in the document. I did see one post about using VisualBasic but I'm an enduser not a programmer. Thanks John Don't use teh Address Block. Just insert the individual merge fields that you want to use in the configuration that you want them.  SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP >I have several difficulties with Word 2007 and Merging > The Address Block when merged prints in 1.5 line spacing I can't make it [quoted text clipped - 11 lines] > Thanks > John Thanks Doug, I've done that. I build an address from my data fields. The addr2 field is often empty (I'm exporting from a sql data file into excel and the field as best as I can see is blank/empty when there is no actual second line of address). Perhaps I was not clear? When there is nothing in addr2 I get a blank line between addr1 and the city st zip line. Same thing happens when the businesstitle is blank, I get a blank line between fname lname and company. How do I tell the merge filed to suppress if there is no data in it? Thise seemed to happen automatically in 2000. Thanks John > Don't use teh Address Block. Just insert the individual merge fields that > you want to use in the configuration that you want them. [quoted text clipped - 14 lines] > > Thanks > > John You will need to use and If...then...Else field construction. There are numerous posts in this newsgroup that contain examples of such constructions. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Thanks Doug, I've done that. I build an address from my data fields. The > addr2 field is often empty (I'm exporting from a sql data file into excel [quoted text clipped - 36 lines] >> > Thanks >> > John Thanks again Doug, I guess I just don't see the forest for the trees? I 've looked through post of if else but don't see any pertaining to skipping a blank field. All the examples I see skip / move on to the next record. I've tried several search variations but come up blank (pun intented :) ) If anyone knows of such a post example I'd appreciate a heads up and/or where on the MS help docs this might be addressed? Thanks John > You will need to use and If...then...Else field construction. There are > numerous posts in this newsgroup that contain examples of such [quoted text clipped - 40 lines] > >> > Thanks > >> > John See the post "Problems with IF statement" started by Joe Di Giulio on 11/8/2007 that was hijacked by Briza on 11/9/2007 to which both I and Graham Mayor responded. SignatureHope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Thanks again Doug, I guess I just don't see the forest for the trees? I > 've [quoted text clipped - 62 lines] >> >> > Thanks >> >> > John Doug, Thanks a million. This is exactly what I needed. Joes D's post flows exactly as I would have struggled with the process. Really great help -Thanks again John > See the post "Problems with IF statement" started by Joe Di Giulio on > 11/8/2007 that was hijacked by Briza on 11/9/2007 to which both I and Graham [quoted text clipped - 66 lines] > >> >> > Thanks > >> >> > John OK I spoke too soon. I found the post and examples of what I wnt to do but I don't know how/where to writ the if statement? If I do it in the doc it's just text. If I do in in the rule tool I can't figure out how to add the merge fields? Why did MS Office 2007 do away with the suppress blank line check box? Thanks John > Doug, Thanks a million. This is exactly what I needed. Joes D's post flows > exactly as I would have struggled with the process. [quoted text clipped - 71 lines] > > >> >> > Thanks > > >> >> > John > Why did MS Office 2007 do away with the suppress blank line check box? It didn't - the mail merge helper which is still available in 2007, provides this option. How well it works in 2007 I hesitate to say - but it hasn't been removed. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>><<> Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org <>>< ><<> ><<> <>>< ><<> <>>< <>><<> John, You can change the line spacing by selecting the fields and using the Word 2007 Home/Paragraph option. The suppress blank lines should be an option of the AddressBlock field but for some reason Word 2007 has taken a step backward. Putting in the individual fields is not the same as using the AddressBlock as it includes foreign country address reformatting and local country supression. Also, suggesting using IF is not an option for an end user and I have had problems with the MailMergeHelper macro. My conclusion is that an end user cannot use Word 2007 to print labels correctly. I am happy to be corrected as I have been trying to do the same thing myself. In the end I printed the labels with blank lines. Laurence > I have several difficulties with Word 2007 and Merging > The Address Block when merged prints in 1.5 line spacing I can't make it [quoted text clipped - 9 lines] > Thanks > John |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.