Reply to email with data retrieved from an excel spreadsheet

[Pullox]

Hello,

I am trying to achieve the following:

When an email arrives >

Reply to that email >

Include value pulled from a table in the body >

Next email should receive the next value from the table.

What I've achieved so far seems to be working fine except for the part where the next value is send. 

Many thanks in advance for your help!

Sincerely,

Pullox

[RobElliott]

@Pullox it is going to be very difficult to get the next value from that list in the spreadsheet. You would be better to hold the next incremental value as a single item in a SharePoint list (or possibly a spreadsheet table but I prefer SharePoint lists). You take the current value from that list then update it for the next item by adding 1 to the value.

Rob
Los Gallardos

[ChristianAbata · Accepted solution]

hi @Pullox  what you wnat to do is send an email with the first value then send the next email with the next value until ends your table? if is yes what I'll do is delete the first record on excel table after the email is sended so then for a new email the value to send would be the next one.

[Pullox]

Hello @ChristianAbata,

Many thanks for you suggestion it seems to work as it always deletes the top value so the next time the trigger is activated it sends the next value.

I will perfect it and update the results.

Thank you so much for you help!

[Pullox · Accepted solution]

@ChristianAbata,

As promised here is the solution I implemented I actually delete each value I send and then add it to a different table to keep a record it  worked like a charm.

Many thanks for your help once again! 

[ChristianAbata]

Shure @Pullox

I'm participating in tshirt contest see if my submition likes you See my submition