Computer Support Forum

Solved: Excel Macro to convert email addresses to names

Question: Solved: Excel Macro to convert email addresses to names


I have a list of email addresses that have either:
[email protected]
[email protected]
[email protected]
or no corelation to [email protected]

I'm looking for a macro that will take the emails with dots in them and put the first and last names into cells next to the email. The others I can do by hand. PLEASE HELP!

Relevance 100%
Preferred Solution: Solved: Excel Macro to convert email addresses to names

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: Solved: Excel Macro to convert email addresses to names

16 more replies
Relevance 99.22%


I've got a spreadsheet with lots of names and email addresses in grids. These are spread across several workbooks, each being a different department. What I want to be able to do is, if a name or email address occurs in the worksheets more than a set amout of times for this to be either flagged up or highlighted. Does anyone know if this is possible?

Any help appreciated


Answer:Counting names and email addresses in Excel

11 more replies
Relevance 79.54%


I need to come up with a simple outlook macro (or script?) that fires off whenever a new email meeting certain criteria is received.

1. new email is received with "please refresh quotes" in the subject
2. outlook runs a macro that causes another macro to run (the second macro is located in a excel workbook which is already running in my office pc)
3. the excel (attached) is simply refreshing market prices and emails whenever the macro is triggered. because the quotes are obtained via a DLL feed I can only get it at work.

the purpose is simply to get live market quotes on my personal email from my work email whenever i need.
thanks in advance for your help.

Answer:Solved: Run excel macro when new email is received

9 more replies
Relevance 79.54%

I have 3 columns with data as follows - Col A First NameCol B SurnameCol C AddressPlease advise how I can sort so the surnames are put into alpha order (A to Z) but Col B & C follow correctly for the surname?Thanks David

Answer:Excel Alpha order of Names & Addresses

Select all the data, Data > Sort, sort by column B ascending.

3 more replies
Relevance 78.72%

I receive a lot of email that's already been sent to 500 or so other people. The names and addresses of those people is at the top of the email message. When I want to forward a particular piece of email that contains all that info, how do I get rid of the names and addresses so that the email message appears to come from me and not everybody else on the planet? Hope someone can help with this - I've put up with it for several years - and enough is enough!!! Thanks.

Answer:Getting rid of names and addresses in forwarded email messages

6 more replies
Relevance 78.72%

I have a PDF file full of addresses (>3000) in this format:

Street Address
City State Zip
Phone Number

Is there any program that will allow me to convert it into a Excel file or CSV?


Answer:Convert PDF addresses to Excel or CSV?

12 more replies
Relevance 77.9%

I have 40 ship to locations that I use frequently in my quote template. Is there a way to create a menu / drop down of the City's name - click it and it fills in 5 cells of information vertically, Company,StreetCity, State, ZipPh#NameAs this is a template it can be in the same workbook just on another tab

Answer:Excel macro for shipping addresses

You could set up a VLOOKUP Table with the values in the first column being the list that is used for the Drop Down. Let me explain...Let's say I create this table:
1 Akron, OH 11111 CompanyName 1 Address 1 P-Number 1 Name 1
2 Olean, NY 22222 CompanyName 2 Address 2 P-Number 2 Name 2
3 Manse, FL 33333 CompanyName 3 Address 3 P-Number 3 Name 3
In the cell where the City goes (e.g. A7), I would create a Data Validation Drop-Down list that is populated with the values in A1:A3In A5 I would put this formula to pull the CompanyName associated with the city chosen from the Drop Down.=VLOOKUP(A7, $A$1:$E$3, 2, 0)For the Street, I'd put this in A6:=VLOOKUP(A7, $A$1:$E$3, 3, 0)The same concept would be used in A8:A9 for the Phone Number and Name.Posting Tip: Before posting Data or VBA Code, read this How-To.

2 more replies
Relevance 77.9%

I found how to send an email from an Excel Macro (

Here is the code I'm using:

Sub Email_Test()
' Macro11 Macro
' Keyboard Shortcut: Ctrl+r
Dim eSubject As String
Dim Sendto As String
Dim CCto As String
Dim Body As String
Dim app As Object
Dim Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
'Populate variables

mSubject = "Excel EMail Test"
Sendto = "[EMAIL="[email protected]"][email protected][/EMAIL]"
CCto = ""
mMessage = "You have received Knowledge Document Feedback for your domain."

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Sub
Is there a way to format the message section with bullets? How about paragraph breaks?

Name: John Doe

Date: 6/15/2012
Doc #: KM123456
I'm perfictly willing to look at how-to documentation if someone can point me in the right direction.


Answer:Solved: Formatting Excel Macro Email Message Section

Hi, I haven't really looked myself but instead of bullets I generally use a dash and a tab
Paragraph as such are not possible but you have the linefeed and carriage return

example to add to your macro code before calling the mail proc

Dim mytext as string
mytext = vbnullstring
mytext = "Dear Jon Doe" & vbclrf & vbcrlf
mytext=mytext & "-" & chr(9) & "Date :" & the date variable & vbcrlf
mytext=mytext & "-" & chr(9) & "Doc #:" & the dos variable & vbcrlf
mytext = mytext & "-" & chr(9) & "Etc :" "etcetera"
mytext = mytext & vbcrlf & vbcrlf
mytext = mytext & "Sincerely yours," & vbcrlf & vbcrlf
mytext = mytext & "Jane Doe" & vbcrlf

vbcrlf can also be replaced wij Chr(10) or Chr(13)

See it this helps.

Maybe html formattingis possible but this works just as fine.

3 more replies
Relevance 77.49%


I am trying to classify and code my inventory items in excel.
My classification sheet contains data in columns which I would like to copy to rows in another excel sheet.
Here is the sample data in ACMOTORS-ATTRIBUTES sheet:

The above sheet has to be converted to columns as in Item_Classificatios_Form sheet :

Can anybody assist me in writing a macro for the same.


Answer:Solved: Excel Macro to convert Rows from one sheet to columns in another sheet

8 more replies
Relevance 77.08%

Hi all

Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Sub SendThis_ActiveWorkbook()

Dim Recip()
With ActiveWorkbook

ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="[email protected]"][email protected][/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="[email protected]"]example[/EMAIL][EMAIL="[email protected]"][email protected][/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With

End Sub
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!

Answer:Solved: Excel email macro auto-populate subject line

Subject:="Vacancy Authorization " & Range("A1").Value & " " & Format(Date, "dd/mmm/yy")


2 more replies
Relevance 76.67%

After upgrading from Win 2K to Win XP Pro, and Office XP to Office 2003, some of my Excel macros that fetche data from Factset in a batch and create multiple sheets no longer rename the sheet tabs on one of the 3 PCs I use at work. The other PCs with the same upgrade do not have this problem.

The tabs are supposed to be renamed with the descriptive data from respective sheets. These macros were created over 4 years ago and it was the first time that it failed.

Another VB based application built by Factset in 2002 which uses Factset' s Script function to fetch data from its PA application and export the results to Excel also is having seemingly related problem.

The process is supposed to create multiple reports and export them on separate sheets in the same workbook. However, even though the reports ran through and created a big file, it ended deleting all the other sheets except the last one with a tab name "Sheet1 (x)".

What could be the possible sources for this problem and how canI get around it?



Answer:Excel Macro no longer names sheet tabs

8 more replies
Relevance 76.67%

I have a a list of forenames in B column and a list of surnames in C column. In the A column I need to display the first letter of the forename and the surname so for example andrew smith becomes asmith. I also need to prefix this with PADD1_ so i finish up with PADD1_asmith. An added difficulty is each name begins with a capital letter and it needs to be converted to lowercase in the process.

I have a list of approx thirty names to convert into the A column. Is this possible? thanks in advance

Answer:Excel Formula or Macro needed for names list.

Type this is in the first row and copy down
="PADD1_ " & LOWER(LEFT(B1,1)) & LOWER(C1)

2 more replies
Relevance 76.26%

I want to put names listed in an Excel spreadsheet into a Word document. I would like for the names to be able to go into paragraph form.

Answer:Convert list of names from an Excel worksheet to a Word Doc.

Possibly one of these links may help... The third one seems to cover situation similar (but more complex) to yours?

3 more replies
Relevance 75.85%

I have a variable length 3 column spreadsheet with headers that can have as many as 5000 rows.Col C contains multiple email addresses in each cell separated by a semicolon and a carriage return. Some cells may contain spaces between the next email address. Also, some cells in the Column may be blank. I need to remove ONLY the * email addresses but keep all of the others. Example Col A = Company Col B = Status Col C = eMail addresss (i.e., [email protected]; [email protected]; [email protected])After the code is run I would like Col C to be [email protected]; [email protected] (Cols A & B remain unchanged).This is the code I'm using but it gets an error which I THINK is due to the blank spaces and/or cells in Col C.Sub symaxf(): Dim n As Long, r As Long, S As String, T As String, ZFor r = 2 To Range("C" & Rows.Count).End(xlUp).RowS = Trim(Range("C" & r)): Z = Split(S, ";")For n = LBound(Z) To UBound(Z)If Len(Z(n)) < 4 Then GoTo GetNextIf InStr(1, Z(n), "") Then GoTo GetNextT = T & ";" & Z(n)GetNext: Next nT = Right(T, Len(T) - 1): Range("C" & r).Value = T: T = "" <== This is where I error outNext rEnd SubAny help would be greatly appreciated! message edited by symaxf

More replies
Relevance 75.44%


I want to convert Excel macro to Executables, so that i can call that from another application to run.

let me know, if u have idea on it..

Nagarajan S

Answer:Convert Excel Macro to Executables

you need to put your code in the "This Workbook" section of the project.

Private Sub Workbook_Open()

End Sub

You can easily access this by right clicking on the Excel icon in the top right corner of the Excel window...choose "View code".

Any code there will execute when the book is opened, set your Excel Security (Tools/macro/Security) to "LOW" so it will not be held up by the pop up to enable macros

3 more replies
Relevance 74.21%

Dear All,

I am using Outlook 2003 and receive many emails a day with huge attachments, you all know what that means.
I am looking for a macro that I can run on a specific inbox folder to store all attachements of that email inbox subfolder into folders on my harddisk. But the macro should create subfolders with the senders names so that I can easily find the attachments and asign them to emails. The makro should also add a comment to the email that the attachement has been stored on a certain date to the HD.

Does naybody have an idea how to solve this ?


More replies
Relevance 74.21%

Hi, I'm new to macro. Hope you can help me with my problem. I've been stuck with this for a week with no result.

I have this table:

001 002 003 004
111 115 119 123
112 116 120 124
113 117 121 125

Let's say, the first row are the StoreID and all other digits below them are the ProductID

I want to convert this table into something like this:
001 111
001 112
001 113
002 115
002 116
002 117
003 119
003 120
003 121
004 123
004 124
004 125

I haven't made any macro before in MS Excel and this one is really getting the breath out of me.

Hope you can help me please.. I'd really appreciate it.

Thank you in advance!

Answer:Help with Macro in excel - Convert Rows to Repeating Columns

is this just a "one off" thing or do you have many sheets to convert? Because for one or a few sheets, it is not a lot of work to do manually...probably take a few minutes ( I 'll explain if you need)

to automate I can do it, but I need to build some loops and references to refer to the columns and ranges to move to a new's a bit of work.

Please confirm also if it is only 4 columns, and or if the column count varies

1 more replies
Relevance 70.11%

Hello I have extracted a large amount of data from Visio and have to compile email addresses from the data. One column has first names another column has the surname.The company email addresses are in this [email protected] All the formulas that I use advise that there is an error regarding the "_"Is anyone able to help with this? Thanks

Answer:create email addresses with a _ from excel

re: ...there is an error regarding the "_"...What error?With this data...
1 First Last Company
I used: =A1 & "_" & B1 & "@" & C1 & ".com"which returned:[email protected] turned it into a click-able email address hyperlink which opens my email app.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 70.11%

Is there a way to add email addresses to the To: line when using SendMail from VBA in Excel?

I have a macro that creates a report as a new workbook (not saved) to send out and opens a dialog. What I want is to auto add the addresses rather than add manually then review before sending. I have found several ways to do it but either need you to save the doc (Outlook.Application) or revert to sender (routing) or send without review (Mailto).


More replies
Relevance 70.11%

I have a list of email address (i.e. [email protected]; [email protected]; [email protected]) and they are all in one field in excel, how do I separate them so each email is in its own field in a column?

Answer:separating email addresses in excel

Data...Text To Columns...Delimited...;Copy...PasteSpecial...Transpose

4 more replies
Relevance 70.11%

I want to add a list of email addresses to an excel document. The email addresses are separated by commas only so when i paste them in they all end up in one cell. Help!!?!!

Answer:add email addresses to excel sheet

What your looking for is Text to ColumnsJust use Delimited, and select CommasMIKE

2 more replies
Relevance 70.11%

I want to extract email addresses from emails people send me with a large number of emails in the email. Some times people send emails with many other emails in the send line (bad email ediquitte) and I want to extract them in to an excel sheet showing the email in one column and the person's name in another column. If possible, seperating the fist and last name too.

Answer:extract email addresses to Excel

You could add each one to your Contacts and then Export to an xls(x) file.

2 more replies
Relevance 69.29%

I need to revise a script to forward updates to multiple email addresses. I'm attaching a script but don't know how to make it apply to more than one recipient. Anybody out there have any clue on this?

Answer:Excel Script to add multiple email addresses

7 more replies
Relevance 69.29%

I have saved my contacts to an excel spreadsheet. I opened my windows live mail and clicked on import, and followed the directions. out of the 5,000 email addresses, only 233 imported into my contacts. why is this? is there a limit on how many email addresses you can import at a time or is there a limit to how many contacts you can actually have in windows live email?

More replies
Relevance 69.29%

Hi Rollin,
Appreciate your help in this area of my project. I am new to this interface; have tried this vba script from your website and I managed to import the contacts and create the distribution list. In the Outlook address book; I notice I have duplicate record of the same contact e.g. Fitz Bob (email address) and Fitz Bob (Business Fax). During the creation of the Distribution List my Outlook display the email address on the Name and Email columns.
My objective is using the excel worksheet to import the contacts into the distribution list in Outlook.
Appreciate if you can let me know where my mistake is.

*** I have attached Excel worksheet file with vba macro script in it.

More replies
Relevance 69.29%

How to Extract Email Addresses From Excel Spreadsheet. How to extract emails from different cells into a new sheet.

Answer:How to Extract Email Addresses From Excel Spreadsheet

Without knowing the layout of your spreadsheet, it is impossible for us to answer your question. You need to supply some more details.If you are going to post any example data to show us how your spreadsheet is set up, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 68.88%


Ive been searching the net for help with this and i just cant find what im looking for.

Im still new at excel macro's so still learning everyday.

I need help to wright a macro that will search in a folder for a file with a specific keyword that can be in the file name.

example: lets say i want to open a file that is in a folder that has "leadership" in the files name.
Because i send the file to people called "leadership.xls" and i recieve files back called "copyofleadership.xls" and different other names but there will always be leadership in the file name.

Can anyone please help me with this.


Answer:Excel macro to open a file in a folder with a specific keyword in the file names

6 more replies
Relevance 68.88%
Question: Excel Email Macro


I am trying to write a macro in Excel 2003 to automatically send an email using Outlook to a list of individuals asking them to confirm their personal details using the attached template. Could someone show me where I am going wrong with the script please?

Many thanks

Answer:Excel Email Macro

16 more replies
Relevance 68.88%

Any way of controlling the time a email is sent via a excel spread sheet using vba?

Answer:Excel - macro email-

6 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi All,

I have a spreadsheet and i am needing to create a macro that will opena new message in Outlook and populate the 'To' Field with one cell and then the 'CC' field with 2 email addresses, one from one field and the other from a different field. then the subject from another field and then the body from another. it then leaves the message window open so i can check it right and hit send.

I found the script the other day but can not find it anywhere including this site.

Any help on this will be great.



Answer:Excel Email Macro


You could use this function, just pass the values to it

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function

It's from one of the posts, I do not remember which one

1 more replies
Relevance 68.88%

I have an Excel model (office 2000) which has a range of cells that contain if/then statements. I'm trying to get Excel to automatically send an email if any of the cells within that specified range were to provide a value that was false. Is this possible? Thanks for any insight.

Answer:Email Macro in Excel??

16 more replies
Relevance 68.47%

this is how I have all my data. there are more than 200 contact info. Everything is in column A and I'm trying to retrieve only the email addresses and paste them in another column. How can I separate the email address???? COMPANY NAME ADDRESS Phone: Fax: Email: [email protected] Web: www.test.comI have excell 2010

Answer:How to extract/retrieve email addresses from an excel sheet?

Enter this in B1 and drag it down as far as you need:=IF(LEFT(A1,5)="Email", RIGHT(A1,LEN(A1)-7),"")Select Column B and do a Copy...PasteSpecial...Values to eliminate the formulas and leave the text.Sort Descending to bring all of the email addresses to the top of Column B.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 68.47%

Hi everybody,

I work in accounting (yeah I know loads of fun )... I have a spreadsheet that I have created to log the cash drops of several cashiers (about 140 currently) that compares it to the readings on our different point of sales systems.

this file has 31 tabs (one for each day of the month) and each cashier has the same row for his/hers information thruout the month. Each day we log how much people are dropping in cash/travelers checks, etc and compare it to what the system is telling us that they should have dropped.

Our policy is that any variance in above $10 (over or short) needs to be investigated by the manager/supervisor of the area in question and the general cashier and income audit manager should also be notified.

What I would like for excel do (not sure if it is possible) is after the general cashier logs the drops and excel tells me if each cashier has a variance above the threashold or not; to send an e-mail with the row containing the cashier's information for that day to supervisor/manager and the accounting folks involved automatically.

I am pretty novice when it comes to VBA and as much as I have been looking online and specially in this forum I haven't been able to come up with a solution to this.

Thank you in advance to anyone that can point me in the right direction.

Answer:EXCEL - Email rows to various addresses based on certain criteria

Well I guess nobody has any ideas

2 more replies
Relevance 68.06%

Hello all;

I am new to this forum and also to Excel macros. I have a large Excel file detailing financial accounts with my small business.
Anyway, I would like to email any customer who has an overdue balance as per column V in my attached sample file (any customer with a greater than zero value in V). I would like to send an email; something like this:

Joe Wilson;
As of 2/28/11 (latest date in the row that is on/after the current date), your account is currently overdue and you owe $1500.00 (G3).
Thank you.
I found several other threads explaining how to send an automatic email from Excel, but I haven't found one for sending an individualized email to a list of recipients. If this question has been answered, please feel free to redirect me. Otherwise, I'd appreciate any suggestions. Please let me know if I can detail my needs any better.

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

PS: I just corrected something I came accross and have re attached the corrected sample

2 more replies
Relevance 68.06%

I have a user who wants to create a macro which will automatically send an excel spreadsheet into outlook and email it.
Any suggestions welcome. Thanks.

More replies
Relevance 68.06%

My sense is this is a pretty simple request, but I'm completely illiterate when it comes to VB.

I have an excel spreadsheet with a number of data points. I'm looking to export the entire sheet to a CSV file and send it via Outlook. Any suggestions?

More replies
Relevance 68.06%

Windows 7 --------------------------------------------------------------------------------First thing...I know nothing about macros!! I do know a very little about formulasI have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" numorous times,then hit send again on all the emails, can we automate this some how, like a macro that engadges when I open my outlook every morning?Thank u

Answer:Need Macro to automate email from excel

I have written code in Outlook, which is essentially a template, you fill in the details, all sorts of stuff happens accordingly to what you have selected, and you press send and it will send the emails to whoever it is you want. Iv done this in Outlook, so my question is, why do you need this to be done in Excel? is Outlook acceptable?

3 more replies
Relevance 68.06%


I am trying to help someone do a mass emailing for marketing his product and have 2 questions please. He uses Outlook 2010, WORD 2007 and a "newer" version of EXCEL. The email addresses are in an EXCEL spreadsheet. The general message, which contains pictures, is in a WORD document.

1. Is there a way to automate sending an individualized email to only one address at a time?

2. Can the message (the WORD doc) be inserted instead of attached?

Thank you in advance for your help!

More replies
Relevance 67.65%

There is a same Thread and its telling very clearly how to do this task but my problem is if file is in another Language then how to do this task. Thanks In Advance.

Answer:Solved: How to convert folder, subfolder and file names into text.

There is also a /A switch that uses ASCII instead of extended characters. This let's you redirect output directly to a text file. Not quite as nice looking, but easy to automate.

Tree E:\ /A /F >"%Userprofile%\Desktop\Tree.txt"

1 more replies
Relevance 67.65%

I have a CD with a bunch of folders with a bunch of files and subfolders with a bunch of files on it.

Does anyone know of a free utility to capture those folder and file names into something that I can manipulate (Text, Excel, Word, etc.)? I have found a couple but the ones I found only do 1 layer at a time. I would like to get all the information in a tree structure format.

Answer:Solved: How to convert folder, subfolder and file names into text.

14 more replies
Relevance 67.24%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Many thanks in advance for your help guys. This means a lot.

More replies
Relevance 67.24%

Hi - I have a list of names for a particular company where I have the first name and last name of the customer plus the email naming convention their company uses. For example the company's email naming convention is: [email protected] Is there a way I can create an Excel Macro that will automatically create the email from the available information? For example if I create three columns where one has the first name, last name and the hope someone can help with this as it will save a lot of time!!Thank You!

Answer:Need Excel macro to creat email address out of just a name

This can be done fairly easily, but I'm not going to offer any suggestions.Since it appears that you do not work for this company, I can only assume that this will be for some sort of mass, unsolicited mailing. If your project was sponsored by the company in question, they would supply you with a distribution list and you wouldn't have to build your own.For all I know, I'm on that list of names that you have and I don't need any more unsolicited email.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 67.24%

Hi there,

I have a workbook which i would ideally like to send an automated mail when the date is within 30 days of "Todays date" .
I have found something similaar on past posts whichprints certain cells to an email but is triggered by a button press not date, but wondered if anyone could adjust it for me as my excel knowledge is very limited.
I really am struggling.

The password for the spreadsheet is Kalibratedbyme (capital K)

Best regards and many thanks!

Answer:macro to allow a date to send an email in excel

The content is different but why are you duplicating a post?

3 more replies
Relevance 66.83%

I use Outlook Express 6.0 I receive emails in a fixed format & that format is:

A new inquiry from Website has been posted
Name :___________
E-mail :___________
Phone No :___________
Mobile No :___________
City :____________
Other :___________
This mail should be responded within 48 hours

Now I want to convert all these emails to MS Excel(2002) so that I can have all these fields in different colums. Is this possible? Can somebody help?

Answer:How to Convert MS Outlook Email data to MS Excel

16 more replies
Relevance 66.83%
Answer:convert email id to another email id in Excel

Please do post your question more than once.I have deleted your previous post of the same question.DerbyDad03Office Forum ModeratorClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 66.83%

I have a large email group - over 200 names - in Outlook Express Address Book. A number of outdated email addresses bounced back to me. I wish to remove them from my Group. But OE seems to list only names, not email addresses. I cannot find a way to search by email address. Therefore I am faced with the task of looking up each name's properties to see if it's the email I need to eliminate.
Surely there must be a better way!
Or should I just find a better program to use? If so, suggestions?

Answer:Solved: Removing email addresses from Outlook Express Email Groups

you can always use the contact search bar at the top, enter the email, then that corresponding contact should appear. delete that contact and it will be deleted from any groups.

3 more replies
Relevance 66.42%

Hi there - Using MS Access 2007.
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.

Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.

Can someone suggest a better way of handling this that is not time consuming?

Thanks In advance!

Answer:MS Access 2007 - Macro > Excel > Auto Email

Access can open Outlook and send an attachment to mutiple recipients either as a list or as individual emails.
So are the attachments all the same for the recipients?

1 more replies
Relevance 66.42%

I need help writing a macro that takes an Excel file to email.

The Excel file is a data base, I wanted the Macro to take the email from a column of the Excel file, and send out the email to all the emails in the database, if possible also adding a column of the Excel file to address the specific person.

thank you.

Answer:need help writing a macro that takes Excel file to email

Can you post a sample file? Please remove any sensitive data.


2 more replies
Relevance 66.42%

I found this code in this forum.
i want to add recipient as CC or BCC. What is the correct code for that?
Thanks in advance!

Public Sub email()

Dim SubJ, Recip As String

SubJ = "Enter your suject"
Recip = "[email protected]"

ThisWorkbook.SendMail Recip, SubJ

msgbox "Email Sent"

End Sub


Answer:Send excel sheet ( email) through macro with recipient and cc

6 more replies
Relevance 66.42%

Hy guys

2nd time i am posting stuff for help, and as i was helped before i will again look forward the response.

I have a file of excel, in which i am sending emails to different candidates of admission, with scan letter placed in the same folder by name.

I want to edit this code, which could select attachment based on Column A list adjacent to the email address

I am attaching the file also pasting the code

Sub Test1()
'For Tips see:
'Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim SigString As String
Dim Signature As String
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

On Error GoTo cleanup
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

Set OutMail = OutApp.CreateItem(0)

strbody = "We at Graduate School of Engineering Sciences and Information Technology are extremely pleased to know that you have selected Hamdard University as preferred choice for your graduate/post-graduate Studies. " & vbNewLine & vbNewLine & _
"Hamdard University is a pioneer Higher Education Institute (HEI) of Karachi producing Masters and PhDs in the fields of Engineering, Computer Sciences, Information Technology, Energy and Environment since 19... Read more

Answer:Attachment based on cell value in a excel email macro

anybody ???

2 more replies
Relevance 66.42%


My first post, sorry to be a leech right off!

I'm trying to automate some of my day to day emails. I'd like to get a macro set up that will send an email from Excel and paste the range I select in to the body of the email. Would be great if it would send to a list of addresses listed on the page as well.

Using the attached example, I'd like the macro to take whatever range I highlight on the table, copy it to the body of an email and send it to the group of emails listed on the right side.

I'm learning excel, this would help me a lot! I'll be editing this to fit a variety of other tasks. I hope it can be flexible. Thanks in advance.


Answer:Macro: Email Range/Selection to group from Excel

I have done the looping attached.

2 more replies
Relevance 66.42%

I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.


Answer:Excel 2007 Macro to Send Reminder Email

desantisj, welcome to the Forum.
There are already 3 or 4 posts on this forum that have the VBA code (Macro) that you can modify for your Workbook if you can read the code. Zack has written the code so it is a bit complicated, but it should be a case of substituting your Cell references that hold the data for the ones that others have used.
Otherwise it is a case of waiting for an Excel guru to come along and help. If none of them come along I can probably help you, but I normally work with Access.

2 more replies
Relevance 66.42%

I just used some macros in my spreadsheet to paste data in visible cells.I'd like to upload the file to other application which only accept the file .xlsx like without macros.So how do i convert the file xlsm to xlsx so that no change in data happen due to macro script?Highly appreciable your help in this concern.

Answer:Convert macro enabled workbook to normal excel workbook

In an earlier thread you were asking for help with pasting data into visible cells. In this thread you say "I just used some macros in my spreadsheet to paste data in visible cells."Does that mean that your earlier issue has been solved?As far as this particular question, you can either remove the macros and save the file as a .xlsx or save the file as a .xls file which will retain the macros but not be seen as a .xlsm file. Whether the accepting application will know that that the macros are in the file is something you will have to test. Removing the macros and saving it an .xlsx file should solve both issues: acceptance by the other app and prevention of further changes because the macro no longer exists.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

7 more replies
Relevance 66.01%

Iím using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

Answer:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

7 more replies
Relevance 66.01%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you

Answer:Solved: Excel macro to extract Word form data into Excel

7 more replies
Relevance 66.01%

I am trying to create a code that will autofilter data on an Excel worksheet. The code works fine to filter the data, but it does not hide the AutoFilter Arrows.

Below is the code I am using. What (if anything) is wrong with the code below?

ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>", Visibledropdown:=False

Answer:Solved: Excel 2007 Macro -> Hide Excel AutoFilter Arrows

I noticed that the code above (in Post #1) that the AutoFilter Arrows were beinf truned off on Field 2, but none of the others.

I have played around, and done some research to come up with the code below:

Dim c As Range

For Each c In ActiveSheet.Range("A1:D1")
ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>"
c.AutoFilter Field:=c.Column, Visibledropdown:=False

Does anyone have a better solution?

1 more replies
Relevance 65.6%

So I have a batch of about 750 Word documents that need to be converted to RTF. I recorded a macro that looks something like this:


Sub rtf3()
' rtf3 Macro
Documents.Open FileName:="D:\user\Desktop\test\1.docx", ConfirmConversions:=False, ReadOnly:= _
False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
"", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
Format:=wdOpenFormatAuto, XMLTransform:=""
ActiveDocument.SaveAs FileName:="D:\user\Desktop\test\1.rtf", FileFormat:=wdFormatRTF, _
LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
It works fine, but there are a couple of problems w/ it. 1, I have to repeat it over and over for each file, and 2, each repetition has to be edited w/ the next filename, the path to that file, and the new filename. I figured out a way to partially automate that process, but it's still a PITA .

Can't I just tell it to get all the .docx files in this folder and all its subfolders and save them as an RTF w/ the original filename?

Answer:Solved: Word 2007 macro to convert file types?

10 more replies
Relevance 65.19%

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike

Answer:Excel Macro -> email created with field data as subject line

8 more replies
Relevance 65.19%

Hi all,

I need to know if is it possible that a macro in Excel sends an email containing the visible cells using Microsoft Outlook.
btw, I saw some code on the internet, that saves the visible cells in a new excel file and attach it in a new email using Microsoft Outlook, but I don't want to have attachments in the email.

thanks for any possible help.

More replies
Relevance 64.78%

Hi guys,

I have been on the lookout for a macro that will compare 2 worksheets within MS Excel and output the differences on a third sheet.

I am being directed to the URL below but cannot for the life of me work out how to implement this:

There are two snippets of code which I will include here for convenience but not sure whether these should be pasted into Workbook Code (i.e. right-clicking Excel icon left of "File" - top-left), Worksheet Code (i.e. right-clicking worksheet tab) or inserting a new Module - or some other method. Is there anyone here that could guide me to how to implement this code?

Quote from webpage - "With the macro below it is possible to compare the content of two worksheets.
The result is displayed in a new workbook listing all cell differences. "

Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
Dim r As Long, c As Integer
Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer
Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
Dim rptWB As Workbook, DiffCount As Long
Application.ScreenUpdating = False
Application.StatusBar = "Creating the report..."
Set rptWB = Workbooks.Add
Application.DisplayAlerts = False
While Worksheets.Count > 1
Application.DisplayAlerts = True
With ws1.UsedRange
lr1 = .Rows.Count
lc1 = .Column... Read more

Answer:Solved: How to use this Macro in MS Excel (compare excel worksheets)

Apologies... I have sorted this... For those that might be looking at this for help here's what I missed:

These are both Sub's that should be created as a Module - both in the same module. I am just comparing worksheets within the Active Worksheet so just removed:

' compare two different worksheets in two different workbooks
CompareWorksheets ActiveWorkbook.Worksheets("Sheet1"), _
Click to expand...

I was then able to run this from Macro's. All sorted.

Apologies again

1 more replies
Relevance 62.73%

I have an Excel file of names (like John Smith) where the first and last name are entered in a single cell. Unforturnately, the names should have been entered in two cells - one for first name and one for last name. Can anyone think of a way to break the data apart perhaps by detecting the space between the names and putting the characters before it in one column and the characters after it in another?



Answer:Solved: Dividing First and Last Names in Excel

11 more replies
Relevance 62.73%


I have the following extract of code in ecel VBA:
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[4]-'W2-1'!R[9]C[5]"
ActiveCell.FormulaR1C1 = "='W2-1'!R[9]C[2]"
I am trying to make the reference to W2-1 dynamic so that if the worksheet tab name gets changed the code will still run. I then want to maje it reference to the sheet no. which in this case is sheet 7

Can anyone advise on the required text to enable this?


Answer:Solved: Dynamic Excel tab names

7 more replies
Relevance 62.73%

Is it possble to set up a new email address on an account and still keep the old one I have Net Zero with dial up service. Thank you for any help that can give me.

Answer:Solved: Two EMail Addresses

7 more replies
Relevance 62.73%

I am compiling a list of members of a group to which I belong and I want to include the email addresses of those members in a database. However when they are typed they then change colour from black to blue and become underlined. Is there a way of just showing these addresses in their normal text format?
I use Windows XP Media Centre Edition

Answer:Solved: email addresses

10 more replies
Relevance 62.73%

I have an Invoice program that I made in Excel that automatically performs calculations based on product codes entered and quantities. I want to automate this further by keeping a list of addresses in a hidden worksheet and using a formula so that when the name of a company is entered, the address for that company is entered below. What is the best way of doing this? I have tried a LOOKUP but this will only bring up the first line of the address.

Answer:Solved: Automating Addresses in Excel

16 more replies
Relevance 61.91%

How do I copy my E Mail addresses in OE in XP to a flash drive and put them into Win 7 Live Mail? Help please

Answer:Solved: OE EMail Addresses fron XP To 7

you export from outlook express using a csv file format
then copy to windows 7 PC
and import on windows live mail

see here - a link from the MS site

3 more replies
Relevance 61.91%

Can anyone help? For some mysterious reason a good proportion of my email addresses have disappeared. Sod's law dictates that the ones remaining are those which I don't want. Anything I can do re-establish the missing addresses?

Answer:Solved: Disappearing email addresses

6 more replies
Relevance 61.91%

I was wondering how I can send lets say, 20 people and email, but they don't all actually see all the email addresses I entered. I want all their email addresses to remain private. Can I enter them in some kind of 'group'?

I'm also searching on how to send mass emails through yahoo.

I will be emailing several companies at one time and do not want them to see the other compaines names/email addresses. And I would like to send the same email, so I am guessing a blast' would be the best way to go.

Thanks for any advice!

Answer:Solved: Hiding Email addresses??? How to?

6 more replies
Relevance 61.91%

I will be moving to another state soon and would like to let the people in my OE address book know my new email address, but I won't know this address until I get to my new home and subscribe to a new ISP. How can I do this? Thanks in advance.

Answer:Solved: Moving and Email Addresses:

16 more replies
Relevance 61.91%

Well, I think if I can survive the registration process I can probably understand the answers!
Problem: I use Windows 7. I get a lot of emails where the sender has not deleted former email recipients or they haven't used bcc,
I hate to forward all those names but if I try to delete them (high light the names, hit"delete," "back space") I lose the body of the email.
This was never a problem in the last 15 years of computering. Does anybody know how to get rid of those email addresses.?
(I sure hope so.)

Answer:[SOLVED] deleting email addresses

What do you use to access your emails?

5 more replies
Relevance 61.91%

I am using outlook 2003 with an exchange server. I have noticed once I email a person every time I want to email them after that I can just type the first or second letter of their name in and it will find their email address. Can any body tell me where I find this list that it seems to store in memory somewhern. I dont mean my contact list.


Answer:Solved: exchange email addresses

It is stored in a hidden file with the extension .NK2. If you have your OS installed on C drive: C:\Documents and Settings\User Name\Application Data\Microsoft\Outlook and look for the .NK2 extension with the extension view option on. You would have to have a file editor to view this file.
I found this one, but you have to pay for it, Ingressor.
Just found this free one NK2csv, but I don't know anything about either.

2 more replies
Relevance 61.5%

Just learning (self teaching) about Group and Outlines in Excel 2003 as well as the RANGE command in VBA. (Client will not accept an Access 2003 Solution)

Perhaps the easiest way is to show what I am trying to do.
"SOLUTION" (outline level 1) "my SAP ERP"
"-SOLUTION AREA" (outline level 2) "Analytics"
"--PROCESS" (outline level 3) "End User Service Delivery"
"---Sub-process (outline level 4) "Employee Interaction Center"
"---Sub-process (outline level 4) "SAP Roles"
"---Sub-process (outline level 4) "Express Planning"
"--PROCESS" (outline level 3) "Strategic Enterprise Management"
Click to expand...

each of the sub-processes I identify as a group. each of the processes is also a group.
The cell-value in the sub process can be "yes", "no" or null.
If any of the subprocesses contain a cell value "yes", then the "owning" process must contain a "yes".
Similarly, if any of the PROCESSes in the SOLUTION AREA contains a cell value "yes", then that owning SOLUTION AREA must contain a "yes".

Now, of course, I can hard code this through a multiple "Range" VBA statements, but wonder if there isn't something more elegant.


Grnadpa Brian

Answer:Solved: Can I work with Group names in Excel 2003 VBA?

Solved this issue by using the Access 2003 Outline capability.

1 more replies
Relevance 61.5%

Hi everybody,

I really didn't know how to call this question, but I will try to make it clear.

I got an Excel sheet which contains in total over 1000 names and adresses. These adresses contain a lastname, surname and adresse etc.

Cell b10 contains for example, "Klaasen, P"
Cell c10 contains the adress of this person.

Now I would like to get the content of the b10 cell to "P, Klaasen" instead of "Klaasen, P"

Is this possible in any way? I can't find any options in Excel for doing this and I can't find anything on the internet.

Thanks in advance!

Answer:Solved: Adress list excel changing names

9 more replies
Relevance 61.5%

I'm trying to define a dynamic-range chart, as described in

I've defined the names, but they keep moving! E.g. I defined a name called "dates" as =OFFSET(Daily!K3,0,0,Lastrow-2,1), but the next time I go look at it, it might be based on A1, or K1, or AJ3, or AL1053923523 (that's approximate, but I did have it move to a similar location once!).

It seems to happen as soon as I reference one of the names. I can define the names, exit the defined-name dialog, hit Ctrl-F3 again, and they're still OK. Then I enter "dates" in the Name Box, and it highlights the correct range. But now if I hit Ctrl-F3, the name definitions have changed!?

Probably for this reason, I've been unable to actually define the graph that's supposed to use them. By the time I access them in the chart definition, they point to someplace with bad data.

What causes this??
Running Excel 2007 on Vista Home Premium SP2.


Answer:Solved: Excel 2007 -- defined names keep moving!?

6 more replies
Relevance 61.5%

I need some help on the following:
I have 2 questions:
Below is a recorded macro that selectes a number os shteets and formats the selected area as a 2-decimal percentage:

1st. question:
Sub SelectSheets()
' SelectSheets Macro
' De macro was recorded on 14/08/2008 by Hans Hallebeek.
Sheets(Array("GBR", "green", "blue", "red", "clear", "yellow").Select
Selection.NumberFormat = "0.00%"
End Sub

The number of sheets I have to select can vary, there is a list in a main sheeft where the names of the active sheets is listed.

I can read the list into an array with a a routine like
for x = 1 to range("A35").end(xlup).row
arr(x) = range("A" & x).Value
next x

but how can a replace the Array("GBR", "green", "blue", "red", "clear", "yellow") part in the line below
Sheets(Array("GBR", "green", "blue", "red", "clear", "yellow")).Select

by the contents of the array arr()?

2nd. question:
The following part Selection.NumberFormat = "0.00%"
depends on the system's International settings.
I have my system set for a . chr(46) as a decimal sympor but most of the other users have the system set to , chr... Read more

Answer:Solved: EXCEL and VBA: Dynamic array containing sheet names

14 more replies
Relevance 61.5%

How do I delete email addresses that have been stored in the address bar for auto-complete purposes in Windows Live Mail (formerly known as Hotmail). (Just so there is no confusion, I am NOT referring to the email addresses stored in my contacts list. I am only referring to the email addresses that are stored in the address bar.) Thank you.

More replies
Relevance 61.5%

I will be moving soon, and for the last bunch of years have been using a Road Runner email address as my primary email. This will have to change. I have already set up a Gmail account, which I can use either as primary for going forward or temporarily during the transition.

I would like to get some opinions on the best way to notify people to start using the new address. I am thinking that sending out a bulk email to all in my outlook contacts list, followed by an auto responder on all inbound Road Runner might work.

What have others done?

Answer:Solved: Best Practices when changing email addresses

Sounds OK to me 'cos if you notified your outlook contacts from your new gmail address then that notification might end up in their spam folder as your new address wouldn't be recognised.
After sending the notification to your contacts you can then export those contacts to your gmail account so that their replies don't end up in your spam folder.
I'll be intersted in what others have to say as well...


3 more replies
Relevance 61.5%

Hi Guys

I have installed MS Office 2007 (Small Business Edition) on a new PC (Vista Home Premium) but Outlook will only accept an email from people who are already in my address book. (Thanks Bill!)
Any idear as to where/how I can change this?


Answer:Solved: Only known email addresses accepted by Outlook


Have solved the glitch

Setting in Junk EMail option.

Safe Lists Only was selected.


1 more replies
Relevance 61.5%

I have recently purchased and set up a new computer system, and successfully transferred almost all the necessary programs and data to it. My old unit was using Windows XP, whereas the new one is running Windows 7. What I can't work out is the correct way to transfer my email contacts list (about 200 items) from Outlook Express to Windows Live Mail which is installed on my new system. I still have my old computer running separately in the meantime, so if anyone is able to advise me, I would be grateful. Many thanks.

Answer:Solved: Exporting / Importing Email Addresses.

Is this any help?


3 more replies
Relevance 61.5%

I am not using Vista hOME Premium as my main email computer. Most email now is being sent from my Notebook with XP Home as the OS. I want to take all the addresses from Vista Home Premium's Windows Mail and put them on my XP Home Notebook, so far I have not found away to do this. What is the solution?

Answer:[SOLVED] transfer email addresses from Vista

Hi. . .

I myself use Windows Live Mail, but found this link on Windows Mail itself - see if it help you -

Regards. . .



5 more replies
Relevance 61.5%

I thought I was allowing Opera to open Outlook Express for my Email client, but instead it now wants to handle all my email.
I can't figure out how to shut it off!
It appears if I delete an account from Opera's list that it actually deletes it from my Outlook Files.

Any advice or answers???


Answer:[SOLVED] Opera took over clickable Email addresses

6 more replies
Relevance 61.5%

How do you hide senders and receivers email address in outlook express when sending an email?

Answer:Solved: Send Email without showing addresses

7 more replies
Relevance 61.5%

I installed Outlook on another computer and can't access any of my contacts. I guess Outlook does not save the contacts automatically when I send someone an email. How is the quick search address installed. I think it is when I send and email to someone it remembers their address and then I can just type in the 1st letter or two of their name and will show me the email address. I replaced the PST file with the old PST from another machine. If I put some contacts in my address book shouldn't I just be able to start typing their name in a new message and the email address show up. What is the cheapest/best program for extracting email addresses in outlook from inbox/sent messages. It doesn't seem like the address book is talking to sending someone and email like it does in hotmail,Gmail. Any information would be much appreciated. Thanks.

Answer:Solved: Extracting Email addresses in Outlook

6 more replies
Relevance 61.5%

I've never had reason to send multiple emails, so this was a first. I myself hate it when people do it and reveal my address. So I wanted to be sure that I didn't do the same. I addressed the email to myself and placed the group list in the CC. I also sent one to another of my email addresses to see that all went a-ok. To my shock everyone's address is showing. What did I do wrong? I think now another multiple email is in order with my apologies.


Answer:Solved: multible email addresses, what did I do wrong?

I've solved it. I forgot to send it BCC. Thanks.

3 more replies
Relevance 61.5%


I have a workbook with 3 columns.

Column 1: Network address
Column 2: Subnet bits
Column 3 An IP address

For each row, need to check if the IP address in column 3 is within the IP range specified by columns 1 and 2.

If the IP address in column 3 falls within the range represented by values in column 1 and 3 need to display TRUE in column 4 of that row. Otherwise need to display FALSE.

Anyone who is able to do this using formulas only is a genius but VBA solutions are also welcome! Thanks!

Answer:Solved: Use Excel to check if an IP address is within a given range if addresses

I don't think this is quite so hard as you make out (for formulae), but anyone who wants to help will need more information. What format are you putting the addresses and subnet bits. Better still can you please post a sample spreadsheet?

3 more replies
Relevance 61.5%

Hello Helpful Folks,

I have searched with no luck for a solution to my problem. Here's the rundown:
Running Windows XP
Using Outlook 2007, Excel 2007

I want to take a database in Excel and import it into Outlook. Not sure if my screenshot is attached, but I do not have an option to "Import/Export" under File. Any other way around this?? Thanks for the help.

Answer:Solved: Cannot Import Addresses from Excel to Outlook 2007

6 more replies
Relevance 61.5%

Tried doing this but I get scattered pieces imported.

Got as far as dragging address from an excel file to email field in Outlook, but get an error and bits and pieces.

Don't want to import one by one.

i shortened the excel file to just one column with e-mail addresses.

Got to be a way.

Answer:Solved: Import e-mail addresses to Outlook from Excel

Hi holymoly

In the Address Book in Outlook Express, enter at least one contact.

Then Export the Address Book as a Text File (Comma Separated Values) (.cvs) file to the Desktop.
This will give you a template to work with.

Open the .cvs file and paste the e-mail addresses into the correct field.
Save and close the .cvs file, then Import it into the Address Book.
File > Import > Other Address Book > Text File (Comma Separated Values) > Import
Browse to the .cvs file on the Desktop.
Let us know if that works for you or not.

2 more replies
Relevance 61.09%


I've used this site to create my current excel file; it works pretty good but now it need the evolve and I require some help.
I'm sure there are easier ways to get what I need; I am no expert at macro writting so please bare with me.

THe file current creates graph for me; 'data input' has a button where i input the locations i require a graph for and it simply selects info (from a master file database) and pastes it into 'sheet2' where a graphs exists.

the code is written so that it will go to a pdf print screen for me to input the name and save. this worked well but now there are so many locations that i would like to automate some functions.
what i would like the update to do is the following;

-'results table', column A, "Location" will have several locations listed (only in the white blank spots). I need the macro to generate a graph for each location listed.
-for this to occur, it makes sense that I would also require the pdf to automatically name each file ~ naming it the location that it was looking up (otherwise i will have a bunch of pdf save as files open and i wouldn't know which was which.
any and all input would be greatly appreciated. i also looked up the auto name pdf file; i did not include my attempts to add as it kept getting hung up at the 'save as' file box. i can share my pregress on that if you like.

below is my current code. Please email me so that i can send you the file a... Read more

Answer:Solved: Excel Macro help

15 more replies
Relevance 61.09%

We are using macro fro creating P.O.B. lis ( persons on board) , from the 3500 persons, copying only those who is on board at the moment , then grouping them by company and than sorting in alphabetical order in each group.
Now is the challenge : Is that posiible to modify macro or add another function to it to make it sort personnel of first company in the list by rank / position?
I am almost green in scriptin, but very interesting in it , but now my boss wants to see Himself on top of the list He's last name not starting from A
Thanks in advance...

Answer:Solved: Excel macro help

12 more replies
Relevance 61.09%

Hi Friends,

I'm very much new to Macro in excel. I wanted to Run Macro in the following situation :
I have 2 Excel Book having same header but some data which to be consolidated in a 3rd Book. I recorded macro in 3rd Book the macro function is to " to open Book 1 & Book 2 & consolidate in Book 3" on running the recorded macro.

But after saving the macro and running tha macro again with some new data in Book 1 & Book 2 it gives the following error message "Run-time error '9':
Script out of range

and on debug the following macros are displayed.
Sub Macro2()
' Macro2 Macro
' Keyboard Shortcut: Ctrl+l
Workbooks.Open Filename:= _
"C:\Documents and Settings\Administrator\Desktop\Book2.xlsx"
Workbooks.Open Filename:= _
"C:\Documents and Settings\Administrator\Desktop\Book1.xlsx"

Selection.Consolidate Sources:=Array( _
"'C:\Documents and Settings\Administrator\Desktop\[Book1.xlsx]Sheet1'!R1:R1048576" _
, _
"'C:\Documents and Settings\Administrator\Desktop\[Book2.xlsx]Sheet1'!R1:R1048576" _
), Function:=xlSum, TopRow:=True, LeftColumn:=True, CreateLinks:=False
End Sub


can anyone help. I'll be very much grateful to you.

I'm using excel 2007 but I dont think it has got to do something with macro!

thank you in advance.

&nbs... Read more

Answer:Solved: Help in macro (Excel)

This message usually occurs when the code is trying to call a workbook or worksheet that is not available. Your code opens two workbooks from your desktop (Book2.xlsx, Book1.xlsx) and then is trying to activate a workbook called Report.xlsx. If this workbook is not already open then you will get the error. You need to add some code to open the workbook prior to activating it.


2 more replies
Relevance 61.09%

I have an excel report (tab name is "sample report")that lists many rows of data (each row is a new case). In column "H" it lists who is working on each case. Column "I" lists dates. If a date is shown then that means the case is closed. If the cell is empty that means the case is still open.

What I need is a macro that will copy all of the "Open" cases from the "Sample Report" tab and put them into the other tab "Open Case Log" under the specific names in column "H". I have put 5-10 blank rows under each name on the "Open Case Log" tab but I am never sure excalty how many open cases each person will have at any given time. This is where I am having the problem. I have attached the sample excel report.

Any and All help would be greatly appreciated.

Thank you.

Answer:Solved: Need Help with Excel Macro

16 more replies