Microsoft Excel to Email

Hi,

I want to create a kind of a program where if I enter data into an Excel spreadsheet, that data will be printed onto either a Microsoft Word document or as an email. For example, if I had a Word document or an email written as:

Dear ______,

Thanks.

I want to be able to type a list of names and email addresses in an Excel document, and have it automatically send to those email addresses with the names filled in the blank. Please advise. Thanks.

Hello alextsg,

You need to read the Word help files on setting up a Mail Merge.

Sincerely,
Leith Ross

Hi,

I tried using Mail Merge for emails, but nothing got sent out. What does Microsoft Office use as the sender information when sending email with Word?

Hello alextsg,

Office will use either Outlook or Outlook Express by default. You need to configure these programs before you can send emails.

Sincerely,
Leith Ross

Hi,

Thanks for the reply. Is there any way to change the default so that I can send it from any email address? Thanks.

Hello alextsg,

Generally when you start any email program under Windows, it will ask you if you want to set it as the default email program. Using another email program will limit the information you can send out from Excel to the recipient(s), subject, body of the email, CC, and BCC. You can use attachments if you want to use the more advanced email method of calling the CDO (Collaboration Data Objects) mailer.

Sincerely,
Leith Ross