A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How can I create stock emails to reply to clients?



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2010, 03:09 AM posted to microsoft.public.access
Janet Todd
external usenet poster
 
Posts: 1
Default How can I create stock emails to reply to clients?

Can anyone tell me how to do this please?
  #2  
Old March 10th, 2010, 03:59 AM posted to microsoft.public.access
John W. Vinson
external usenet poster
 
Posts: 18,261
Default How can I create stock emails to reply to clients?

On Tue, 9 Mar 2010 19:09:01 -0800, Janet Todd Janet
wrote:

Can anyone tell me how to do this please?


You'll have to explain your task in more detail. Is this in an Access database
(the subject of this forum)?
--

John W. Vinson [MVP]
  #3  
Old March 10th, 2010, 04:19 PM posted to microsoft.public.access
Mark Andrews[_4_]
external usenet poster
 
Posts: 169
Default How can I create stock emails to reply to clients?

For email templates you have a few options:
1. use a service like Constant Contact
2. build it yourself

I can describe the basics for how I built email templates into my software.
See my website for more details.

- create a table to store the email template (from, to, cc, bcc, subject,
body etc..)
- create form to allow a user to build an email template
- the concept is you allow variables or merge fields into the various parts
of the email template
example: ##email## ##Firstname##

then at runtime your code loops thru a recordset and substitutes the
variables with the real data.
Think of it as just building strings on the fly.
After you have built the strings you can send the email.

If you want to see example of how I did it see both websites. I basically
used a concept similar to how Albert Kallal
approach word merge templates and did it with email templates.

Doing HTML email templates adds a bit more complexity if you build it
yourself since now you need an HTMl control
if you want a full WYSIWIG type application. nBit has a activex html
control.

Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com

"Janet Todd" Janet wrote in message
...
Can anyone tell me how to do this please?


  #4  
Old March 13th, 2010, 05:32 PM posted to microsoft.public.access
De Jager
external usenet poster
 
Posts: 393
Default How can I create stock emails to reply to clients?


"Janet Todd" Janet wrote in message
...
Can anyone tell me how to do this please?


  #5  
Old March 17th, 2010, 01:40 PM posted to microsoft.public.access
joelgeraldine
external usenet poster
 
Posts: 201
Default How can I create stock emails to reply to clients?

l!n

"Janet Todd" Janet a écrit dans le message
de groupe de discussion :
...
Can anyone tell me how to do this please?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:18 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.