• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Send one email to recipient listed multiple times

P

Prakash M

New Member
Hello,

I'm looking for a VBA macro were we can send one email as an table to recipients listed multiple times. (see attached excel for your reference)

In Excel, column K contains all the email address. For instance, 1st email should go to 3@someone.com as a table with below email structure.

Hello someone,

Please see highlights in below table:

80826

In case of any queries, please reach out to me.

Outlook Signature

Similarly the second email should go to 4@someone.com as below:

Hello someone,

Please see highlights in below table:80827

In case of any queries, please reach out to me.

Outlook Signature

Please advise. Thanking you in advance.
 
Step 1
Open your Gmail account and click Compose to open up the Gmail compose window.
Step 2
Add your subject line and email text.
Step 3
Add the primary recipient’s email address of your email in the To line.
Step 4
Once you click the BCC button, you can add the address of each hidden recipient to your mail.
Step 5
Click the Send button, and you’re done – you can now send an email to multiple recipients!

Hope You Find This Useful,
Peter
 
You must log in or register to reply here.
Back
Top