Email addresses in Excel need to format for mass email



  • 1. vlookup error
    I am trying to create a lookup formula to pull data from on worksheet to another. On tab 1 there are 2 sets of data for two different publications, on tab 2 cell a1 I want to lookup the value from tab 1 total column for pub 1 and on tab 2 cell b1 I want the total from pub 2. The spreadsheet is laid out as follows: Tab 1 Customer|Customer #|...|Pub #|Total Any Co. |847300001 |...|Pub 1|$1.00 Any Co. |847300001 |...|Pub 2|$2.00 Tab 2 Customer|Customer #|Pub 1 Total|Pub 2 Total Any Co. | 847300001 | $1.00 | $2.00 I have all the info on tab 1, and most of tab 2. I just need to make a formula to lookup the pub total for each pub.
  • 2. Function help requested please
    Hello to all I have worked with functions in other programs, but I am totally new to Excel. Here's my situation - I have a table like the following that extends for 10 rows. A B C 1 0 50 700 2 50 100 1600 3 100 150 2500 4 150 200 3400 etc... F G 20 174 =??? I want a function in cell G20 that takes the value in F20 (in this example, 174), then determines what range that number falls in in columns A & B (in this case, 174 is between A4 and B4), then returns the corresponding value from C4 (in this case, 3400). I should mention as well that the range A4 to B4, for example, means greater than or equal to A4, but strictly less than B4. Much thanks for any help! -- cinnie
  • 3. edit the cell contents command in Excel 2007 macro
    In Excel 2007, I want to write a macor which edits the cell contnets and goes to right or left adjacent cell and again eidts the cell contents. Will higly appreciate the suggestion and or s,advice. Thanks.
  • 4. Disable automatic text wrap?
    It appears that when one cuts and pastes from one Excel spreadsheet to another, it automatically assumes that you want to wrap text if the column is too narrow. Since I almost never want that, I have to go into the "format cells" area and uncheck "wrap text" every time. Is there any way to change the default treatment from "wrap text"?
  • 5. formula x % format
    I have the following numbers 412 493 1093 Totais 1998 And I need the percent, so I used 412/1998, 493/1998 .... I found the following values 0,206206206, 0,246746747,0,547047047. Id like to format with % and zero decimals. When I use this format I have a problem: the percent values do not sum correctly. 21%, 25%, 55% and it sums 101%. What can I do?

Email addresses in Excel need to format for mass email

Postby Qm9vbWVy » Sat, 10 Jun 2006 07:47:01 GMT

I have a list of email addresses in Column A extending from row 1 to row 
1200.  I need to format these for mass email from Outlook in the format 
 XXXX@XXXXX.COM ;  XXXX@XXXXX.COM ....etc. so I'm sending out one 
email to 1200 recipients. How do I format these addresses for this purpose in 

Re: Email addresses in Excel need to format for mass email

Postby Ron de Bruin » Sat, 10 Jun 2006 21:46:57 GMT

Try this

Regards Ron De Bruin

Similar Threads:

1.Emails in Excel format, need to send out a mass email from list

I have a excel spread sheet that has many email addresses listed. I need to 
find a way to be able to take those email address' and put them into a email 
that is going out to a club of over 100 people. How can I do this? Is excel 
not a good way of storing this ino? I will be using this email list often. I 
am recieving it from another person. Thank you for any info that will help 
with this.

2.outlook has an invalid email address and I need current email

Outlook has an invalid email address and I need to send an email using 
outlook but it keeps sending email to an email that no longer exists.  I need 
for outlook to delete the invalid one so I can resend email to current email 

3.Transfer Email addresses from spreadsheet to email address book

I need to transfer a list of email addresses (approx 500) which are currently 
in an excel spreadsheet to individual email addresses (in email address book) 
which will be located in a folder in the address book itself.

4.Converting Text email addresses to Hyperlinked email addresses

I have just received a spread sheet where on column contains email addresses
(1600). the column format is text format, and I would like to convert into a
hyperlinked email address, so that I can email directly form the sheet. Is this
a change one address at a time? Or, is there away to do it all at once?


Michael Koerner to Email merge email address from excel for mass emailing?

6. export email addresses of people we have sent emails to to excel

7. Emailing Publisher Newsletter using Excel email addresses?????

8. Send data from Excel in email from specific email address

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 43 guest