Email coding

[yusha100]

Team, please help me on this. I have created command for sending email to customers reminding them to pay balance which has remaind. I have textbox in form called txtBalance. I want user to type customized email by himself and add this field (txtBalance) in that email, without going into design or code. How can I do this.
Thanks

 

[Ranman256]

the customer email, name should all be in the tCustomer table. (on the form)
the balance should be also on the form from your other query, etc.
make a report that uses the data on the screen,

then send email via:
docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo,,,sSubj,sBody

or a macro can do the same.

 

[theDBguy]

Hi. Welcome to AWF! What do you mean by without going to design or code? If you can't use any built-in features, you will probably have to use code. Also, you will have to go to design to create something.

 

[yusha100]

My form has Name, Email and Balance Fields. I have unbound textbox where user will type his message, I want also to type/input those fields in his message in any position within his message. And then send it.
By doing that things in OutMail.Body, message will not be customized, rather it will be more programmed. Thanks

 

[theDBguy]

My form has Name, Email and Balance Fields. I have unbound textbox where user will type his message, I want also to type/input those fields in his message in any position within his message. And then send it.
By doing that things in OutMail.Body, message will not be customized, rather it will be more programmed. Thanks

Hi. Since you mentioned Outmail.Body, perhaps this is what you need.

Automating Outlook from a Visual Basic Application

Office VBA reference topic

docs.microsoft.com

 

[Gasman]

I would disagree?, it would be more customised than programmed.?
If you instruct your users to enter the varable data like

The amount now remaining to be paid is [Amount], you can replace [Amount] with the Amount value.
However what happens when they type in [Amunt] instead.?

I suupose you could give options somehow so that the user clicks a button, or another control and you then insert the value in the correct location, but what is there to stop them changing that.? That problem exists if you use the actual value or the control name to replace later.?

Very fraught with the potential for mistakes I would have thought.?

Whenever I have done this, it is a standardised message with the data, in the same place. This also assists the recipient as they do not have to go looking for values in different places each time.?