Email Program

[Ceedy]

If this is the wrong forum, I'm sorry but I'm at my wits end. I need to send
emails using data in Access 2000. The SendObject macro only allows 256
characters to transfer. Does anyone know if there is a software program I
can buy that sends emails AND can import data from Access? Thanks in advance
for any help.

 

[Daniel Pineault]

You could create a report and e-mail it using SendObject method or you could
automate Outlook from within Access.

What exactly are you trying to send? How much data? Explain a bit more
your objective.

 

[Ceedy]

Thanks for your response Daniel. I have successfully sent message to Outlook
Express from Access 2000 using SendObject. The problem is that only the
first 256 characters transfer in OE. The rest are truncated. I'm trying to
thank people for helping our foundation and, of course, trying to personalize
it by including there name and other fields into it but that requires more
than 256 characters (about 500). That's why I was trying to go backwards.
Instead of sending from Access, I'm trying to find a email program that can
grab fields from Access and import them into it. I hope this makes sense.

 

[Tony Toews [MVP]]

If this is the wrong forum, I'm sorry but I'm at my wits end. I need to send
emails using data in Access 2000. The SendObject macro only allows 256
characters to transfer. Does anyone know if there is a software program I
can buy that sends emails AND can import data from Access?

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/