transfer emails from DB

  • Thread starter Thread starter zena
  • Start date Start date
Z

zena

Ok, here's another task I'm trying to accomplish, it's a two part
question-related.

Part 1
Can you tell me (again, in layman's terms) how to import my "email"
field into outlook. In other words, I have a few thousand contacts in
my db. I would really rather not have to type everyone's email, one by
one by one by one by one......... into my address book in outlook
express.

Part 2
How can I customize a letter, going to each email, with their
individual name and info. ie.
(Name)
(Address)
(City)(State)(Zip Code)

Dear (First Name)


.......(Company Name).....

..................
Thanks (First Name)

Sincerely,

Zena

I think this is called a merge???
 
In-line:

zena said:
Ok, here's another task I'm trying to accomplish, it's a two part
question-related.

Part 1
Can you tell me (again, in layman's terms) how to import my "email"
field into outlook. In other words, I have a few thousand contacts in
my db. I would really rather not have to type everyone's email, one by
one by one by one by one......... into my address book in outlook
express.
Click to expand...

In Outlook:
File ...
Import and Export ...
Import From Another Program or File ...
Microsoft Access ...
File to Import ...
etc.
Part 2
How can I customize a letter, going to each email, with their
individual name and info. ie.
(Name)
(Address)
(City)(State)(Zip Code)

Dear (First Name)


......(Company Name).....

.................
Thanks (First Name)

Sincerely,

Zena

I think this is called a merge???
Click to expand...

Build your mail query in Access. Open Word, then:

Tools ...
Letters and Mailings ...
Merge Wizard ...
etc.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Tom Wickerath pointed out to me that you want to do this in OE, Actually you
first say Outlook then Outlook Express. For Outlook Express, you need to
first export your data file from Access into a .CSV (Comma Separated Value)
text file, then you can import that into your Address Book.

I also see that you have a "few thousand contacts". I think you may be
dissapointed with the performance in either email program, if the list is
over a thousand or so. I'd recommend leaving the Address Book in Access, and
using .SendObject (or from Word, .SendTo) to email. If you'd like to use
Outloook, there's some code on my website:

http://www.datastrat.com/Code/OutlookEmail.txt
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top