Excel to Access to Outlook - First post

[anywhereintheworld]

Hi All,

This is my first post on here - hope I am not being too ambitious:

How do I get a list of e-mail addresses from a list in Excel (along with corresponding usernames and first and last names) in to an Access database?

In additiion how can I then get this in to Outlook so as each individual in the list receives an e-mail - it would also be great to add in their name in the e-mail by use of a mail merge. Any suggestions?

I realise Word may be involved in this too.

Thanks for your time and knowledge,

AnywhereInTheWorld

 

[Corticus]

Shouldn't be too hard,

I'll do somemore research, but check out this post, it has a lot of what you're asking for regarding Outlook:
http://216.92.17.166/board/viewtopic.php?topic=7311&forum=2

HTH,

 

[Anne Troy]

Mail merge from Word provides a feature where the output product is an email and it'll use a column in an Excel file or Access DB as the source of the address.

 

[NateO]

Howdy anywhereintheworld, welcome to the board.

Have a look at this.

It should allow you to push programmatically from Excel to Access.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2003-01-10 02:24

 

[radar2000]

Howdy anywhereintheworld, welcome to the board.

Have a look at this.

It should allow you to push programmatically from Excel to Access.

_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2003-01-10 02:24

Hi Nate.

The link in this tread goes back to the main menu page.

Could you please provide me with the correct link?

Thank you.

 

[NateO]

Hello, here’s the adjusted url:
http://www.mrexcel.com/board2/viewtopic.php?topic=12494

Hmm, old post, from the old board. Note, there are some coercion issues (e.g., backslash on the file path).