Hope you could help me. I am planning to create a macro wherein when I run the macro all the data I have in excel will be converted into a letter (word format).
Example i have data in excel
Type First Name Last Name Address Promo type
ddo Kevin Rogers Manila Discount
rtp Rachel Cruz Manila Free
The result in word should be
Thank you for availing our promo.
Is it possible that it will run different letter in one macro using the type in the first column?