Send 'personalized' emails from within FM Pro Advanced
I'm kind of a FM-newbie, and I was wondering if FM offers this feature:
The thing is, I have like 750 email addresses I need to send an email to (all the same email). I found out this can be done using FileMaker (works quite well!) but I would like to add some personalization into it, like when I send an email to Ms. Fitzgerald I want the email to state Dear Ms Fitzgerald (instead of Dear Sir or Madam), so I want to make a part of the text in the email variable, using a specific column in my database ("Full_Name"). I also would like to know if it is possible to make some sort of 'script' so that when the column "Full_Name" is empty, FM uses "Sir or Madam" instead. I hope you guys understand, cause since English is not my native language it's quite hard for me to explain correctly. So if you have any questions, just ask, and thank you for the help!