Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Transferring a Specific Cell range to an email body in alteryx

Grail030510
7 - Meteor

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.

 

Grail030510_0-1686033885851.png

 

 

4 REPLIES 4
FrederikE
13 - Pulsar

Hey @Grail030510,

 

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

FrederikE_0-1686044332611.png

 

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

 

 

Result (w.o. any formating):

FrederikE_4-1686044557595.png

 

 

FrederikE_5-1686044603426.png

 

 

 

Grail030510
7 - Meteor

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?

FrederikE
13 - Pulsar

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. 

Grail030510
7 - Meteor

Thanks for the heads up sir :)

Labels