We need to send digital Christmas cards this year as emails with a nice picture in it!
I need an automated solution (a program or VBA script) for the following:
Input will be a list of names and mail addresses in Excel and a powerpoint with a name field.
1.0 For each for in the excel, column A has an x, you need to generate a powerpoint
1.1 Copy the powerpoint slide and replace the name field with the column F for first name or (if column M is "x", concatenate E and G for salutation and last name (first name or salutation and last name depending on a field in that excel)
2.0 Generate an e-mail that is addresses to the address in column L in the Excel
2.1. Save the powerpoint as high resolution JPG picture
2.2 Embed the high resolution picture generated in 2.1 to the generated mail in 2.0
2.3 Add a static address "test at [login to view URL]" as BCC address to the mail
2.3 Save the mail as draft (don't send!)
3.0 Variation: Based on Column C, you use a different input file as template for the powerpoint
I need the full source code. Can be pretty much any programming language ( I assume it will be either a VBA Macro or .NET )
18 freelancers are bidding on average $25 for this job
Hi, I have read your description over. I am an expert in automated processes, I can provide Outlook(Windows APP)+UiPath solutions. Please chat me. Best Regards, -Lan