Computer Support Forum

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

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

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!

Relevance 100%
Preferred Solution: Need Excel macro to creat email address out of just a name

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: 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 73.8%

I have a word document that includes a form the user must fill in. I want to create a button that will do all of the following:
1. Update all fields
2. Attach the updated word document to an email
3. Enter an address I have stored in the macro into the To field of the email.

I have one module which does the first part:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
End If
Next oStory
Set oStory = Nothing
End Sub

I found that if I add this to the before End Sub it attaches the updated Word document to an email:
Application.Options.SendMailAttach = True 'Or False

However, I can't figure out how have it put a specific address into the To field of the document.

So I tried another tact. I have the email address as a hyperlink in the document, and set a bookmark at the hyperlink. Then I created a module that will go to the bookmark and open the hyperlink. However, this will not add the document as an attachment:

Sub Open_Hyperlink()
Selection.GoTo What:=wdGoToBookmark, Name:="hyperlink"
With ActiveDocument.Bookmarks
.DefaultSorting = wdSortByName
.ShowHidden = False
End With

Selection.Range.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

So then I found this bit of coding on the web, and tried imp... Read more

Answer:Word Macro to attach doc to email, then send address email

I found a solution, but I think it is a bit bulky. It seems to work but I'd love to know if there is a simpler solution:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
End If
Next oStory
Set oStory = Nothing


MsgBox "Thank you. Your order has been sent", vbOKOnly, "Thank you. Your order has been sent"
Dim bStarted As Boolean
Dim oOutlookApp As Outlook.Application
Dim oItem As Outlook.MailItem
On Error Resume Next
If Len(ActiveDocument.Path) = 0 Then 'Document has not been saved
ActiveDocument.Save 'so save it
End If
Set oOutlookApp = GetObject(, "Outlook.Application")
If Err <> 0 Then 'Outlook isn't running
Set oOutlookApp = CreateObject("Outlook.Application")
bStarted = True
End If

Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
.To = "[email protected]"
.Subject = "Promo Order" '
.Body = "Thank you for your order"
.Attachments.Add Source:=ActiveDocument.FullName, Type:=olByValue

End With
If bStarted Then 'If the macro started Outlook, stop it again.
End If
Set oItem = Nothing
Set oOutlookApp = Nothing
End Sub

1 more replies
Relevance 70.52%

Hi guys.
I'm fed up having to constantly type and retype my email address everytime I have to fill out an online form.
Can anyone tell me how to create a macro that I can use to insert my email address when asked?


Answer:How to create a macro for an email address

why not use a password manager & form filler like roboform
that is far easier than creating a macro that will probably not work on a lot of websites

2 more replies
Relevance 69.7%


I've used Tech support guy for quite a while and almost always find what I need.
I guess it's about time I join and post a question

So this is my problem.
I send out an excelreport every day.
In it I use the content in column X to populate the hyperlink address in column Y.
I've done this manually but now the report is getting bigger and a macro seems in place.
Problem is I just don't know enough about the syntax used in excel.

What I want to do is loop though each row - if there is data in column Y then check in column X.
If X is populated use the data as hyperlink address in column Y (info in Y should still be what is shown).
This should be done for each row where Y is populated.
Then the X column shall be deleted (but I guess I could do that manually )

It feels pretty straight forward and I could do it in RPG or SQL but the syntax in excel befuddles me
Any tips?

Answer:Excel macro - use info from one column as hyperlink address in another.

Assume Y2 and X2 cells
=if( Y2 = "", "", IF(X2="", "" , do Y2)

but you need to have the formula in Y and change Y - i think that may need a macro, as you are testing Y and also rewriting Y

a spreadsheet with dummy data would be useful to see

1 more replies
Relevance 68.88%

I have the following work sheet structure1- 12 months column headers, under each month 4 column headers2- 99 row headersso each month is a table ( 101 row * 4 column) and there's a space between every month table i want make a macro that enables me to table with the month table structure and to have drop down list in the month header so each time i choose the month from the drop down list the table displays that month details from it's tablePlease advice

Answer:Macro to creat drop down list

If I understand your structure correctly, I think you can do it without a macro.Here's what I did:1 - I created the Monthly tables then selected each table and named it to match the Month. In my test, the first cell (which contains January) was A1. Therefore A1:D101 is the Named Range "January", F1:I101 is named "February", K1:N101 is named March. (I only created 3 months for my testing.)2 - I created a list of Months in separate range and created a Data Validation Drop Down list to choose each month. My Drop Down is in R1. Remember, I only created 3 Monthly Tables, so I have room to use R1 for my Drop can put yours wherever you need to.Here's where it gets fun. If you don't understand this part, come on back and I'll explain it in more detail.3 - I selected the first cell where I want my individual monthly tables to appear. In my case I chose Q7. You can choose whatever cell you want, but what you do in the next step will be based on which cell you choose.4 - In Q7, I entered this formula:=INDEX(INDIRECT($R$1),ROW()-6,COLUMN()-16)INDIRECT($R$1) will pull the value form the Drop Down and use the Named Range as the reference for the INDEX function.INDEX() will pull data from the Named Range based on the row_num and col_num. With this formula in Q7:ROW() - 6 = 1 and COLUMN() - 16 = 1Therefore with January chosen from the Drop Down, the formula evaluates to:=INDEX(January,1,1) which will pull the value from A1.5 - Drag this formula across 4 Columns and down 101 Rows.T... Read more

3 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.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%
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.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 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 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 67.24%


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 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%

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%

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.01%


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!

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

16 more replies
Relevance 66.01%

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 65.19%

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 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 63.14%

I have a spreadsheet that has a contact list with email addresses. If I wanted to send one email to multiple individuals on that contact list, is there a shortcut or hotkey when selecting the email addresses so that they generate in the same email? Right now, I click on one email address link and can only insert that single email address.

More replies
Relevance 62.73%

Dear all I have a list of the following data in cell A1, any quicker option for me to extract only the email address in to cell A2? 2;"msriegler876";;"[email protected]";;"12782";;"0";"30351";"1";;"States";"Australia";;"msriegler876";;;;;;;;;;;"1";;;"0000-00-00 00:00:00";"0";"0";;"0";"0"ThanksClarence

Answer:Export email address to a new Excel column

Use the Text To Column function on the Ribbon:Select cell A1Select Data TabClick on Text To ColumnSelect Delimited, Click NextSelect Semi-colon, Click NextClick FinishAlso, Excel questions are best asked in the Office Software forum.MIKE

2 more replies
Relevance 62.73%

I have an excel file and the data in each cell is listed as:[[email protected]](mailto:[email protected])How do I create a formula to extract just the email address and put it into a new cell?

Answer:How do I extract just the email address from a excel cell?

If your data is always in the exact same format of:[[email protected]](mailto:[email protected])Then this formula will extract the first email address (between the square brackets):=MID(A1,2,FIND("]",A1)-2)See how that works for you.MIKE

2 more replies
Relevance 62.73%

I'm about to put my foot through my computer! I hate it when I go to a help screen, I understand the message I find, and the program won't behave the way the help screen says it will!

I'm running Excel 2010 which I'm comfortable with without being an expert. I've inherited a membership list file that has a column containing members' email addresses. Some of the members' email addresses in that column are formatted as a hyperlink format, so that they automatically launch my email program when I click on those entries. Some of the addresses in the same column are in a format that LOOKS like the typical hyperlink format (blue underlined etc) but which are actually simply text format. When I click on those addresses in that column, I do not launch my email program. That's how I want all the entries in that column to behave!

I do NOT want ANY of them to automatically launch my email program!!!!!!!!!!!!

I went to the Office online help and found a message for how to delete a hyperlink. It says I click and hold the cell containing the entry I do NOT want to be a hyperlink that will automatically launch my email, and the cursor will change from the pointer to a cross. OK. Been there done that. It then says Right click and in the context-sensitive drop down menu that appears, click "remove hyperlink". I can understand that, too.

But guess what! When I do that, the "remove hyperlink" entry in the drop down menu is grayed out!

What am I doing wrong... Read more

Answer:Cant unformat email address hyperlink in Excel the way HELP says I can

Whatever I try, I cannot reproduce your issue. Removing "mailto" hyperlinks works exactly as it should work both on Excel 2010 and 2013. Only way to not be able to select Remove Hyperlink in context menu is if the cell is protected, editing disabled, in which case the context menu does not even have the Remove Hyperlink item as this screenshot shows:
By default Excel adds a "mailto" hyperlink to each email address:
You do not need to Click and hold the cell, simply select it and right click, select Remove Hyperlink:
The email address no longer has a hyperlink:


9 more replies
Relevance 62.32%

I am Maintaining My commercial account in EXCEL Sheet. I do entry of Sale and Purchase in this sheet. I want that when I enter detail in sales sheet the Invoice will automatic generate in new Sheet Or Automatically create new excel sheet

Answer:Creat New EXCEL Sheet

Not only is your question unclear, but you have not provided enough details for us to offer a "I want that when I enter detail in sales sheet the Invoice will automatic generate in new Sheet Or Automatically create new excel sheet "What's the difference between " the Invoice will automatic generate in new Sheet" and "Automatically create new excel sheet"?As far as details, since we don't know how you use your workbook or what action should trigger the creation of the new sheet, there is not much that we can offer at this point.You need to provide more detail.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 62.32%

Im trying to make a net pay budget spread sheet. I have entered the federal tax chart into an excel sheet and income/hours into another sheet. How would i make a formula that would take one cell on sheet1 and parse the second sheet for "if greater than A1 but less than B1, true, display sum of "sheet1!A1" and "sheet2!C1", else, IF greater than A2 but less than B2, sum of "sheet1!A1" and "sheet2!B3", else, ...message edited by Rhain

Answer:how to creat a formula in excel

You might be able to use a formula known as a Nested IF. If you DAGS for Nested IF you'll get lots of hits, both text based and videos.In your case, it might look something like this:=IF(AND(C1>A1,C1<B1),SUM(SHEET1!A1,SHEET2!C1),IF(AND(C1>A2,C1<B2),SUM(...Depending on how many conditions you have this could get quite cumbersome. Perhaps with some more details we could offer an alternative method.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 61.91%

I have a column of about 100 email addresses which are, at the moment, in text form. I know by right clicking on an individual email address and choosing hyperlink and than putting in the mailto: address in I can do it one at a time.
Anyone know how I can do all of them at once without going in and doing each one individually? This is taking forever!


More replies
Relevance 61.91%


This is strange. Every time an email address is entered into a cell, the font is big. The column had been formatted as size 12, black font. But the data appears in font size 18, blue font, underlined.

I have a Mac, Excel 2007.

Any idea what to do?

Answer:Solved: Mac - Excel 2007, email address font

9 more replies
Relevance 61.91%

I need to creat a hierarchical structure in Excel that will allow me to hide a number of rows with the click of a single icon and reveal them the same way. This will allow me to create a maintenace structure and then find the various items without having to look through the whole list.For instance one might have "Drivetrain" with "Engine" and "Gearbox" as subsidiaries and then under "Engine" one would go into "Pistons" and so on, while under "Gearbox" one would go into "Gears" etc.As you can appreciate, by the time you have listed all the parts on a truck, you are dealing with a long list.

Answer:I need to creat a hierarchical structure in Excel

It would help if your provided some more detail as to what you are looking for.Are you looking to create "dependent drop down lists" where the contents of each subsequent list is dependent on what was chosen in a previous drop down? As each drop down choice is made, the next drop down is populated only with the items related to the previous drop down choice. When the final drop down list item is chosen, all of the information about that item can be extracted with a function such as VLOOKUP or INDEX.If you are looking for something like that, see here: you are looking for something totally different, please provide some more detail.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 61.91%

I need to create a small database in Excell that will have info about company employees and their pictures. How do I put seperate pictures into cells?

Answer:Creat a database in Excel with pictures

What version of Excel are you using. I am using Excel 2013 which is part of Office 2013 Pro. If you are using Excel 2013 you can insert pictures by selecting the Insert tab on the menu Ribbon & selecting Pictures & follow the directions from there.
Other versions of Excel have a similar function for inserting pictures. Experiment with a blank worksheet first until you get the system to work for you.

5 more replies
Relevance 61.09%

I have managed to put together three up and running web sites using nof 7. Could anyone please point me in the right direction on how to go about creating an email address e.g. [email protected]. at the moment I am using [email protected] e.g.


Many thanks. The hosting company uses as the control panel. Do you think all the necessary info will be found in the helm site?

4 more replies
Relevance 59.04%

I am using the MSN Stock Quote addin with MS Excel 2003. Prior knowledge of this should not be necessary, but I just thought I'd provide full context to my issue. I wrote a macro that essentially records daily stock prices. Because I don't want to store old quotes into perpetuity, i need to ensure that the update quotes button has been hit. I use sendkey() to accomplish this, and then the macro copies the quotes and pastes them elsewhere. My main goal is to have the task scheduler open this file daily so i dont ever have to think about this again, and i'm so close. Essentially my problem is that it takes a few seconds after the update button is hit for the add-in to fetch the new prices from the internet, and this process appears to be delayed until the macro is finished. This is a problem because the macro ends up recording un-updated quotes. I have tried the Application.Wait procedure, and I've tried time consuming loops, do while loops, etc. All of these approaches result in the same thing: Can someone please help me with this? I'm too lazy to hand update this spreadsheet every trading day for the rest of my life (or until i quit). Thank you in advance!

Answer:Excel Macro - Allow cells to update query before macro completes

Can't you just put the update macro code in a module of it's own and call it from the main macro?


1 more replies
Relevance 55.35%

Hi, I'm new to this forum (actually forums in general) I was wondering if anyone could help me with a macro code. I work with 4 Excel sheets for my shippments, 2 sets for one plant and 2 for the other but all within the same file.

What I am trying to do is set up a macro that will automatically search for changes within sheet 1 (also for sheet 3, the other plant) When I change the rows color from blank to green/red, I need the macro to automatically cut that whole row and paste it into sheet 2 on the next blank row.

This doesn't seem like it would be that hard to do, but I know know the whole macro language.

If you can answer this please send me an email to soulblazor(@)

Thank you for your help.

More replies
Relevance 54.94%

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 54.94%

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 54.94%

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 54.94%


I was wondering if anyone could help me. I need to extract data from multiple excel files into a new excel file and sum the values. The data comes from excel files that are made from a template so the data is always in the same place or same cells. For example, i have data saved daily in excel files with the following naming convention 080204, 080304, 080404,..... and so on. What i would like to do is have a macro that will create a week ending sheet by importing and summing the data from that week.

Thanks for reading!

Answer:excel macro for copying and pasting data from multiple excel files

thanks for all those who read!!!! let me know if anyone needs the code!

1 more replies
Relevance 54.94%


I need help to create an Excel macro that would

1. ask users to select x number of rows to be copied from one worksheet of one Excel file
2. once users have selected the rows to be copied, then the rows are copied from the one original Excel file into X number of target Excel files

the target Excel files are all based on the same template
there is one worksheet in each of the target Excel files

in the target files, the rows should be copied from the first available empty row, going down

Looking forward to your help!

Thanks a lot.

Answer:Macro needed to copy x number of rows from one Excel file into a batch of Excel files

Hi, welcome to the board.
Not much info there to get the correct picture.
Sample? Of source and template please
And not to forget, what version of Excel are you and the users using?

1 more replies
Relevance 54.53%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
End Sub
Sub GetData(fl)
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

Answer:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Relevance 54.53%

I want to merge two excel files into a 3rd one.

The data are in the files Book1, Book2 and the result in Book3.

I know that i can use VLookup to do the above. But what i have pasted is just an example. The real excel files contains about 9 columns with at many repeating row!!!

Any help will be much appreciated.

Answer:Excel - macro to merge 2 excel files using a common column

Hi welcome to the board. How are you going to treat the duble items, If you want to merge 2 files adn duplication occurs here must be one cell whihc is common to let's say Book1 and Book2.

Do you have a common value? Index? Whatever you call it?

3 more replies
Relevance 54.12%

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.FileSearchCan 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 VariantDim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As RangeDim ServRange As Range, SrcOpen As Boolean, SourceName As StringDim FilSrch As Object, MyFilArray() As String'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"'Exit Sub'Sheets("LookUp").[a12] = NowWith Application .ScreenUpdating = False .StatusBar = "Counting source files ..."End WithSet FilSrch = Application.FileSearchWith FilSrch .NewSearch .LookIn = ActiveWorkbook.Path .FileType = msoFileTypeExcelWorkbooks If .Execute > 0 Then ReDim MyFilArray(.FoundFiles.Count) For I = 1 To .FoundFiles.Count If .FoundFiles(I) <> ActiveWorkbook.Path & "\" & ActiveWorkbook.Name Then ... Read more

Answer:Excel 2003 Macro doesn't run under Excel 2007

As far as I know, Application.FileSearch is not available in 2007. Searching for filesearch replacement turns up lots of hits with various workarounds, such as this: Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 54.12%

With due respect and credit to DerbyDad03 whose earlier post gave me the code below; is there any way to have the new worksheets created from a variable length field e.g. a persons name in a list or a field of fixed length other than a date as the script below uses?Sub CreateMonthlySheets()Dim lastRow, mMonth, tstDate1, tstDate2, shtName, nxtRowOn Error Resume Next'Turn off ScreenUpdatingApplication.ScreenUpdating = False'Make a copy of the data sheet and sort by date Sheets("Sheet1").Copy After:=Sheets(1) Sheets(2).Name = "SortTemp" With Sheets("SortTemp") lastRow = .Cells(Rows.Count, 1).End(xlUp).Row Rows("2:" & lastRow).Sort Key1:=Range("A2"), Order1:=xlAscending 'Using SortTemp Sheet, create monthly sheets by'testing Month and Year values in Column A'Loop through dates For Each mMonth In .Range("A2:A" & lastRow) tstDate1 = Month(mMonth) & Year(mMonth) tstDate2 = Month(mMonth.Offset(-1, 0)) & Year(mMonth.Offset(-1, 0)) 'If Month and Year are different than cell above, create new sheet If tstDate1 <> tstDate2 Then ActiveWorkbook.Sheets.Add After:=Worksheets(Worksheets.Count) 'Name the sheet based on the Month and Year ActiveSheet.Name = MonthName(Month(mMonth)) & " " & Year(mMonth)'Copy Column Widths and Header Row .Rows(1).Copy ActiveSheet.Rows(1).PasteSpecial Paste:=8 'ColumnWidth ActiveSheet.Rows(1).PasteSpecial 'Data... Read more

Answer:Excel Macro to create new worksheet in Excel 2010

I created a quick macro to help you out. This macro creates a new sheet and names it using the contents of cell "A1".Sub CreateNewSheet()
Dim NewSheet
Dim SheetName As String

SheetName = Worksheets("Sheet1").Cells(1, "A").Value
Set NewSheet = Sheets.Add(After:=Sheets(Worksheets.Count), Count:=1, Type:=xlWorksheet)
NewSheet.Name = SheetName

End Sub
Law if Logical Argument: Anything is possible if you don't know what you're talking about.

4 more replies
Relevance 54.12%

I run a weekly excel 2007 macro that converts a spreadsheet to a Word document, but it stops after row 29 of data. Any spreadsheet with 29 rows or less works fine. If I have 34 rows of data, the macro hangs. See below for script. Any help would be appreciated.

Public Sub AddControls(WrdApp As Word.Application, CurRow As Integer)
Dim OptChecked As Boolean
Dim GrpName As String
GrpName = "Grp" & CurRow
'Calculate the colors based on the cell information.
CurRange = "F" & CurRow & ".." & "F" & CurRow

If InStr(1, UCase(ActiveCell.Text), "X SRM") > 0 Then 'SRM
OptChecked = True
OptChecked = False
End If

SetCellBG WrdApp, True
WrdApp.Selection.TypeText Text:="Governance:" & vbCrLf

Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
With RadioObj.OLEFormat.Object
.GroupName = GrpName
.Caption = "SRM"
.Font.Name = "Arial"
.Font.Size = 8
.Value = OptChecked
End With

If InStr(1, UCase(ActiveCell.Text), "X PPO") > 0 Then ' PPO
OptChecked = True
OptChecked = False
End If

WrdApp.Selection.Collapse Direction:=wdCollapseEnd

Set RadioObj = WrdApp.Selection.InlineShapes.AddOLEControl("Forms.OptionButton.1")
With RadioObj.OLEFormat.Object
.GroupName = GrpName
.Caption = "PPO"
.Font.Name = "Arial"
.Font.Size = 8
.Value = O... Read more

Answer:Excel Macro - converting excel to word doc - stops after row 29

13 more replies
Relevance 54.12%

Does anyone know how to run Excel 2003 print macro on Excel 2007 or higher? When I tried running my 2003 macro, the VBA editor pops up w dialogue box, " Run-time error '1004': Method 'ActivePrinter' of object'_Application' failed ".

This is my code: Application.ActivePrinter = "Epson LQ-300 ESC/P 2 on USB003"

Can anyone help?


Answer:How to run Excel 2003 print macro on Excel 2007?

Welcome to TSG hope we can help you and you can help others.

I'm not an Excel macro guy but you code looks reasonable. What happens if you run this. I suspect printer name is a little off.

MsgBox "The name of the active printer is " & Application.ActivePrinter

1 more replies
Relevance 54.12%

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 54.12%

Hi, I have created an excel macro that runs sensitivities in my model. The excel button runs 5 different cases.

The macro runs fine and does as I want it to.

Once the macro has run, and I go to edit a cell and hit "F2" excel crashes. This only seems to happen in certain cells and not all of the time.

Does anyone have experience with similar questions?


Answer:Excel Macro runs fine..then excel crashes

11 more replies
Relevance 53.71%

Hello, I'm just joined and am trying to create a macro that will automatically email an entire workbook to a list of individuals. I also want the macro to copy and paste a range of cells within a specific sheet in the workbook and paste it into the body of the email. I am able to email the workbook but can't figure out the second part. Any help would be appreciated.

I am using Excell 2007 and LotusNotes 8.5.1

Answer:Macro to email centain range in body of email as well as the whole workbook

Hi, welcome to the forum.
There are several posts where I added some simple tips and tricks.
Do you have the macro you use now to mail the whole workbook?
If I see how you have done this then maybe it's a cinch to add the extra info
You may also post a workbook with fictious data if you wish

1 more replies
Relevance 53.3%

Excel '07 won't open an "excel 4.0" macro (i.e. *.xlm file). I am one of a few users at work using excel 2007, I believe this file was made with excel 2000 or similar. When I had excel 2000 it opened fine, it's a common file on the network that everyone should be able to access, and everyone with excel 2000 can easily. So I know it's not the file. When I try and open it with excel 2007 I get that stupid error about the file being different to the extension.

I've tried registry edits and workarounds after scowering the net but nothing seems to fix it. All it does is display the error, then opens excel in the background without even a new worksheet. Excel isn't hanging, it just does nothing. Any ideas?

Answer:excel 2007 won't open excel 4.0 macro

XLM was long ago replaced by VBA (with Excel 5 in 1993) and MS no longer really supports it (although I think they claim that they do, kinda, sorta.) So the only thing you can do, I think, is to make a copy of the xlm file and convert the xlm code in the copied file to VBA. Fortunately, I found a link that tells you how to do that:
(Look at the link at the bottom, too. But you will need to download that to an older PC, possibly.)
Now, assuming all goes well, this will give you two versions of the same file, but if everyone else has Excel 2000 (or later) then they will all be able to use the new VBA-based file, so you won't end up with two files that would lead to confusion.
Still, it looks to be a lot of work, so good luck!

On a final note, if you need this file done in VBA and you can't figure out how to redo it, make a post describing your needs - there are some amazing VBA coders on here.

1 more replies
Relevance 53.3%

A macro I wrote in VBA for Excel 2004 won't run in Excel 2011 (alas...). Upon opening the spreadsheet an "on open" routine runs, and bombs out on the following command:
Set cmdbar = Application.CommandBars.Add _
(Name:="Sort", _
Position:=msoBarTop, _
MenuBar:=False, _
temporary:=True) 'msobartop docks the menu at the top

Does anyone know if the VBA structure ("CommandBars.Add") has been removed or altered?

Is there another way to accomplish the same thing in 2011? I want to create a custom command bar (I populate it later in the module).

More replies
Relevance 53.3%

I have an equation that I need help with putting into an excel Macro. The equation is as follows:

I need this put into a macro as either an if then else statement or a case statement. If anyone could help me out i would appreciate it

Answer:Excel Equation converted to an excel macro

Not sure if this will work for you or not, untested...
dim e as range, f as range, c as range
set e = range("E2"): set f = range("F2"): set c = activecell
if e = "" and worksheetfunction.isna(f) then
c.value = "XXXXXX"
elseif e = "" and isnumeric(f.value) then
c.value = "AS SIGN LAN ID"
elseif e = "XXXXXX" and isnumeric(f.value) then
c.value = "ASSIGN LAN ID"
elseif e = "XXXXXX" and worksheetfunction.isna(f) then
c.value = e.value
elseif (e <> "" or e <> "0000 00" or e <> "111111" or e <> "999999" or e <> "IOIOIO" or e <> "XXXXXX") and (isnumeric(f) or worksheetfunction.isna(f)) then
c.value = e.value
c.value = "No Criteria Met"
end if

3 more replies
Relevance 53.3%

Does anyone know the best way to setup a Macro in Excel 2007 that will work in Excel 2003 as well?

I have an Excel 2007 workbook that I am using a macro to change the "Fill Color" and "Font Color" of cells. However, I will get everything working in Excel 2007, but when I open the workook in Excel 2003 I get many debug errors.

If I change the code in Excel 2003, and then re-open in Excel 2007 I get debug errors.

There must be a way to setup teh workbook to work on both Excel 2007 & 2003.

More replies
Relevance 52.07%

Dear Guyz

I have a macro helped and developed by a respected admin of this group

it has following statement

If Cells(lRow, "N").Value >= 5 And Len(Trim(Cells(lRow, "P").Value)) > 0 Then ' check if the months passed are >= 5 (same as the red conditional formatting)
If Len(Trim(Cells(lRow, "O").Value)) = 0 Or (IsDate(Cells(lRow, "O").Value) = True And Month(Cells(lRow, "O").Value) <> Month(Date)) Then
toList = Cells(lRow, "P") 'gets the recipient's email address Column O

I want to add another line from another macro

If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

which makes sure that only @ emails are there and also ensures to which person it has to email and which it has avoid.

Can anybody help me to sort out this especially @Keebellah

Answer:Yes for Email No for no Email Condition in an if Statement of macro

7 more replies
Relevance 51.66%

I have been unable to insert an address from my Yahoo email address book for some time now and I have decided to ask for help.

All I am doing is opening Yahoo mail and trying to compose a new email to send to someone who is already in my contacts. When I click "to:" or "insert address" my address book shows up. But when I place a check mark and try to "insert checked contacts" I go to this address on a blank page:

I see that this has been asked before but no one had replied and I can't find the answer doing a search.

Can anyone help?

I have Vista Home Premium 32 using Firefox. The version is the latest version of Firefox but this has happened in many previous versions of Firefox. (I was lazy [or in a hurry] and just typed in the address of the entity to which I was communicating as a work around.)

Wayne Margot

Tech Support Guy System Info Utility version
OS Version: Microsoft® Windows Vista™ Home Premium, Service Pack 2, 32 bit
Processor: Intel(R) Core(TM)2 CPU 6700 @ 2.66GHz, x64 Family 6 Model 15 Stepping 6
Processor Count: 2
RAM: 3070 Mb
Graphics Card: NVIDIA GeForce 9600 GT, 512 Mb
Hard Drives: C: Total - 305250 MB, Free - 214622 MB; H: Total - 238472 MB, Free - 192816 MB;
Motherboard: , C19/MCP51
Antivirus: Microsoft Security Essentials, Updated and Enabled

Answer:Solved: Yahoo email unable to insert address from address book

Concerning my post above: I turned on my older XP computer and I had no problem with inserting an address from the Yahoo! address book.

I compared all my settings in both computers and noticed that I had different settings relating to how pop-ups are handled. XP reminded me that the address book takes the form of a pop-up. On my Vista I had pop-ups opening up (?) in a webpage. That is the page which came up blank. After I have corrected the settings, I no longer have a problem.

1 more replies
Relevance 51.66%

I am using Outlook 2003 and run Windows XP.

When I create a new message I begin typing the name of the recipient and I would like it to match up with an address I have in my Outlook contact list. However, it does not read from there. It only seems to look at addresses that I have already sent to in the past. How can I get it to read from the address book? If I click on "TO" or "CC" it brings up another window with a list of addresses from my contact list. From there I can have it pull from the list. I would like to be able to do it withot the extra step.


Answer:Solved: Outlook 2003 dowes not automatically pull address from address book for email

That is how autocomplete works, from used addresses stored in the NK2 file.
This explanation and keyboard shortcut might help you.
Where do Outlook's auto-complete suggestions come from?

3 more replies
Relevance 51.66%

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 4:14:35 PM, on 10/30/2008
Platform: Windows XP SP3 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16735)
Boot mode: Normal

Running processes:
C:\Program Files\WIDCOMM\Bluetooth Software\bin\btwdins.exe
C:\Program Files\Analog Devices\Core\smax4pnp.exe
C:\Program Files\PDF Complete\pdfsty.exe
C:\Program Files\Hewlett-Packard\HP ProtectTools Security Manager\PTHOSTTR.EXE
C:\Program Files\Synaptics\SynTP\SynTPEnh.exe
C:\Program Files\Hewlett-Packard\HP Wireless Assistant\HPWAMain.exe
C:\Program Files\Java\jre1.6.0_07\bin\jusched.exe
C:\Program Files\Hewlett-Packard\HP Quick Launch Buttons\QlbCtrl.exe
C:\Program Files\Hp\HP Software Update\HPWuSchd2.exe
C:\Program Files\Lightspeed Systems\SecurityAgent\satray.exe
C:\Program Files\Common Files\LightScribe\LightScribeControlPanel.exe
C:\program files\WIDCOMM\Bluetooth Software\BTTray.exe
C:\Program Files\Hewlett-Packard\IAM\bin\asg... Read more

Answer:Help. Virus sending spam through my email to every address in address book. Log help

Hello and welcome to TSF

Please follow the instruction outlined in our sticky entitled

If you have trouble with one of the steps, simply move on to the next one, and make note of it in your reply.

If there is no response to this post within 72hrs, this thread will be closed.

2 more replies
Relevance 50.84%

I recently moved and got an email address from  google.  My Microsoft 2010 Outlook email still has the old IP address and service provider (Fairpoint).  I need to change my Microsoft Outlook setup to use the new Neatgrear 45 Router
thru Time Warner Cable.  I cannot find instructions no how to make the change.  Any help

More replies
Relevance 50.02%

spam is being sent from my email address to my email address with my email address as part of the subject line.

Answer:spam on my email address to my email address

i am recieving email from my email address to my email address with my email address and some dating number in my subject line.

3 more replies
Relevance 50.02%

hi guys,

i need your help, i got my yahoo account & i am using firefox18. I know my strong password every thing. buy my problem is here, some one sending email by using my same email to me on same email for example [email protected] is my email address.

so some one using this email address [email protected] from his pc & sending to me at this email [email protected] that i can ckeck in my SPAM folder.

so usually i go to my SPAM folder & get the persons email & i put in the blocker list, sothat he should not send me an email next time.

but this time i am not success to block this email [email protected] , because this is my email address, how i can block.

So i like to know with you guy having lot of experience,
1)-How to stop this person by using my email address. and may be he is using my email address to send other peoples junk email by my name ?
2)-Which SPAM blocker program i have to install on my PC, so that it can BLOCK SPAM & not get that emails in my email address ?

My problem is here, i can't close this email address account, because many contacks having this email address from last many years.

Hopefully waiting for your help.


Answer:by using my email address some one send me an email to same address

Would it help if you changed your password?

9 more replies
Relevance 50.02%


I currently maintain 15 websites, for various different DIY products. Each website has its own email address. We have some one who deals with all email enquiries. We are noticing large amounts of spam. It has been suggested that we use a single email address for all 15 websites.

Other than its going to be a nightmare editing all of the websites to 1 email address, what other pros and cons are there for this idea.


Answer:Multiple Email Address' or a single address

not sure how this will reduce the spam necessarily.

a good spam filter may help.
o you know which email is giving you the most spam

I have about 5 websites and emails and get spam in most of them, infact one email I use most of the time for webuse and that gets most of the spam

2 more replies
Relevance 50.02%

I have a bunch of email messages that went to a specific folder in my address book. Now I need to get the email addresses for these messages. I can't do it manually. There are a lot of them.

How can I get a list or database that would have the email addresses?


Answer:email address out of address book folder

What email software are you using? Outlook, Outlook Express, Thunderbird? What sort of email account is it? Exchange, POP3, IMAP? We're going to need to know this to be able to help you.


2 more replies
Relevance 50.02%

If I send an email from any device from my hotmail account the recipient will see that it has come from my gmail account.
I have removed the gmail alias from the Hotmail settings but it is still happening and I am at a loss.
Any help would be great

Answer:Email address is showing different address than the real one

Okay, I figured it out. This is actually to do with settings on my iPad. The iCloud synching for mail needed to be off otherwise it defaults to the gmail account in a stealth attack from the big G.

1 more replies
Relevance 50.02%

Trying to reinstall everything after pc crash. Trying to set up my Outlook email accounts and have come to the POP3 and SMTP question.Tried but no luck. Can anyone with btinternet address tell me the correct entries please?I'll make a note of the settings next time.

Answer:BT Internet email address - POP3 address

could be

4 more replies
Relevance 50.02%

I'm using windows live mail with 5 or 6 email addresses. the anomaly first occurred in April, and now has happened twice yesterday and once this morning. this time they are selecting about 10 addresses at a time.

Nothing appears in my sent mail. one of the emails came to me since i'm in my own address book. the following is the email.

X-Apparently-To: [email protected] via; Fri, 02 Jul 2010 06:44:53 -0700
Received-SPF: pass ( domain of [email protected] designates as permitted sender)
X-YMailISG: KnbfCMgcZAoXDidODNJxOCs1Dp5cTyBQNqil.F7vflMa60tR
X-Originating-IP: []
Authentication-Results:; domainkeys=neutral (no sig);; dkim=neutral (no sig)
Received: from (EHLO (
by with SMTP; Fri, 02 ... Read more

Answer:someone sending email to my address book from my address

6 more replies
Relevance 50.02%

I have had to reinstall pc due to it going at a crawl!!

After installing Outlook 2002, I can not get Outlook to auto fill the email address field when I start to type an email address in it.

The address book is there and in tacked after copying the outlook.pst file back to its original location after install.

How do I get Outlook to autofill?

Also when I click the 'TO' button in the new email window, it says that there is no address book!
but when I click the address book icon in the main Outlook window there are email address there?!

Any ideas how I can get this to work correctly again.

Answer:reinstalled pc, now create email in Outlook 2002 does not auto fill email address like before

When you did the re-install, did you erase/format the hard drive before the re-install? If you did and did not save the Outlook auto fill file, then the all the auto fills you had are gone. Did you import the pst file into outlook?

1 more replies
Relevance 50.02%

Dear all

May I know is there any software (work indepentent, no additional email client e.g. Outlook, Eudora etc. needed) can download email (can filter by sender email address) from a specific POP3 server and save those attachement to a specific folder automatically?



More replies
Relevance 49.61%

When trying to email to a specific internal email account, my email leaves my system and
does not arrive at the destination account. The destination account also happens to be the "administrator" and the email does get to the administrator email account. Any ideas?

Answer:Outlook 2000 Email problem to specific internal email address

Will: No offense, but your post sounds like you're saying you're sending it from one account to another, but it's not being received at the other account, which is the administrator---but the administrator receives it?

Could you please re-state your question?
Brainbench MVP for Microsoft Word

2 more replies
Relevance 49.61%

I've just found a pst file with all my old email. I'd like to put them back on the server (hotmail) but before doing that I've seen that some of them were not recived (or sent) to my actual address ( but to an old one ( So I was thinking to export them from outlook 2013 to CSV, modify that address into the new one and then import them back on outlook 2013. The problem is that when I export them to CSV, in that file they don't have the date (received or sent) and so when I get them back on outlook 2013 they miss that info.
Can anyone help me doing this? I've been told that VBA macro should be useful for this, but having a look in it I have no idea of what I sould do.
Ah, instead of outlook 2013 I can also use thunderbird (45.3.0) if it's easier with it, but then I'd have to convert that pst file.

More replies
Relevance 49.61%

hi there,,when i go to enter my email address in firefox the pop up address is spelled wrong,,,how can i change it,without losing all my auto complete forms.
i am using windows xp home edition..

Answer:Solved: wrong email spelling in auto complete email address

Delete Firefox auto-complete entries

There is also an add on for firefox that allows you to manage autocomplete

Available features include:

* matching against bookmark addresses
* matching against page titles and bookmark names
* matching anywhere in the address, not just the beginning
* changing the sorting criterion to alphabetical by address or title, most frequently visited, most recently visited, or top-level pages first
* completing the best match inline
* temporarily or permanently disabling the suggestion popup
* excluding local pages and pages containing search results
* swapping the address and title columns on the suggestion popup
* highlighting the column where a match was found
* fine-tuning the popup appearance by hiding page titles, changing the number of visible suggestions, and setting the truncation method for long addresses and page titlesClick to expand...

Autocomplete Manager 2.3

3 more replies
Relevance 49.61%

I've managed to setup email forwarding for my wife's new marketing business so I get emails coming to the POP3 email account [email protected] from the email address [email protected] and also [email protected]

However, when I send an email it appears (in someone else's inbox) to come from
Joanna Rigby <[email protected]> when I would like to appear to come from
Joanna Rigby <[email protected]>

I want them to see her domain name NOT the pophost.123-reg info.

Any suggestions on how I do this please? I'm running Microsoft Outlook Office 2007.

kind regards,

More replies
Relevance 49.61%

I just linked one of my email accounts to my personal gmail account so I could consolidate all my email but I found that it is much too cluttered. Now I have a mess in my personal gmail account.

How can I delete all the email from the linked account (which is now removed, but messages are still downloading) from my personal gmail inbox?


Answer:how to delete all email from a specific linked email address in gmail

Go to : Settings > Filters

The trick is to put a TO or FROM in the search field and hit TEST SEARCH, instead of applying the filter. Then delete what is in the search results. Now I don't know of a way to do this by account, but as long as you know the recipient or sender address (which would be your old email), then it should work fine. In your case, just put the sender address as your old email account and test the search, it should pull up all the email for you to delete


3 more replies
Relevance 49.61%


Is there some way of moving all messages from my hotmail account to another email address? So when I emails are sent to my hotmail address they are then sent to my other email address, (then deleted from hotmail).
Is there a program that can sit on the desktop that is always checking hotmail, and when a email is recieved it is then sent to another email address? (this address is not a hotmail address).

Any possibilities??

Answer:Make all email that is recieved from my hotmail account go to another email address.

if you have outlook express linked to your hotmail account you can run a rule on the mail - not sure if it works on webmail cia outlook/outlook express
but the rume to forward certainly works

3 more replies
Relevance 49.61%

My Great-Uncle has Windows 98se. He uses the newest Netscape and recently clean out his inbox using the Netscape email program. For one reason or another he had un-installed the email client and now he doesn't have any access to his emails or address book. I know nothing about Netscape because I haven't used it in like, years.

Is there anyway to obtain the emails or the address book from the Netscape email application after it is un-installed?


Answer:Netscape Email program uninstalled... need old email and address book.

7 more replies
Relevance 49.61%

I'm running Windows 10 mobile plus latest updates on a Lumia 950.
My Hotmail email account wasn't syncing correctly so I removed it from the phone, restarted the phone then added it again.
It appears to have added the Microsoft Account OK but I am not getting email, contacts or calendar - can anyone help? Is there anything else I need to do?

More replies
Relevance 49.61%

When I got BellSouth DSL years ago I had Outlook email account set up with BellSouth as outgoing and old domain as incoming so I could keep my email address from another domain. It worked fine until a year or so ago I had to add another account just for BellSouth and that worked fine.

Within last few weeks emails from my email address (old domain) would not send. I've been through it with ATT tech several times to no avail.

It seems that ATT has trapped me out and does not want me to be able to keep my old email.

There's bound to be a way to set up my email accounts so my outgoing email from my other ISP provider will send through BellSouth without changing my very old and reliable email address.

Also, I recently have acquired my own domain name and I fear emails from that email address will suffer the same fate.

I hope this is not too long, but PLEASE HELP if you can.

Answer:Can't send email using different domain in email address BellSouth trapped me out...

If your BellSouth e-mail service is provided by Yahoo, then you probably need to go through a registration and authentication process for each e-mail address you want to send through a non BellSouth/Yahoo mail server. At least that is what I had to go through as an SBC/ATT DSL customer. They claim that they do the blocking to prevent from originating from users within their network.

EDIT: Forgetting my manners. Hi and welcome to TSG.

1 more replies
Relevance 49.61%

Hi guys,
'Boopme' had me run MiniToolBox and he wrote that he found "errors and other issues" and he bumped me to this thread.
Norton now seems to be removed and the restart was successful w/ out a restore.
This is what I wrote in under the from "Am I infected?" thread;

Been having problems with my laptop running Vista Home premium svc pack2.
One day, a month ago, Norton was not updating properly. Upon the next boot-up windows would not start and I was forced to restart in safe mode with a system restore. This was successful but Norton Security Suite was still not updating properly.
Since then, on a few occasions, I have attempted to uninstall Norton without success thru the program uninstaler. Norton is unresponsive. I even got the Norton rep. to do a remote deletion of all registry files of Norton. But they all returned after the reboot of my PC because windows would not open and I had to start-up thru system restore.
Since then my yahoo email been hacked and spam sent to the contacts of my address book.
I know I got something but I don't know what.. Can anyone take a stab at what I might need to do?
DDS (Ver_2012-11-20.01) - NTFS_x86
Internet Explorer: 9.0.8112.16421
Run by Owner at 20:22:53 on 2013-03-19
Microsoft® Windows Vista™ Home Premium   6.0.6002.2.1252.1.1033.18.3062.1338 [GMT -5:00]
AV: Avira Desktop *Enabled/Updated* {F67B4DE5-C0B4-6C3F-0EFF-6C83BD5D0C2C}
SP: Avira Desktop *En... Read more

Answer:Email was hacked-contacts in my address book were sent spam email

Greetings Brian and to BleepingComputer's Virus/Trojan/Spyware/Malware Removal forum.My name is Oh My! and I am here to help you! Now that we are "friends" please call me Gary.===================================================Ground Rules:First, I would like to inform you that most of us here at Bleeping Computer offer our expert assistance out of the goodness of our hearts. Please try to match our commitment to you with your patience toward us. If this was easy we would never have met. Please do not run any tools or take any steps other than those I will provide for you while we work on your computer together. I need to be certain about the state of your computer in order to provide appropriate and effective steps for you to take. Most often "well intentioned" (and usually panic driven!) independent efforts can make things much worse for both of us. If at any point you would prefer to take your own steps please let me know, I will not be offended. I would be happy to focus on the many others who are waiting in line for assistance.Please perform all steps in the order they are listed in each set of instructions. Some steps may be a bit complicated. If things are not clear, be sure to stop and let me know. We need to work on this together with confidence.Please copy and paste all logs into your post unless directed otherwise. Please do not re-run any programs I suggest. If you encounter problems simply stop and tell me about it.When you post your reply, do not use the butt... Read more

26 more replies
Relevance 49.61%

I'll bet you have not heard this one before. I was attempting to send an email to a potential client. Everything seemed to work well except that it was returned. The problem was that the address was changed somewhere. His name is spelled with a j but somewhere along the line, it was changed to a k and so there was no such person and therefore was returned to me.

#550 5.1.1 RESOLVER.ADR.RecipNotFound; not found ##rfc822;

What could have happened? This is a new one on me.

Answer:outlook 2007 changed email address so email was returned


Did you get a message similar with these?

This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

Windows Live mail:

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

5 more replies
Relevance 49.61%


Short story. Moved to another state, got new email address, went to change to new email address in usrcp.
Followed instructions, then everything went cattiwampus.

Using the KISS method, I ONLY want to change from orig email addr to new one. Everything else stays the same.



Answer:Changed email address, recd confirm email, followed it, no result?

Sounds like you may have been taken in by a phishing ploy.

Can you explain the acronym usrcp, and cattiwampus is what makes me think phishing ploy. Run your panda product and see what shows up.

Do you still have the email? If you do, post a screenshot.

1 more replies
Relevance 49.61%

Its getting pretty old, it seems every two years or so a company is bought out and you have to switch your ending email address to that provider,
and now the latest will be, add to that a couple more in the list above i forgot the endings of its quite the list for about 8yrs worth.

Gmail? Yahoo? anything else worth considering as a permanent email address?

Answer:Best free email to use?...Im sick of companies being bought = new email address

I'd say Gmail. Otherwise try I've had an account with them for about 4 years, and even if I'm inactive for a couple of months, I go back and it's still there.

18 more replies
Relevance 49.2%
Question: excel macro

i have a simple macro to update a file by copy and pasting
i would like the macro to execute every 7 hours can this be done

Answer:excel macro

Moved you to Buisness, where you may get more replies

1 more replies
Relevance 49.2%

Hello.... I am trying to prepare some reports for my boss and I am stuck on the macro I am writing. somehow I need to put the date in as a variable. you know hte same way that excel has the today() formula but I don't know what the code for that is. Can anyone tell me how to state that the variable TDay is equal to the current day so that tomorrow it will be automatically equal to tomorrows date?



Answer:Help With Excel Macro... Please....!!

Tday = date

does this work for you?

3 more replies
Relevance 49.2%
Question: Excel Macro Help

HiI have 2 problems with an excel macro that I inherited many years ago and it seems a little too complex for my limited knowledge of macros.The first problem is that the macro takes a spreadsheet that has been sorted by column A (in this instance that is Supplier Names)and splits the files at each new supplier name and saves. This gives me circa 60 new individual files. This works perfectly and is easy to use. However, this macro is used at least once per week and the output files all need to be saved. Since the new file names are basically just a reflection of column A data, I manually need to rename the previous weeks files before I can run this. I am looking for a way to differentiate the current weeks files from the previous weeks using the macro. The easist way I can think is to have the date added to the end of the supplier name each week but I can't find a way to add this into the macro. The second problem is that there is an additional file that is supposed to record all the file names to allow the files to be sent via email but the instructions are not clear on how to set this up, where to record the email addresses etc. Any insight in to either of these problems would be very much appreciated.Below is the macro detailsim efile As StringPublic continue As BooleanFunction GetColumn(mColumn) Select Case mColumn Case Is >= 53 GetColumn = "B" & Chr(mColumn + 12) Case Is >= 26 GetColumn = "A" & Chr(mColumn + 38) Case Else GetColumn ... Read more

Answer:Excel Macro Help

7 more replies
Relevance 49.2%
Question: Excel Macro Help

This is what I have so far...

what I need should be just after auto open and before running the "newinvoice' macro.

I need to do something like...

if current workbook filename is not equal to "invoice.xls" then goto end (do NOT run "newinvoice")

if current workbook = "invoice.xls" then run "newinvoice" else goto end (do NOT run "newinvoice")
if somebody could put the above into proper macro code please???

Sub Autpen()
' this macro will run every time the workbook is opened
Application.OnSheetActivate = "NewInvoice"
End Sub

Sub NewInvoice()
' Keyboard Shortcut: Ctrl+n
Dim x As Integer
Workbooks.Open Filename:="d:\number.xls"
x = Workbooks("number.xls").Worksheets("Sheet1").Cells(1, 1)
ThisWorkbook.Worksheets("Invoice").Range("n4:n4") = x
x = x + 1
Workbooks("number.xls").Worksheets("Sheet1").Cells(1, 1) = x
myFile = [n4] & ".xls"
ThisWorkbook.SaveAs myFile
End Sub

More replies
Relevance 49.2%
Question: Excel Macro

I've got a macro written in Excel but I need to have the macro pause while I select a cell with my mouse and the have the macro restart and do a simple copy. Anybody know how this is done?

Answer:Excel Macro

You'll probably require a message box and everything, grumpy. Can you copy your code into here? Or perhaps the second item listed at is what you need? I didn't download it to check it. The people at are very good at this kind of thing, but don't leave us!!

2 more replies
Relevance 49.2%

I'm trying to create a macro that will copy rows 1 & 2 and paste it in the row containing the last value in column B + 1. The goal is to allow a user to insert a repeatible header throughout a worksheet as needed. Admitedly I'm stumped how to find the last column with a value and move down 1 before the paste.

More replies