I am using OO v 2.0.3 on Linux (Debian). I want to do an email merge with an 
html email document. I have 2 fields in a spreadsheet - a name, and email 
address, and a unique member_id for each name. The unique member+id goes into 
a link to a web page like this:

<a href="http://my.server.com/vote.jsp?id=member_id";>click this link</a>.

My problem is getting the html part to work. I can send a plain text email 
with the fields properly inserted into the email. But, I want to format using 
html and "hide" the member_id in an html link. Why - the member_id is very 
long, and it spans more than one line. In the plain text email the user 
cannot click on the link because it spans 2 lines. Copy/Paste is possible, 
but difficult given the length of the url.

What I have tried -

1. Create an html page in Writer. However, one cannot insert user fields into 
an html page in the composer. Also, there is no mail merge option under Tools 
when composing in html.

2. Compose the document in Writer. I can add a link in writer, but I cannot 
put a user field into the link.

3. View the html source and copy it to a new Writer document. Paste as plain 
text. Now I can insert the fields into the document, including the link. 
However, if I now do the email merge, I can either send the document as plain 
text or html. Neither one delivers an html email to my inbox. The plain text 
email has the wrong content-type - text/plain. If I send using the html 
option, the content-type is correct, but all the html tags are url encoded. 
For example:

The original document has this html line:
<P ALIGN=CENTER STYLE="margin-bottom: 0in"><B>A Proposal to Advance
the Date of the Annual Meeting</B></P>

The email has this for the same line:
<P STYLE="margin-bottom: 0in">&lt;P ALIGN=CENTER
STYLE=&quot;margin-bottom: 0in&quot;&gt;&lt;B&gt;A Proposal to
Advance</P>

Note that the <P ALIGN=CENTER STYLE="margin-bottom: 0in"><B> tags in the 
original are transformed into &lt;P ALIGN=CENTER
STYLE=&quot;margin-bottom: 0in&quot;&gt;&lt;B&gt; in the email - everything 
has been url encoded so the original html tags are lost.

How can I do an email merge with an html document?

Thanks!
-- 
Mark

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to