Email distribution list....Combine all cells into one.

G

gg

Well-known Member
Joined
Nov 18, 2003
Messages
560
I have email addresses all seperated from D1:D1955. The email addresses all have a comma after the address. I need to be able to put all these addresses in one line so that I can send out a bulk email.

How can I get all of these in one cell?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Sort by date Sort by votes
this might do the trick...just change the last line to the actual cell you want this to wind up in...right now it's set for A1...

Code: 
Sub test()
   myEmails = ""
   For Each cell In Range(Cells(1, "D"), Cells(Cells(Rows.Count, "D").End(xlUp).Row, "D"))
   myEmails = myEmails & cell.Value
   Next cell
   Range("A1").Value = myEmails
End Sub
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar threads

J
  • Question
VB Macro for extracting Excel email address data to Outlook email draft
Replies
0
Views
605
Jaydee12
J
N
  • Solved
VBA Help: Email loop with an attachment
Replies
2
Views
557
NeoSez
N
F
  • Question
Remove Specific email addresses from a long list of emails
Replies
3
Views
528
mumps
mumps
A
  • Solved
Formula to search row of semicolon separated values against a list
Replies
7
Views
383
awoohaw
awoohaw
J
  • Question
Power Automate and Excel with Outlook
Replies
3
Views
290
Jaffabfc
J

Forum statistics

Threads
1,214,978
Messages
6,122,549
Members
449,089
Latest member
davidcom

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top