topic Re: Transferring a Specific Cell range to an email body in alteryx in Alteryx Designer Desktop Discussions

Transferring a Specific Cell range to an email body in alteryx

Grail030510 — Tue, 06 Jun 2023 06:48:05 GMT

Good day,

I wanna ask for help or advice, if it is possible to transfer a specific range of cell in excel including it's format and transfer it to the body of an email in Alteryx.

Thank you so much in advance.

Re: Transferring a Specific Cell range to an email body in alteryx

FrederikE — Tue, 06 Jun 2023 09:43:33 GMT

Hey @Grail030510,

You can limit the data you read from an excel in the input by specifing the Table and Cell Range.

This will then import only the selected cells. Then you can Mail this.

Result (w.o. any formating):

Re: Transferring a Specific Cell range to an email body in alteryx

Grail030510 — Tue, 06 Jun 2023 09:52:38 GMT

Thanks for the answer , are there any chances that I could also transfer it as is in the original format like the sample image above?

Re: Transferring a Specific Cell range to an email body in alteryx

FrederikE — Tue, 06 Jun 2023 09:59:03 GMT

Hey @Grail030510,

Unfortunaly not. Alteryx doesn't read anything but the actual table, therefore formating, coloring, etc. is droped.

You can recreate this using the table tool, but this has to be set up manually and won't be dynamic.

Re: Transferring a Specific Cell range to an email body in alteryx

Grail030510 — Tue, 06 Jun 2023 10:03:57 GMT

Thanks for the heads up sir :)