 |
 | 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 / January 2004Add a line feed if the value of a field is 1
I am using MS Access 2000 to open MS Word 2000 by automation. What I am looking for right now is a way to add a line feed to the merge document if the value of one of the fields sent by Access is 1. I can see where, if I had some kind of code for a line feed that wouldn't print as text, I might be able to use the Insert Word Field, If then else. What I am looking to do is make Word put in a blank line if the length of the field is going to be less than one line. I think I could have a field in Access that could alert the mailmerge document that a new line was needed. All I need is a way to make the mailmerge document do a carriage return at the end of the previous line. Any ideas on how I can do this? dixie You shouldn't need a special code. What you do is simply insert an actual line feed within your IF field. E.g. { IF { MERGEFIELD needlinefeed } = 1 " " "" } -- Peter Jamieson - Word MVP Word MVP web site http://www.mvps.org/word > I am using MS Access 2000 to open MS Word 2000 by automation. What I am > looking for right now is a way to add a line feed to the merge document if [quoted text clipped - 10 lines] > > dixie When I do this Peter, what comes out after the merge is 3 " marks on one line, followed by 3 on the next line. Like the following. " "" " "" It is obviously doing the line feed as there is a 2nd line, but the Quote marks are also coming out. I probably should add that this is inside a table cell in a table. dixie > You shouldn't need a special code. What you do is simply insert an actual > line feed within your IF field. E.g. [quoted text clipped - 20 lines] > > > > dixie Actually, I have just worked out (I think) that you have to do a shift enter, although I am unsure of the reason. dixie > When I do this Peter, what comes out after the merge is 3 " marks on one > line, followed by 3 on the next line. Like the following. [quoted text clipped - 36 lines] > > > > > > dixie FWIW I don't get this here, whether I use enter (a paragraph mark) or shift-enter (a line break). Although you seem to have worked around the problem anyway, if you want, despam my e-mail address, send me a copy of your .doc and I'll have a look at it here. -- Peter Jamieson - Word MVP Word MVP web site http://www.mvps.org/word > When I do this Peter, what comes out after the merge is 3 " marks on one > line, followed by 3 on the next line. Like the following. [quoted text clipped - 36 lines] > > > > > > dixie |
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.