Getting emails from Access or Creating messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
Yes, i know about SendObject (for access) and linking tables to outlook,but
i dont know what will be the best choice.

"Demuxer"
 
If you're not into coding, why not use a Word mail merge as your solution?
 
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
 
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
 
Back
Top