# Email-Collector Variables

**URL:** <https://www.dolibarr.org/forum/t/email-collector-variables/24206>\
**Category:** CRM/SRM Modules\
**Tags:** Email-Collector\
**Created:** [August 25, 2023, 8:52pm UTC](https://www.dolibarr.org/forum/t/email-collector-variables/24206 "2023-08-25T20:52:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mikeemike7](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/df788c/32.png) [@mikeemike7](https://www.dolibarr.org/forum/u/mikeemike7)\
**Post date:** [August 25, 2023, 8:52pm UTC](https://www.dolibarr.org/forum/t/email-collector-variables/24206/1 "2023-08-25T20:52:09Z")

</div>

Good evening!

Does anyone know what **variables** the email-collector supports?

I want to create leads **AND** contacts from emails.  
In the text of the lead mail is a table:

- First name
- Surname
- Mail
- phone
- ZIP
- messages
- GDPR

A lead is automatically created (works fine), but I want dolibarr automatically create a contact with the Data, too (first name, last name, mail and phone).

**Does anybody have an idea how this works?**

Best regards,  
Mike

(using dolibarr 18.0.0, php 8.1.x, Mails in html-style from typo3 cms)

---

<div class="post-metadata">

**Author:** ![mikeemike7](https://www.dolibarr.org/forum/letter_avatar_proxy/v4/letter/m/df788c/32.png) [@mikeemike7](https://www.dolibarr.org/forum/u/mikeemike7)\
**Post date:** [August 26, 2023, 10:53pm UTC](https://www.dolibarr.org/forum/t/email-collector-variables/24206/2 "2023-08-26T22:53:39Z")

</div>

I’m using this Variables:  
tmp\_from=EXTRACT:HEADER:^From:(._);  
tmp\_subject=EXTRACT:HEADER:^Subject:(._);  
usage\_opportunity=SET:1;  
socid=SETIFEMPTY:1;  
description=EXTRACT:BODY:(.\*);  
title=SET: **tmp\_subject** from **tmp\_from** by Mail

Formaly it woked several times but now I get the following error advice:

> Failed to create project: Cannot add or update a child row: a foreign key constraint fails (`d03dad2f`.`llx_projet`, CONSTRAINT `fk_projet_fk_soc` FOREIGN KEY (`fk_soc`) REFERENCES `llx_societe` (`rowid`))
