# Emailing XML output

&#x20;Many councils use Google (cloud) environments where the easiest way to get a file into their environment is via email.&#x20;

To that end we have enhanced our email functionality such that:

a) IF a form has XML mapped for it using eMapper

b) It can be attached to the email that gets sent to the council upon submission

&#x20;

Using tools in Google and things like Microsoft Flow where the inbox is Outlook, it is possible to interrogate the attachment and push them into Google Sheets/Microsoft Excel respectively.&#x20;

This could be useful if you want all of the application data in a form to become a row in a spreadsheet for example.&#x20;

&#x20;

#### Functionality

This functionality exists with eDesigner if eMapper is licensed.&#x20;

To leverage it first you need to:

a) Add a mapping file and give it a name that is simple to remember - this is your **MappingName**

![](https://2446085776-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0Xv5e5CMqZNlA8r5Exkm%2Fuploads%2FpT9I4v89rJck3bsiJH4k%2Fimage.png?alt=media\&token=849893b8-65c7-43eb-8ca4-976d887888d2)



b) Map the form fields to the XML file you want to create:&#x20;

![](https://2446085776-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F0Xv5e5CMqZNlA8r5Exkm%2Fuploads%2FcOyp4x60KEd4lDs0SXrY%2Fimage.png?alt=media\&token=a1c0814e-6f5f-4727-a5a5-8587205f8d3a)

c) Add the following settings to your Form Settings in Form Management using the 'Create' button:

**ToAddress** - this allows you to set the email address you want the email for this form to go to

**EmailAdditionalAttachments** - for this setting you need to enter the name of the file mapping you created earlier. I.e. the **MappingName**

Doing this ensures that the email sent to you includes the created XML file for each submission.&#x20;

