Getting emails from Access or Creating messages

D

Demuxer

Hi, i have a Database with many info about people, but i will to create a
table grouping these people with their emails, later send emails by groups.

I dont know what will be easy (or better or smartest),

1)add like a CREATE NEW MESSAGE form in my Access, so the emails will be
updated

OR

2) Create a macro in outlook so i can call new emails and groups when i
choose TO: or CC: , cause i can import data to my Contacts and create
folders formy groups, but the user cant re-import contacts every time(hard
task).

so,what is my solution for send messages by groups and always having an
updated distribution list?

i dont have enough information to develop any of both solutions, so i need
some links or codes too.
(Im using Office XP)
 
D

Demuxer

Yes, i know about SendObject (for access) and linking tables to outlook,but
i dont know what will be the best choice.

"Demuxer"
 
S

Sue Mosher [MVP-Outlook]

If you're not into coding, why not use a Word mail merge as your solution?
 
D

Demuxer

Thanks Sue, but in word i cant group addressess and fill the BCC: field ( i
dont want to show the client's email) also need to create 1 message for every
100 clients or so
 
S

Sue Mosher [MVP-Outlook]

That's the beauty of a mail merge. You send one message to one address, so
there's no need to group addresses or use Bcc. And, because you're not using
Bcc, the message is more likely to get through the recipient's spam filter.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top