En cours

Complex OpenOffice Mail Merge Template Letter & Envelope

I am mailing a letter to constituents about a political campaign. I have the letter written up and the names and addresses in a spreadsheet, both in OpenOffice. I have not attached the files to the project because they contain private information so I will not upload them until I have selected a bidder.

Doing the mail merge is too complicated for me because sometimes the letter goes to a married couple, and sometimes to a single person. My address spreadsheet contains "firstnameM" and "firstnameF."

If both firstnameM and firstnameF contain data, I need the envelope line 1 to read " <firstnameM> & <firstnameF> <lastname>." The letter template greeting would read "Dear Mr. & Mrs. <lastname>."

If only firstnameM contains data, I need the envelope line 1 to read "<firstnameM> <lastname>." The letter template greeting would read "Dear Mr. <lastname>."

If only firstnameF contains data, I need the envelope line 1 to read "<firstnameF> <lastname>." The letter template greeting would read "Dear Ms. <lastname>." The "Ms." is important since I wouldn't know her marital status.

Compétences : PHP, Architecture Logicielle

Voir plus : mail merge complicated letter template, openoffice mail merge template, openoffice project, a letter c and letter t, political campaign, my mail, mrs, merge data, mail merge, envelope , data merge, complex project, spreadsheet template, merge mail, mailing merge, data merge project, merge data files spreadsheet, single spreadsheet, merge data spreadsheet, php read attached files, software template, php read mail, spreadsheet upload php, php data upload software, merge project

Concernant l'employeur :
( 17 commentaires ) Pierre, United States

N° du projet : #1626116

Décerné à :

Nhcuong

Hi, I can help. It's very easy! please check the PMB for detail!

30 $ USD en 0 jours
(5 Commentaires)
3.6

3 freelance ont fait une offre moyenne de 137 $ pour ce travail

persistent

Hello, im highly interested in your project and im sure i can do this . Let's start now. Thanks.

160 $ USD en 3 jours
(31 Commentaires)
5.0
Malachinfotech

PLEASE CHECK PMB

220 $ USD en 5 jours
(0 Commentaires)
0.0