transfer emails from DB

[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???

 

[Arvin Meyer]

In-line:

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.

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???

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

 

[Arvin Meyer]

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