sending mail from within access

sending mail from within access

Hi

When I send a report with following code:

DoCmd.SendObject acSendReport, "Coordinaten_rapport", acFormatHTML, 
MP_Setup.Coordinaten_rapport, , , "Wijziging van coordianten ", "", False

Outlook opens a messagebox saying something about safty-stuff.
I have to click Yes to continue...
Is there a way not to get this messagebox?

Also,

WHen I write:

DoCmd.SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
strMailSubject, strMsg, , False

The message itself is opened... although I added "False"

Can somebody please explain

Thanks
JP

date: Sat, 04 Oct 2008 22:06:59 +0200 author: Jean-Paul

RE: sending mail from within access

According to the help file the basic synthax is

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, 
MessageText, EditMessage, TemplateFile)

when we compre it to your code

SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
strMailSubject, strMsg, , False

we can notice that you placed the False as the 10th input variable and yet 
the help file indicates it should be the 9th.  So try

DoCmd.SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
strMailSubject, strMsg, False
-- 
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"Jean-Paul" wrote:

> Hi
> 
> When I send a report with following code:
> 
> DoCmd.SendObject acSendReport, "Coordinaten_rapport", acFormatHTML, 
> MP_Setup.Coordinaten_rapport, , , "Wijziging van coordianten ", "", False
> 
> Outlook opens a messagebox saying something about safty-stuff.
> I have to click Yes to continue...
> Is there a way not to get this messagebox?
> 
> Also,
> 
> WHen I write:
> 
> DoCmd.SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
> strMailSubject, strMsg, , False
> 
> The message itself is opened... although I added "False"
> 
> Can somebody please explain
> 
> Thanks
> JP
>

date: Sat, 4 Oct 2008 13:26:01 -0700 author: Daniel Pineault

Re: sending mail from within access

Yes, Outlook has security warnings which say something to the effect that:

An outside program is trying to send mail. Do you want to allow this.

You are required to click yes to continue. There is a 3rd party app called 
Outlook Redemption that will fix this. It is free for non-corporate use, and 
not very expensive for enterprise use:

http://www.dimastr.com/redemption/

I've used in effectively in all versions of Outlook which have this warning.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jean-Paul"  wrote in message 
news:C1QFk.1343$qx1.623@newsfe13.ams2...
> Hi
>
> When I send a report with following code:
>
> DoCmd.SendObject acSendReport, "Coordinaten_rapport", acFormatHTML, 
> MP_Setup.Coordinaten_rapport, , , "Wijziging van coordianten ", "", False
>
> Outlook opens a messagebox saying something about safty-stuff.
> I have to click Yes to continue...
> Is there a way not to get this messagebox?
>
> Also,
>
> WHen I write:
>
> DoCmd.SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
> strMailSubject, strMsg, , False
>
> The message itself is opened... although I added "False"
>
> Can somebody please explain
>
> Thanks
> JP

date: Sat, 4 Oct 2008 23:20:45 -0400 author: Arvin Meyer [MVP] lid

Re: sending mail from within access

I'm affraid this is a bit too complicated for me...

I downloaded and installed Redemption
Tried it with my acces program... no difference.

But, in the readme.txt I read:

To use Redemption in VB or .Net languages, add "Redemption" library to 
your project references.

So I think this might be the problem...
Do I have something to do with the dll file that comes with the zip 
file.. if so, what is there to do?
Thanks

JP

Arvin Meyer [MVP] wrote:
> Yes, Outlook has security warnings which say something to the effect that:
> 
> An outside program is trying to send mail. Do you want to allow this.
> 
> You are required to click yes to continue. There is a 3rd party app called 
> Outlook Redemption that will fix this. It is free for non-corporate use, and 
> not very expensive for enterprise use:
> 
> http://www.dimastr.com/redemption/
> 
> I've used in effectively in all versions of Outlook which have this warning.

date: Sun, 05 Oct 2008 09:09:52 +0200 author: Jean-Paul

Re: sending mail from within access

Great...
This solved an important part of the problem... So dumb.. I checked and 
recheck and never thought the extra imput was the fault.
Thanks a lot

JP, Belgium

Daniel Pineault wrote:


Daniel Pineault wrote:
> According to the help file the basic synthax is
> 
> SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, 
> MessageText, EditMessage, TemplateFile)
> 
> when we compre it to your code
> 
> SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
> strMailSubject, strMsg, , False
> 
> we can notice that you placed the False as the 10th input variable and yet 
> the help file indicates it should be the 9th.  So try
> 
> DoCmd.SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
> strMailSubject, strMsg, False
> According to the help file the basic synthax is
> 
> SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, 
> MessageText, EditMessage, TemplateFile)
> 
> when we compre it to your code
> 
> SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
> strMailSubject, strMsg, , False
> 
> we can notice that you placed the False as the 10th input variable and yet 
> the help file indicates it should be the 9th.  So try
> 
> DoCmd.SendObject acSendNoObject, strDocName, acFormatHTML, strEmail, , , 
> strMailSubject, strMsg, False

date: Sun, 05 Oct 2008 09:11:59 +0200 author: Jean-Paul

Re: sending mail from within access

Arvin Meyer [MVP] wrote:
> Yes, Outlook has security warnings which say something to the effect
> that:
> An outside program is trying to send mail. Do you want to allow this.
>
> You are required to click yes to continue. There is a 3rd party app
> called Outlook Redemption that will fix this. It is free for
> non-corporate use, and not very expensive for enterprise use:
>
> http://www.dimastr.com/redemption/
>
> I've used in effectively in all versions of Outlook which have this
> warning.

Does Redemption affect SendObject though or is it only an alternative for 
automation?

-- 
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

date: Sun, 5 Oct 2008 07:32:25 -0500 author: Rick Brandt

Re: sending mail from within access

Follow the instructions to install Redemption, then open any code window and 
find the path to the redemption dll which should be:

C:\WINDOWS\system32\Redemption.dll

and click in the check box.

I'm not sure which zip file you are talking about.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jean-Paul"  wrote in message 
news:3LZFk.295$0e5.280@newsfe25.ams2...
> I'm affraid this is a bit too complicated for me...
>
> I downloaded and installed Redemption
> Tried it with my acces program... no difference.
>
> But, in the readme.txt I read:
>
> To use Redemption in VB or .Net languages, add "Redemption" library to 
> your project references.
>
> So I think this might be the problem...
> Do I have something to do with the dll file that comes with the zip file.. 
> if so, what is there to do?
> Thanks
>
> JP
>
> Arvin Meyer [MVP] wrote:
>> Yes, Outlook has security warnings which say something to the effect 
>> that:
>>
>> An outside program is trying to send mail. Do you want to allow this.
>>
>> You are required to click yes to continue. There is a 3rd party app 
>> called Outlook Redemption that will fix this. It is free for 
>> non-corporate use, and not very expensive for enterprise use:
>>
>> http://www.dimastr.com/redemption/
>>
>> I've used in effectively in all versions of Outlook which have this 
>> warning.

date: Sun, 5 Oct 2008 13:52:59 -0400 author: Arvin Meyer [MVP] lid

Re: sending mail from within access

Yes Redemption affects the way that the security patches work in Outlook. 
Access is unaffected in any way.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Rick Brandt"  wrote in message 
news:mt2Gk.3909$be.3240@nlpi061.nbdc.sbc.com...
> Arvin Meyer [MVP] wrote:
>> Yes, Outlook has security warnings which say something to the effect
>> that:
>> An outside program is trying to send mail. Do you want to allow this.
>>
>> You are required to click yes to continue. There is a 3rd party app
>> called Outlook Redemption that will fix this. It is free for
>> non-corporate use, and not very expensive for enterprise use:
>>
>> http://www.dimastr.com/redemption/
>>
>> I've used in effectively in all versions of Outlook which have this
>> warning.
>
> Does Redemption affect SendObject though or is it only an alternative for 
> automation?
>
> -- 
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt   at   Hunter   dot   com
>

date: Sun, 5 Oct 2008 13:54:07 -0400 author: Arvin Meyer [MVP] lid

Re: sending mail from within access

The zip file is the file I downloaded, containg a txt, a dll and an 
install file.

What I did:

Open a code window
go to extra
picked "verwijzingen" (first item)
go to browse
search for the redemption.dll
open it
checked the ckeckbox in front of "redemption outlook and MAPI Com Library

restarted access.

Result... exactly the same question asked before sending the mail.

Any Idea?
Thanks


Arvin Meyer [MVP] wrote:
> Follow the instructions to install Redemption, then open any code window and 
> find the path to the redemption dll which should be:
> 
> C:\WINDOWS\system32\Redemption.dll
> 
> and click in the check box.
> 
> I'm not sure which zip file you are talking about.

date: Sun, 05 Oct 2008 21:37:23 +0200 author: Jean-Paul

Re: sending mail from within access

Hopefully you used the install file because that also registered the dll. 
Otherwise you'll need to register it manually.

Start >>> Run

then type:

regsvr32.exe "C:\WINDOWS\system32\Redemption.dll"

and click OK. You should get a message that the registration succeeded.

Other than that, I have no further suggestions. Redemption always works for 
me.
-- 
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Jean-Paul"  wrote in message 
news:RH8Gk.4817$fV4.527@newsfe29.ams2...
> The zip file is the file I downloaded, containg a txt, a dll and an 
> install file.
>
> What I did:
>
> Open a code window
> go to extra
> picked "verwijzingen" (first item)
> go to browse
> search for the redemption.dll
> open it
> checked the ckeckbox in front of "redemption outlook and MAPI Com Library
>
> restarted access.
>
> Result... exactly the same question asked before sending the mail.
>
> Any Idea?
> Thanks
>
>
> Arvin Meyer [MVP] wrote:
>> Follow the instructions to install Redemption, then open any code window 
>> and find the path to the redemption dll which should be:
>>
>> C:\WINDOWS\system32\Redemption.dll
>>
>> and click in the check box.
>>
>> I'm not sure which zip file you are talking about.

date: Sun, 5 Oct 2008 19:34:25 -0400 author: Arvin Meyer [MVP] lid