A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Carriage Return in Word for a Mail Merge Field



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old July 15th, 2004, 08:44 PM
BuzzMaster
external usenet poster
 
Posts: n/a
Default Carriage Return in Word for a Mail Merge Field

I have a web application built in Cold Fusion that generates a listing of books for each student in the school. The school wants to generate a mailing through Word for these book lists. The number of books varies for each student. I currently determine the student with the most number of books and then dynamically generate fields for book titles, equalling this total number. I then generate a record for each student where the titles are loaded sequentially in each field until there are no more titles, and then I load a blank character into each subsequant field up to the max number of titles.

This data is then saved a a .txt file to use as my data source for the mail merge. Each field is double quoted and separated by commas.

I then have to create a Word template with the right number of fields to merge into.

What I would like to do is load each title into a list under 1 field name. I then want the field to insert the list into the mail merge document. I want to issue a CR LF after each title. What needs to be a part of the text in the field supplying all of the Titles which causes a carriage return after each title.

I can generate this text from cold fusion as I build the data, if only I new what the appropriate characters should be.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel merge to Word Footer displays merge field Justine Mailmerge 7 June 23rd, 2004 10:44 AM
Zeros in empty mail merge field instead of just closing up P. J. Mailmerge 2 May 28th, 2004 04:27 PM
word error mac General Discussions 1 May 6th, 2004 08:14 AM
mail merge w/ word and excel jmorris Mailmerge 3 May 5th, 2004 03:36 PM
Word 2003 is adding duplicate records to my mail merge Doug Robbins - Word MVP Mailmerge 0 April 24th, 2004 03:58 AM


All times are GMT +1. The time now is 02:00 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.