Copiar tabla de excel en cuerpo de gmail

Help Activities
, ,
1

hola a todos, necesito si ayuda, again.
tengo esta tabla con informacion en una hoja de excel, la cual suma valores de la misma hoja

image
image424×220 3.01 KB

mi pregunta en la siguiente, como puedo hacerlo para copiar esta tabla, de excel, como imagen o como sea posible, y pegarla en el cuerpo del correo?

he intentado algunas formas, buscando por internet, pero son medias enredadas de entender, me ayudaria demasiado saber hacer esto.

agradezco su atencion!

2

Hi @mively

Please check below thread

Regards,

3

@mively

Regards,

4

Which version of the Studio are you using?

5

Hi @mively

Please follow the below link for exact copy past data to email body,

6

@mively

  1. Use read range and read the data into datatable
  2. Use create html content activity and convert it to html table
  3. Insert the converted string into the body where you need

Cheers

7

una consulta , eso se puede hacer con la actividad
Send SMTP Mail Message
?? me ayudaria saber eso

8

@mively

We can use any of the below activity to send mail

1.Send SMTP Email activity

An SMTP email sending activity prompt with a warning indicating that the "To" field must be quoted. (Captioned by AI)
An SMTP email sending activity prompt with a warning indicating that the "To" field must be quoted. (Captioned by AI)609×532 18.8 KB

2.Send Outlook Desktop Mail Message activity

An error indicates that the text in the "To" field must be quoted in the Send Outlook Desktop Mail Message interface. (Captioned by AI)
An error indicates that the text in the "To" field must be quoted in the Send Outlook Desktop Mail Message interface. (Captioned by AI)637×384 14.6 KB

3.Send Email activity

A configuration screen for sending an email using the Desktop Outlook App in an automated workflow. (Captioned by AI)
A configuration screen for sending an email using the Desktop Outlook App in an automated workflow. (Captioned by AI)600×624 20.9 KB

Regards,

1 Like
9

The image shows a code editor window with HTML content for styling a division, table, and header text. (Subtitulado por IA)
The image shows a code editor window with HTML content for styling a division, table, and header text. (Subtitulado por IA)875×500 16.2 KB

sirve algo asi para darle estilo, como formato de numero…
y no sea tan estatico en el cuerpo
The image is a table showing the status of financial items such as invoices, rejected invoices, and guides for invoicing, categorized by their expiration status and amounts. (Subtitulado por IA)
The image is a table showing the status of financial items such as invoices, rejected invoices, and guides for invoicing, categorized by their expiration status and amounts. (Subtitulado por IA)1458×217 5.14 KB

10

@mively

If you want format and colour you need to write html code for that

Regards,

11

Resumen Cartera de Clientes

{tablaexcel}

tengo esto, pero se ve mal y los numeros no los toma como debe ser

A table displaying financial data categorized by status with respective amounts and tax inclusion details. (Subtitulado por IA)
A table displaying financial data categorized by status with respective amounts and tax inclusion details. (Subtitulado por IA)1299×318 5.52 KB
imagen gmail
image
image443×219 3.44 KB

como deberia ser

12

@mively

In your excel file there is no headers so that’s why it is sending the mail as 1st row as headers. For the format of data please check Use display format option in Read Range Workbook activity

A workflow sequence in an automation software reads a specified range from an Excel workbook, creates HTML content, and sends an Outlook desktop mail message. (Captioned by AI)
A workflow sequence in an automation software reads a specified range from an Excel workbook, creates HTML content, and sends an Outlook desktop mail message. (Captioned by AI)1333×423 33.4 KB

Regards,

1 Like
13

sabes como darle el formato correcto a los numeros? y algo de color ? disculpa
no me toma lo de excel

The image displays a table summarizing a client's portfolio with descriptions, amounts, and VAT information for various categories. (Subtitulado por IA)
The image displays a table summarizing a client's portfolio with descriptions, amounts, and VAT information for various categories. (Subtitulado por IA)1313×363 7.23 KB

14

@mively

For Format of numbers have you tried this?
please check Use display format option in Read Range Workbook activity

An automated workflow reads data from an Excel workbook and sends it via an Outlook email, with specific settings configured for the input file and display format. (Captioned by AI)
An automated workflow reads data from an Excel workbook and sends it via an Outlook email, with specific settings configured for the input file and display format. (Captioned by AI)1333×423 33.4 KB

15

The image shows a portion of a UiPath workflow involving reading a specific range from an Excel workbook and creating HTML content. (Subtitulado por IA)
The image shows a portion of a UiPath workflow involving reading a specific range from an Excel workbook and creating HTML content. (Subtitulado por IA)1118×253 13.4 KB

16

@mively

Is it working?? I’ve tried the same it is working for me. If not works please try like below

This image shows a process flow in UiPath for using an Excel file named "Input.xlsx" and reading data from "Sheet1" into a data table variable. (Captioned by AI)
This image shows a process flow in UiPath for using an Excel file named "Input.xlsx" and reading data from "Sheet1" into a data table variable. (Captioned by AI)612×601 19.4 KB

Regards,

1 Like
17

tomo los numeros!
hay una posibilidad para el color?

que se vea coo la tabla que esta arriba de esa

The image displays monthly collection projections and actual revenues, alongside a summary of the client portfolio. (Subtitulado por IA)
The image displays monthly collection projections and actual revenues, alongside a summary of the client portfolio. (Subtitulado por IA)1322×698 13.7 KB

18

@mively

For colour we need to write HTML code

Regards,

19

usé esto

The image shows a section of HTML code for creating a styled summary table of clients, with embedded CSS for formatting. (Subtitulado por IA)
The image shows a section of HTML code for creating a styled summary table of clients, with embedded CSS for formatting. (Subtitulado por IA)972×215 9.03 KB

20

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.