MailMerge field new line

C

crsnt

Hi,

I'm mail merging data from SQL database with Word Document.

I have a field that contains comma-delimited string (e.g Name1, Name2, Name3)

and my field name in Word is <<NameList>>

I want to turn those commas to new line so it shows:
Name1
Name2
Name3

How can I do this?

Thanks for the help,

Andreas
 
M

macropod

Hi crsnt,

The mailmerge process can't do this. You need to either change the data at the source or use Find/Replace, for example, after
completing the merge.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Some complicated merge codes 3
Mail Merge created in word 97 doesn't work in 2003 1
Q: returning "field expression" from recordset object? 2
Trouble with Fields 2
Office.Word 2003. mailmerge Create a field string for a greeting l 0
Send Email(s) by selecting users from user form 1
Listbox selections dumped to MS Word 14
insert a new record in table body 3

Top