Macro For Automatic Emails

[spider1029]

Hello, could you please help me setting up excel macro to create automatic emails in Outlook?

-number of emails would depend on the number of rows; each row would represent one email
-first row should be disregarded
-email address: should be copied from A column
-subject: should be copied from B column
-email body: always the same text

Example:

Excel:
Column 1 / Column 2
Row 1 john@email.com 123456
Row 2 tim@email.com 741852
…
Row 7 mike@email.com 852963

After hitting the marco button there will be 7 emails created.

Outlook example for first email:

Email address: john@email.com
Subject: 123456
Email body: Always the same text.

[Richard Buttrey]

Hi,

One way, assuming you have Outlook (and if you don't you'll need the SMTP equivalent for this)

Please Login or Register  to view this content.

[spider1029]

Hi Richard, thank you. Yes, I do have Outlook. It seems not to work for me unfortunately. All the Marco does is create 1 new email with text "This is the standard text" in the email body, with no recipient address or subject. Any idea why it doesn't work on my end?