Oh dear! E-mail AGAIN!

[julietbrown]

I have searched forums, and MSoft support dbase ... no joy on this one

I have working code that constructs a "mailto" string that looks like (e.g.)

#Mailto:julietbrown@thing.com,fredbloggs@otherthing.com#

(this can be any length ... user picks addresses from a list box and code builds the string (called eString below), and puts it in a text box called EmailAddresses

My VBA says
EMailAddresses = eString
EMailAddresses.Hyperlink.Follow
This ,akes Outlook Exp open Word as my email editor, puts the top-and-tailed string (just the email addresses, minus #Mailto: ... #" into the recipient and lets me type the message and send it.

FINE, AS FAR AS IT GOES, BUT
My client doesn't want all the addresses in the recipient line, because that means they all get to know eachothers' email addresses.

I really want to create a mail alias WITHIN Access... Is there any way this is possible? Or any other way of solving the problem?

 

[John.Woody]

Look at my code in this thread.
http://www.access-programmers.co.uk/forums/showthread.php?t=33405&highlight=email
You should be able to use it to put your email addresses in eString.

HTH

 

[julietbrown]

Thanks for your time and help
But the addresses are in estring fine; the problem is that all the addresses show up in the recipient line of the message so everyone mailed gets everyone else's email address . Still brooding on it, so if you get any other ideas ... please!! ...
Juliet

 

[namliam]

If you use office automation to create a mailobject you can put the email addresses into the BCC of a mail, thus hidding the email addresses from all who receive the mail.

Regards

 

[julietbrown]

Ah! THAT sounds like the way to do it! Thanks. I have to learn some stuff about Office Aut, as I always prefer to work at the 'code it yourself nitty gritty level' (Poor old DOS body!) But I am now motivated!

Thanks lots

 

[namliam]

Just to help you along:

You need to add the Microsoft Outlook ... Object library to the references.

Also you cannot send a trully automated mail due to security you will get a message saying something like: "An application is trying to send a mail, do you agree?"

You can try to work around that using something called "retention",
I will leave "the rest of the work" to you. There are some samples out here, also you can allways post any questions you have left after looking for the samples

Regards & GL

 

[John.Woody]

Juliet

Look again at the code I posted in the other thread. The email addresses do appear in the bcc field.