sending email through outlook.

[shutzy]

sorry to have 2 threads so close together but i want to hit this from both angles.

i have just thought. with the linking tables thing to outlook can it be reversed. ie if i have a table that was linked to outlook outbox would the records form an email just like the emails from my inbox form a record.

i wanting to send emails automaticallly to many recipients. so i would have to use a record set and i thought that if i build the email in a record then have outlook pick it up then that would be the easiest way.

is it possible. sorry wrong question, anythings possible but is it a good way to go about it?

thanks

 

[pr2-eugin]

I am not sure if the Linked tables will be Updatable. I have never used it, so I am not sure. IMO, creating recordset and Looping through would be the best thing.

 

[shutzy]

thanks, thats what i thought. ive managed to send an email through some vba i found on here so i think ill forget the table linking thing. might be good for future reference as i would like to store my emails and i think in a database would be the best thing.