RichText merge bug (Delphi 2007, RB Ent 12.05)

rbuser

RichText box has the following text:

Company
Name
Address
City, State Zip
Phone: Phone

Everything gets merged correctly when the Addres field has 1 or 2 lines of
text.
When the address is 3+ lines long it gets merged properly, however, all
other fields are not getting merged anymore so I get something like this

ABC Company
John Smith
XYZ Convention Center
123 Main St
Hall C
City, State Zip
Phone: Phone

I have to replace Address with something like #Address# and
replace it with the actual address in OnMailMerge event handler to fix this
problem.
Any idea why this happens and how to fix it?

nicocizik

Hi Gary,

The mailmerge feature is not designed to handle multi-line data types.
I'm actually surprised two lines functions correctly. Is the address
field a Memo type or are there just CRLF characters inside a text field?

rbuser

Hi Nico,
The Address field is a memo type field. I've never had any issues with mail
merging memo type fields with multiple lines except in this particular case.
Had no idea about such limitation.
So what is the proper way of displaying such address block and making sure
everyting gets lined up properly - use memo field for the address and mail
merge city, state, zip fields using richtext field and shifting it relative
to address field?

nicocizik

Hi Gary,

I believe memo fields should be supported. I made some quick tests
using the DBDEMOS database and the biolife table and was able to
successfully merge the notes field and numerous fields below that. If
possible, please send an example that demonstrates this issue that I can
run on my machine in .zip format to support@digital-metaphors.com and
I'll take a look at what is happening.