473,327 Members | 1,952 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Hide or change senders email-address

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


Nov 13 '05 #1
3 7141
"Filips Benoit" <be***********@pandora.be> wrote in message news:<z5***********************@phobos.telenet-ops.be>...
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


One way is to use the CDONTS library - you can download it from MS.
Nov 13 '05 #2
"Filips Benoit" <be***********@pandora.be> wrote:
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.


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
Nov 13 '05 #3
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 = "be***********@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" <tt****@telusplanet.net> wrote in message
news:t7********************************@4ax.com...
"Filips Benoit" <be***********@pandora.be> wrote:
Quotations for a house are made by several salers with an Access-interfaceon the firms server ( Remote Desktop) . When sending the report by email tothe client the firm wants the salers email in the from-property and not theservers email.
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

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

19
by: benzwt | last post by:
I use the following function to hide a <div> named one. function hideObject() { if (ns4) { document.n1.visibility = "hide"; } else if (ie4) { document.all.style.visibility = "hidden"; }...
19
by: dmiller23462 | last post by:
Hi guys....I have absolutely NO IDEA what I'm doing with Javascript but my end result is I need two text boxes to stay hidden until a particular option is selected....I've cobbled together the...
4
by: jerryyang_la1 | last post by:
I've found this script that allows be to hide/show form elements.. <script language="JavaScript"><!-- var toggle = true; function show(object) { if (document.layers && document.layers)...
4
by: Bharath Ganesh | last post by:
how do i change a form when on a buttonclick? form1.hide() doesnt work.
4
by: Blaine | last post by:
Does anyone know how I can hide a form from the TaskManager? I've set the ShowInTaskbar to False, but when using Alt-TAB to switch between applications, it appears as a blank icon. I can set it...
1
by: kmercer46 | last post by:
I need to hide the user control by checking a small if condition.If the condition is false then then the user control is set TRUE,else It should be FALSE.How can i do it in the ASP.NET with VB.NET...
7
by: FP | last post by:
I'm new to Java Script. I'm displaying comments people have made. Below each persons' comment I want to add 2 buttons "Reply" and "Amend". Clicking "Reply" would display an empty text field...
2
by: ashutosh11 | last post by:
Hi all, can anyone please help I am a new to VBA and need help here. I am trying to store EMAILs depending on the senders Email Domain. I should write a VBA script that will run everytime a new...
7
by: trey.bason | last post by:
I know everyone who uses javascript at some point tries to think of a way to hide it from curious users/hackers, so here goes my question. I am trying to display an image map and keep the coords...
5
by: Dautkhanov | last post by:
Hello all ! I have my own library for web-design building - active forms, lists. I am going to build tabbing component. The complexity in this process is that all web forms uniformed and are...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.