Emailing from Access

[abbey459]

My boss wants to be able to highlight several e-mails from our vendors
database in access and e-mail all of the highlighted e-mails at once by
clicking a botton. Is this possible?

 

[Dorian]

What email program do you use? Outlook?
You can probably do it but you will have to deal with the Microsoft security
prompt which appears whenever you programatically send an email.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Gina Whipp]

abbey459,

You will be able to do close to what your boss wants. Have a look at...

Code to sent Multiple eMails:
http://www.datastrat.com/Code/MultipleEmail.txt

Download sample database EmalSenate2K (PLEASE do not send eMail from this
databse to the eMails shown. This is for demonstration purposes only!):
http://www.datastrat.com/DataStrat2.html

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Tony Toews [MVP]]

My boss wants to be able to highlight several e-mails from our vendors
database in access and e-mail all of the highlighted e-mails at once by
clicking a botton. Is this possible?

You will need to use VBA code to run through a recordset based on a
query of those email address

For sample recordset logic see
http://www.granite.ab.ca/access/email/recordsetloop.htm

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

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

 

[yamakamiã„ã‚‹ã‹]

ç§ã¯ã€æ—¥æœ¬äººã§ã™ã‚ˆâ˜†

ã©ã†ã™ã‚Œã°ã€ãŠä¼šã„出æ¥ã‚‹ã®ã§ã—ょã†ã‹ï¼Ÿï¼ï¼

椿ã¡ã‚ƒã‚“ã¨ã„ã†ã€åå‰ã§ã€ãƒ›ã‚¹ãƒ†ã‚¹ã‚’ã€ã—ã¦ã„ã¾ã—ãŸâ˜†

覚ãˆã¦ã¦ã€ä¸‹ã•ã£ã¦ã€ã‚¢ãƒªã‚¬ãƒˆã‚¦ã‚´ã‚¶ã‚¤ãƒžã‚¹ï¼ï¼ï¼ï¼

watasiwa,douiu,sonjaiã€ã§ã™ã‹ï¼Ÿï¼Ÿï¼ï¼ï¼

mvp,nannte,irimasen,

watasiha,
mou,gennkai,de-su!!!!!!!!!!!!!!