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
Trouble with Fields 2
Q: returning "field expression" from recordset object? 2
Access to Word: Salutation line 2
Word Mail Merge Formatting Issue Font Size 0
Insert files (pdf, word doc) in excel cell 1
insert a new record in table body 3
A two field, flat table, SQL question? 2

Top