Generating E-Mails from Excel with embedded JPG from a Powerpoint Source (Christmas Cards Sending App)
Budget: $10 – $30 USD
We need to send digital Christmas cards this year as emails with a nice picture in it!
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 bla.com" 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 )
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 bla.com" 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 )