thardyjackson
Registered User.
- Local time
- Today, 05:26
- Joined
- May 27, 2013
- Messages
- 45
I want to generate a file of customized SMS messages for my customers. There are 10 types of messages "your balance is xxx" "thanks for your payment of xxx" "we have not received a payment since xx/xx/xx"
I've tried creating an "SMS" table with 10 generic messages in 10 records... record 1 is [Full Name] & "thank you for your payment of " & [PaymentAmt] and record 2 is "Your balance is" & [Balance]. A separate query linked to my payments table picks the correct record from the SMS table but everything is treated like text.
Instead of generating SMS messages like:
Mr. Johnson thank you for your payment of $100.
my query generates this for all customers:
[Full Name] & "thank you for your payment of " & [PaymentAmt]
How can I get the parameters to be treated as parameters rather than text string?
Cheers.
I've tried creating an "SMS" table with 10 generic messages in 10 records... record 1 is [Full Name] & "thank you for your payment of " & [PaymentAmt] and record 2 is "Your balance is" & [Balance]. A separate query linked to my payments table picks the correct record from the SMS table but everything is treated like text.
Instead of generating SMS messages like:
Mr. Johnson thank you for your payment of $100.
my query generates this for all customers:
[Full Name] & "thank you for your payment of " & [PaymentAmt]
How can I get the parameters to be treated as parameters rather than text string?
Cheers.