Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 205
Default Email to list sat up in Excel

I have entered about 500 email addresses into Excel spread sheet, how do I
merge these into a email so I can send this out in groups of 50?

I know they have to be separated with commas but I do not remember how to do
this. Please give step by step I am very slow with a computer

Thank you
Linda
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 53
Default Email to list sat up in Excel

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 205
Default Email to list sat up in Excel

Stephane thank you very much for helping me with this question.
Linda

"Stephane Quenson" wrote:

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 205
Default Email to list sat up in Excel

Stephane, this worked perfectly when I used this formula in July. However I
am encountering problems using this same formula. please let me know if my
email address is in e2, would the formula not be =e2 & "." I do not know why
you said to use A2 in the formula listed below.

Can you let meknow.


"Stephane Quenson" wrote:

Assuming that your first e-mail address is in cell B2, type the formula in
cell C2: = A2 & ", "
Copy this formula down your range up to cell C501 or sos. Now, column C
contains e-mail addresses followed by a comma, and you can "take" them 50 by
50 with a mouse selection, copy and paste in your e-mail address bar.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to send email to a list of people in excel sheet? David Excel Discussion (Misc queries) 1 December 14th 06 01:46 AM
Email worksheet from a list of names and email Rookie_User Excel Discussion (Misc queries) 1 December 3rd 06 08:56 PM
how do you turn an email address list into an Excel csv or txt file? Weber1 Excel Worksheet Functions 5 May 8th 06 04:10 PM
In XP how do I merge Word doc with Excel list and email? macinga New Users to Excel 1 January 12th 06 04:39 PM
Need help cleaning up an email list in Excel Amie G Excel Discussion (Misc queries) 2 October 7th 05 12:15 AM


All times are GMT +1. The time now is 01:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"