Link to home
Start Free TrialLog in
Avatar of Richard
Richard

asked on

import list email addresses into Contact group

I have a database which holds clients email addresses.
How easy is it to import these into Outlook to make a Contact group to send bullitins, mailshots etc.
How would this be done?
Would it be easy to update the group from time to time from the dtatabase and how would I do this?
many thanks


** Outlook zone added by modus_operandi, EE Admin **
Avatar of BusyMama
BusyMama
Flag of United States of America image

You should be able to do this.  What version of Outlook are you using?
Avatar of Richard
Richard

ASKER

2007
SOLUTION
Avatar of BusyMama
BusyMama
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Q: <What version of Outlook are you using?>
A: <2007>

...but your question tag states: "access 2003 code"?
So I am a bit confused....?

In any event, you can link to Outlook in the same way, just using the 2007 ribbon:
External Data-->More-->Outlook Folder...


JeffCoachman
Jeff,

It is possible to be using Access 2003 and Outlook 2007.

After all, right now on my work computer I use Outlook 2007 and Access 2010.

:)

Patrick
Pat,
<It is possible to be using Access 2003 and Outlook 2007.>
Yes, this I knew...

Sorry, I was not clear...

I was only asking because I listed the steps for doing this for acc 2003, because I saw the "access 2003 code" tag, first.

So it was just a matter of what steps I was posting;
Access 2003:  File-->...
Or Access 2007:  External Data-->...

Not that I did not know that you could run both versions...
;-)

Jeff
Avatar of Richard

ASKER

Would there be another program that could manage emails better other than the Outlook/Access combo?
<Would there be another program that could manage emails better other than the Outlook/Access combo?>
In my opinion, No
I generally manage email addresses  and distribution lists in Access.

I use VBA code to send out the emails

You can send out  the email using Outlook automation.

My preferred method is to send them out directly through an SMTP server. This method bypasses the need to have to interface with an email client like Outlook. You don't even have to have an email client installed or configured.

Do you use Exchange for your mail server?
Avatar of Richard

ASKER

hi tech coach

i think this your proposal is above what ican cope with as I dont have Exchange.

I use a program called FTGate to distibute mail.

Avatar of Richard

ASKER

thanks guys
Actually BusyMama deserves some credit here as well, for first suggesting that you use outlook.


Please click the "Request Attention" link and ask that this be changed.
Avatar of Richard

ASKER

do you mean a 50 50 split?

as oposed to 150/350 which is what i did

am happy to oblige. please confirm
Sorry, I apologize, I see that you did assign her points...

It's all good unless other Experts think otherwise...