How to set up a formatted output from data

[maydin]

Sorry for title, i am really bad at paraphrasing and terms.

I have data in Calc Spreadsheet, lets say column names are “Name, Phone, Adress”.

I want to prepare a text depends on data in my sheet. For example I will choose a name from dropdown and it automatically prepare text as follows:

Hello Dear NAME,

Your message has been sent to phone number PHONE and related document will be posted to this adress: ADRESS

In this text I want to specify its format too, for example boldness, font etc. Because I want to copy this to an email body or printing.

I can do something like ="Hello Dear " & A2 but I cannot change style of cell part and cannot copy to somewhere else. (It copies as table)

[erAck]

You can’t define inline text attributes in spreadsheet fomulas.

I guess you want to use Writer instead and do something like mail merge, see online help.

[maydin]

Thanks @erAck. This was what I exactly want. But there is a one thing that I cannot fix.

In Calc, I filled cell like this “- option1 <ctrl+enter> - option2”. I use this information in Writer document and it looks okay. But problem is when I want to copy texts to e-mail editor, it deletes my “newline characters”.

I cannot use bulleted/numbered lists in Calc, therefore I typed newline character by pressing Ctrl+Enter, everything okay until I copy to browser email editor.