Connecting Tech Pros Worldwide Forums | Help | Site Map

Hide or change senders email-address

Filips Benoit
Guest
 
Posts: n/a
#1: Nov 13 '05
Dear All,

How can i email from access and hide or change the senders email-address?

Why:
Quotations for a house are made by several salers with an Access-interface
on the firms server ( Remote Desktop) . When sending the report by email to
the client the firm wants the salers email in the from-property and not the
servers email.

THANKS

Filip





Pieter Linden
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Hide or change senders email-address


"Filips Benoit" <benoit.filips@pandora.be> wrote in message news:<z5Q2d.249569$3P4.12759153@phobos.telenet-ops.be>...[color=blue]
> Dear All,
>
> How can i email from access and hide or change the senders email-address?
>
> Why:
> Quotations for a house are made by several salers with an Access-interface
> on the firms server ( Remote Desktop) . When sending the report by email to
> the client the firm wants the salers email in the from-property and not the
> servers email.
>
> THANKS
>
> Filip[/color]

One way is to use the CDONTS library - you can download it from MS.
Tony Toews
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Hide or change senders email-address


"Filips Benoit" <benoit.filips@pandora.be> wrote:
[color=blue]
>Quotations for a house are made by several salers with an Access-interface
>on the firms server ( Remote Desktop) . When sending the report by email to
>the client the firm wants the salers email in the from-property and not the
>servers email.[/color]

This would depend on the method you are using to send email. If you are using
SendObject that doesn't support such. Other methods, such as CDONTS mentioned by
Peter do support such.

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
Filips Benoit
Guest
 
Posts: n/a
#4: Nov 13 '05

re: Hide or change senders email-address


Thanks, but no success yet!

W2000
office2000
Added ref to 'Microsoft CDO for NTS 1.2 Library'
No code error
BUT NO emails send

Please help!

Dim oEMail As Object
Set oEMail = CreateObject("CDONTS.NewMail")
oEMail.From = strFromEmail
oEMail.To = "benoit.filips@pandora.be"
oEMail.BodyFormat = CdoBodyFormatText
oEMail.Body = "Insert some useful text here"
oEMail.Importance = CdoHigh
'oEMail.AttachFile = "C:\filename.txt"
oEMail.Send


Filip


"Tony Toews" <ttoews@telusplanet.net> wrote in message
news:t76pk0tk4tn5qtbu2gf4g35cj5qp134ud8@4ax.com...[color=blue]
> "Filips Benoit" <benoit.filips@pandora.be> wrote:
>[color=green]
> >Quotations for a house are made by several salers with an[/color][/color]
Access-interface[color=blue][color=green]
> >on the firms server ( Remote Desktop) . When sending the report by email[/color][/color]
to[color=blue][color=green]
> >the client the firm wants the salers email in the from-property and not[/color][/color]
the[color=blue][color=green]
> >servers email.[/color]
>
> This would depend on the method you are using to send email. If you are[/color]
using[color=blue]
> SendObject that doesn't support such. Other methods, such as CDONTS[/color]
mentioned by[color=blue]
> Peter do support such.
>
> 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[/color]


Closed Thread