Hello,
Super new to automate, but can't seem to get this to work. Basically I just need to send unique voucher codes from an excel sheet to different emails using an email template.
Basically take row 1 of the voucher sheet and the email from row 1 of the email sheet and send an email with that code using a template. Then iterating to the next row and so on.
Please advise, thanks in advance!
What I would do is to iterate through your first excel sheet with email addresses (using the excel connector). At the end of this loop, create your email template to send to that email address with the voucher code.
Inside the loop I think the easiest thing to do is to query the voucher sheet, select your table inside the excel and get the first row. Create another column in you excel sheet for 'used' voucher codes. When you query the excel sheet, ensure your 'used' column isn't yes/true. Once you send the email, update your excel sheet to update the 'used' column to true. As you loop through your email list, you'll be updating the voucher list marking vouchers as used or not. Your query for new vouchers at each loop should only return 1 unused voucher at a time.
#1
WarrenBelz
146,668
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
66,004
Most Valuable Professional
Share
Report
All responses (
Answers (
