Computer Support Forum

Solved: Excel email macro auto-populate subject line

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

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;
Code:
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!

Relevance 100%
Preferred Solution: Solved: Excel email macro auto-populate subject line

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 http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

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

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

Regards,
Rollin

2 more replies
Relevance 93.96%

Hi

When you make a hyperlink there's a option of selecting email. Which then makes a box appear asking the me to insert the email address, subject line and body of text.

what I would like to do is auto-populate the subject line with words written in the document--or---auto populate the subject line with the contents of a fill-in form field.

Is this possible -- Oh i'm using Microsoft Word 2003.

Any assistance would be greatly appreciated.

Thanks in advance
 

Answer:Solved: Auto populate subject line in word 2003 - hyperlink

I figured it out!! I don't know how to remove the thread....
 

1 more replies
Relevance 89.03%

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

I write many emails to potential clients, and find myself writing the same subject line all day long!
I would like to have a button I can hit to create a new email containing my subject line.

I found a 'Macro' script online and it worked for a day, then after trying to get it to work, I deleted it and I can't find the same script to make it work again.

Is a Macro the only option I have, or is there another way to resolve this?
If Macro is the only option..
Do you have a Macro script to put in my outlook>Toolbar>marco folder, and drag to the tool bar?

Thoughts??

Thanks!!
 

Answer:Outlook 07, Create a macro to have auto-subject line in emails

Can't you just create your email message and then save as a template? You can then either click on the template to open it or you can use a simple macro to open it.

Rollin
 

2 more replies
Relevance 77.43%

Hi,
I send multiple emails all with the same information in the subject field. No, I'm not spamming. I'm sending order confirmations. I would like to set up one of the function keys on my keyboard to automatically populate the Subject fields.

Example:
Open a new email
Curser is in the Subject field
Automaticlly populate "THank-you for your Order"

I found a section for Macros in the Tool bar but am clueless. ANy help would be much apprecaited. THanks!

PS: running MiccroSoft Outlook 2000 and Windows XP
 

More replies
Relevance 104.96%

Hello,

When I click on a craigslist ad my yahoo email subject line no longer automatically fills in. Anyone know how to get this handy feature back? Thanks for any help.
 

Answer:yahoo email subject line won't auto fill

This depends on what Web Browser you're using. Most likely it's Internet Explorer, and you had it set to remember something specific or auto fill for that field. Often times, these can be screwed up by future actions. To prevent this, I would suggest downloading and using a program called "RoboForm". It will remember and learn information that you apply to a certain field in a web page. Each field has a specific name given by the web developer which you probably don't even know of. It remembers the form field name given like: yahoo_subj_field and then auto inserts text you entered into this field previously. IE does much of the same thing but can be screwed up easily throughout time.
 

3 more replies
Relevance 98.4%

submit php form / web form / or just customize link (I have requests active on the field)
Hi all, I would really appreciate some help or direction on this. I searched web form on this forum and went 25 pages deep seeing nothing like this.

currently I have this working for me
Code:

Sub ticketsystem()
'Dim PageNumber As Object

Set IE = CreateObject("InternetExplorer.Application")
IE.Visible = True

URL = "wwwDOTticketsystemDOTcom/admin/new_ticketDOTphp"
Request = "?name=john&subject=testing&message=testing123123123"

'get web page
IE.Navigate2 URL & Request
Do While IE.readyState <> 4
DoEvents
Loop


End Sub

takes me to website with the request info populated.

I am happy to do this 2 ways, either have the VBA script login and fill out the webform.. or just have the vba script populate the URL with data from the currently selected email/open email...
like in the code above the link should contain this to pre populate the form...

(I do not need it to submit the form, web session must stay open)

URL= wwwDOTticketsystemDOTcom/admin/new_ticketDOTphp
Request = "?name=nameofsender&subject=subjectofemail&message=body%of%email"

Basically: this is stopping me from having to copy & paste ( subject / from / body ) into a basic html/php form 40 times a day, that's 3 copy & pastes and 3 alt tabs (1 monitor) I still would need to categorize it and enter time spent on the web form, so no need to comp... Read more

More replies
Relevance 92.25%

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.
Treasurer
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.
Thanks!
 

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

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

Hi

I doubt this question has been posted before, however, I apologise if it has.

I have absolutely no VBA programming experience, however, have heard of a number of useful macros that can be created using them.

I am using Outlook 2002. I work in a team of 10 and we are required action requests from customers as and when they come in. This normally works on a first come first served basis, where we assign our names to the e-mail to show that we are dealing with it. The only problem is, I have the slowest of computers and cant seem to keep up with my colleagues!

I want to create a macro (to which I have received permission from manager already), that would carry out the below; ever time I click on the unread e-mail and then press the MACRO BUTTON (which I will drag onto my toolbar):

1) flag the e-mail to follow up (no deadline)
2) mark as read
3) and ADD the words "Shaz is dealing with -" on the subject line, BEFORE the rest of the subject line details.
4) automatically saves it, therefore, everyone will be able to see it straight away, and know that I am dealing with it

I am not very fast with computers and this will save me alot of time. As mentioned earlier, my manager has sympathised with my situation, therefore, has allowed me to do this.

I would be so grateful for your help.

Thank you


Shaz
 

More replies
Relevance 85.69%

I have just recently started to get lots of email in my in box from various sources with "Auto Response" as the beginning of the subject line of emails in my in box. I am so tired of sending them to my spam box that I am about to give up and get a new email address. Any help would be greatly appreciated. I have attached a .doc of a screen shot of my email spam folder . My email is Yahoo through an att account. I am using Firefox browser.

Answer:Auto Response in subject line of received emails

Quote:





Originally Posted by hdog


I have just recently started to get lots of email in my in box from various sources with "Auto Response" as the beginning of the subject line of emails in my in box. I am so tired of sending them to my spam box that I am about to give up and get a new email address. Any help would be greatly appreciated. I have attached a .doc of a screen shot of my email spam folder . My email is Yahoo through an att account. I am using Firefox browser.





Hi hdog,

First thing you can do before you give up is change your password.
Just give it a try, and lets see the result.

Thanks,

6 more replies
Relevance 85.28%

I am trying to create a macro (total novice at this) that will search for a word in a column and wherever it finds that word will insert a row below that. My worksheets range in size from 200- 3000 lines of data with 12 columns accross. The word can usually fall into the third column. Any help would be greatly appreciated. Thank you!
 

Answer:Solved: Macro to Insert a Line in Excel

9 more replies
Relevance 84.87%

Hi,

I am trying to create a button for inputting rows of data into a table.

I need the table to input a set amount of rows on the next available space in the table, and populate 1 of the columns with data given in a list.

I know I need a macro of some sort but am not sure how to go about creating it.

I have attached an example spreadsheet for reference.

Any help would be greatly appreciated!
 

More replies
Relevance 84.05%

Hi All. I know this has been looked at by others, But I can't find the solution.

I'm trying to get an automatic prompt on my users outlook that will give the users a choice of text to add to their Subject line.

All email we send will have various Protective markings, that will look like [PROTECTED] etc. there are about 8 different headings, with a default of [NON]. It would be great to have a prompt that shows all, with the default one first.

If any one can help that would be fantastic.

Regards
 

More replies
Relevance 84.05%

Okay, this maybe a tough one...

I have a list of registered attendees for a training session. I would like a button for each registrant that auto populates an Word invoice template and confirmation letter template - Conf. letter fields: first name, last name, company, address 1, address 2, city state/prov. and country. Invoice fields: first name, last name, company, address 1, address 2, city state/prov. and country. Session name, date range, cost...

I would also like to use the same list to populate a registrant booklet that is also an existing template in Word - first name, last name, company, email address and phone number. I read on another post that we could possibly do an auto save to a specified location when it populates the template as well. Then we have name tags, book labels and certificates that also need to be populated from the same list...

Anything to save some time and reduce errors resulting from human interference.

T Y I A
Bubbs
 

Answer:Excel macro to populate existing word documents and booklets

Why do you need a macro to do this? Have you looked into a "Mail Merge" ??

Rollin
 

1 more replies
Relevance 84.05%

Why do these [] show up on my subject line when I attach a file onto the message? Can I make them quit coming up? I get a lot of spam with these as the first two characters and I have messages like this blocked so I don't get so dang many.
 

Answer:[] in my email subject line

6 more replies
Relevance 83.64%

I'm trying to write a macro that will go down a column and fill in the blank cells by adding 1 to the cell value above. The macro will need to skip cells that already have a number. Column goes down ~11,000 rows

Before:

102
blank
blank
201
blank
blank
104

After:

102
103
104
201
202
203
104

Thanks.
 

Answer:Solved: Excel Macro to Auto Number

No macro required.

Select the first blank cell, then the whole column (CTRL+SpaceBar).

Press F5 > click "Special" > select "Blanks" > click "OK".

Type "=" (the "equals" sign), press the UpArrow key (formula bar says "=A1", for example), modify to "=A1+1", press CTRL+Enter to enter the formula into all selected cells simultaneously.

To "top & tail" copy and Paste Special > Values the entire column.

Full instructions here. HTH, welcome to the board.
 

2 more replies
Relevance 83.64%

Hi guys i am back yet again and prob not the last time as this site is the best.

I need a little help with my macro that i have attached and pasted below. In the attached excel file you will see multi records of the same thing. I need to only have 1 of each item listed and the duplicates deleted. Please Help

Sub DelDups_OneList()
Dim iListCount As Integer
Dim iCtr As Integer
' Turn off screen updating to speed up macro.
Application.ScreenUpdating = False
' Get count of records to search through.
iListCount = Sheets("Sheet1").Range("B1:B2000").Rows.Count
Sheets("Sheet1").Range("B1").Select
' Loop until end of records.
Do Until ActiveCell = ""
' Loop through records.
For iCtr = 1 To iListCount
' Don't compare against yourself.
' To specify a different column, change 1 to the column number.
If ActiveCell.Row <> Sheets("Sheet1").Cells(iCtr, 1).Row Then
' Do comparison of next record.
If ActiveCell.Value = Sheets("Sheet1").Cells(iCtr, 1).Value Then
' If match is true then delete row.
Sheets("Sheet1").Cells(iCtr, 1).Delete xlShiftUp
' Increment counter to account for deleted row.
iCtr = iCtr + 1
End If
End If
Next iCtr
' Go to next record.
ActiveCell.Offset(1, 0).Select
Loop
Application.ScreenUpdating = True
MsgBox "Done!"
End Sub

If you need further information please let me know.
Thanks ahead of time for the great help you all... Read more

Answer:Solved: Excel 03, macro for deleting duplicate line items

6 more replies
Relevance 83.23%

I am using the forumla =IF(ISBLANK(Sheet1!A33),"",Sheet1!A33) to insert info from sheet 1 to sheet 2. The problem I'm having is if I delete a row on sheet 1, I get an error message of "#REF!" on the second sheet. How can I automatically 'delete' the same row on sheet 2 so I don't get the error message?

Answer:Auto populate rows in Excel

Your subject line says "auto-populate rows" but your question relates to "automatically deleting rows".Confusing.If what you are trying to do is delete the same row on two sheets at the same time, then select both sheet tabs (Ctrl-Click the tabs) and then delete the row from any of the selected sheets.Remember to select only one sheet before you do anything else or you'll do it to every sheet that is selected.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 83.23%

using incredimail 2 with windows 10 home, recently some, not all, of my emails have the subject line starting SPAM then the subject line, at 1st I was just deleting them but they are now appearing on senders I subscribe to, I check the email properties to verify the sender, has anybody else had this problem or has anybody any advice please

Answer:***SPAM*** on email subject line

This is usually the fault of your security software on your machine. If you have email checking or anti phishing enabled in your security software then you probably need to adjust the parameters.

3 more replies
Relevance 83.23%

When sending an email using MS Outlook, is there any way to force a notification to come up when the subject line is inadvertently left blank?  This works with calendar appointments, where Outlook warns you before allowing you to set a meeting with a blank subject.

Answer:Outlook email subject line

Outlook doesn't have an option to alert you if the subject is missing. You can write a macro in VBA that will check for a blank subject. Look for code samples at Outlookcode.com.The following code checks for both a subject line and missing attachments:http://www.outlookcode.com/codedetail.aspx?id=553

4 more replies
Relevance 83.23%

I know how to add an email address to my website, and how to add a name with something likemailto: Feedback>[email protected]But how would you insert a subject line like "A Questions about your books" or "Feedback on your website"?

Answer:Subject Line in Email Link

This site may mess it up but lets try:mailto:[email protected]?subject=A Question about your booksbasically you add ?subject= on the end of the email address and then just type the subject you want.

8 more replies
Relevance 83.23%

Folks,I hope this is the right forum!...A friend has recently set up a website for their business. It has a contact page which includes their business email address, which has now started receiving a lot of spam...Now I know there are lots of possible solutions to help avoiding this, and appropriate action will be taken, but I've had an idea and I wonder if it can be implemeted easily into the site code...I've suggested that a message appears by the email address indicating that a particular phrase needs to apper in the subject line of any email sent, or the email will be deleted without being read. A message rule can be set up on this email address, in the email client to implement this.I know the code for a hyperlink to send an email is straitforward... my question is;Is it easy/possible to have a hyperlink that not only brings up the email message, (ie "mailto"), but also inserts a default text in the Subject field?Thanks in anticipation,Regards,Simsy

Answer:automatic email subject line?

of slightly the opposite of what you suggest; Text inserted by default into the subject field that ISN'T deleted, so the message rule would look for it... but it boils down to the same thing...Whichever way it applies, the query is, can such text be inserted into the subject field automatically by clicking on the hyperlink on the webpage?Thanks in anticipation,Regards,Simsy

2 more replies
Relevance 83.23%

Certain email messages from companies like Travelocity and Booking.com include wingdings in the email subject lines. These show up fine on one of my PCs but on the other one they show up as boxes or question marks. Both PCs are running Windows 7 and Outlook 2010. I'm sure it's a font issue of some kind, but I can't figure out which font is missing from the one pc. I've attached screenshots of the subject lines from both pcs. This isn't a crucial issue by any means, it's just annoying me that I can't figure it out.
 

Answer:Email Subject Line Wingdings

I assume that Outlook has settings for default font, whether to allow messages to use other fonts, and other formatting details. Have you compared/contrasted those settings on the two system?

If that doesn't help look at the message source. Not suggesting that without a lot of effort you can determine the font used for the Subject, but at least you can see which fonts are used somewhere in the heading or body.
 

1 more replies
Relevance 82.82%

Hi,

I have a worksheet containing various data including an expiry date, this is created by adding 364 to the start date and then then using an auto fill to fill in all other rows (over 50,000).

I would like to make a macro to do this alongside a number of actions but when making the macro I am specifying only a certain range to fill (A1:A50000). The problem I have is this list is consistently growing and so this range would then not include any new records added. Is there a way that I can make it so it auto fills from A1 to the last present row?

Thanks for your help

Dan
 

Answer:Solved: Auto Fill Data in Excel Macro

8 more replies
Relevance 82.41%

Afternoon all,

I am trying to figure out a rather wierd issue. We have a spreasheet where we keep track of quotes within the company. Currently we have 4 other spread sheets where the data is basically sorted multiple ways. The higher ups within the company are TOO DARN LAZY to just sort it themselves so they want 1 spreadsheet with multiple sheets in it with the same data, just sorted different ways. What I would like to do is be able to enter the data on sheet 1, and have it automatically added to sheet 2, 3, and 4 and then have it sorted the way that they want it. Is this possible and if so how?

Finally, is it possibly to restrist a spread sheet so only certain users can modify it? Basically this file would need to be left on a share and multiple people need to read it, but only about 2-3 need to actually make changes to it.

Thanks for your help in this.l

Joe
 

Answer:Excel: How do I get data to auto populate to other sheets.

Question 1:
Right click sheet tab | Move or Copy.. | Copy. Sort as desired.

Or are you looking for an automated version? If so, more details are needed, possibly a sample file.

Question 2:
Unlock those cell which a user could modify, Ctrl + 1 | Protection | uncheck Protect | Ok | Tools | Protection | Protect sheet.. If using 2002 (XP) and up, you have many more options to set that the user can or cannot do while the sheet is protected.

To allow only certain eyes to view the spreadsheet, use the workbook protection under SaveAs | Tools.
HTH
 

1 more replies
Relevance 82.41%

I have an excel file in which I am needing to creating multiple tabs. I want to have it where when I make any changes to the main tab that the data auto populates into the other tabs which I have filtered.
 

Answer:Auto Populate Data Between Excel Worksheets

16 more replies
Relevance 82%

I'm using Outlook A when I open an email and then close it the subject line disapears. Also, I have to turn off paragraph marks in my replys. Thanks

Answer:when I open an email the subject line disapears

For the paragraph marks. it depends on which version of Outlook you are using, but in 2007, in 'reply', click on the 'orb' (top left) and select 'editor options', then click on 'display' and remove the ticks from all unwanted formatting marks.Most other settings are within the same section so you may find the 'subject' option there. Alternatively, click on 'Tools' menu and select 'Options'."I've always been mad, I know I've been mad, like the most of us..." Pink Floyd

2 more replies
Relevance 82%

Hello,

Why do some emails come with letters that spell out no words in the subject line? Or there are nonsensical letters in between or after short phrases?

How can I figure out what they mean? I am on a shared computer and I don't open them but am not sure if they are meant for me or not.

Tkx,
Barb

Answer:Strange email codes in subject line

check the sender email address if its a valid one.. can be only spam emails..

1 more replies
Relevance 81.18%

WEIRD! Any email sent to my comcast.net account just vanishes if it contains the word "freeze". I sent myself an email from my smartphone to remind myself to freeze some leftover food when I got home. The message was sent (confirmed) from my smartphone, but never received on my smartphone (including spam and trash folders). When I got home expected to find it on my desktop (Dell WindowsXP), but it wasn't there, not in Inbox, Spam folder, or Trash folder---just GONE. I then sent myself a new message with the Subject line "freeze". It was sent (confirmed in Sent box, not present in Outbox since it had been sent), but it never arrived. Then sent myself successive messages starting with "ze" (successful receipt), "eeze" (successful receipt), and "reeze" (succesful receipt). Then when I sent "freeze" it was sent but never received. Also "freezing" and "free" are never received. I checked my Preferences for any filters, but I have none set up for any specific word or phrases or senders, so I have not blocked anything. I thought "free" sounds like spam, but I have no such filter and my Spam box is empty. So then I went to the Sent email with "reeze" in subject line, which had been received, and forwarded it to myself but changed the word "reeze" in the previously successful send to "freeze"---and as amazing as it may seem, the forwarded message went through bu... Read more

Answer:Specific word in Subject Line causes email to vaporize

6 more replies
Relevance 81.18%

When I get an email with a link in the subject line, I am unable to open it? I have a Vista OS and use Yahoo as my browser, which is based on IE.

Answer:Unable to open links of subject line of email?

Well a friend sent me an email with a Youtube link in the "Subject" line. (nothing in the body of the email) Another friend of mine could not open it either, but he was able to copy and paste it in the address bar at the top of the window and open it.I wasn't able to do either and requested that the sender resend it and this time put the link in the "body," and then there wasn't any problem.Thanks for your response.

7 more replies
Relevance 81.18%

I'm sorry if this has been discussed elsewhere but I have been looking all over for this answer. I feel like this is my last resort; I hope you can help.

I am in charge of developing forms on Excel. With ONE worksheet containing only ONE form, each workbook will have any number of worksheets (from 1 to over 200).
I have created a macro designed to insert the required header and footer information, for each form (AKA each worksheet), simultaneously for the entire workbook.
Now here is my challenge. Within the required footer information, each worksheet (form) must have a unique number (e.g., 7510001); the department is 751 and the first form number will be 0001.
The next form (worksheet) must have the number 7510002 in its footer information, and so on.
What I would prefer is the ability to insert the first number (possibly in a pop-up screen) and then have the macro populate the increment for the rest of the worksheets within the workbook.

Thank you in advance.

Bob
 

Answer:Solved: Macro for Auto Inserting a Number Incrementally (+1) in the footer of Excel 2

6 more replies
Relevance 80.36%

The subject line in my inbox of Hotmail has disappeared from my home computer. How do I get it back? I have already been hacked once because I opened an email that I thought would be safe and it wasn't. I am about ready to close my hotmail account because I am so very frustrated with not being able to reinstate this valuable information.

Answer:Restore missing email subject line in Hotmail inbox

Go here for expert help: http://windowslivehelp.com/

2 more replies
Relevance 79.95%

Hi!

I am trying to build a harvest data sheet for wildlife management implications and I cannot find out how to auto-populate data from the initial sheet to separate sheets based on the entry in one specific column.

Let me explain the data sheet in more detail; I have the initial sheet set with @16 columns containing harvest information for individual animals and broken up by individual properties. (Property "X", followed by date, age, weight, sex, etc. in columns for each specimen harvested).

Now what I would like to be able to do; I would like to enter the data under each property the first time and have three other sheets auto-populate, i.e. #1-total data set not divided by property, #2-all males, #3-all females, based on the entry in the "sex" column-'M' or 'F'.

I hope I have made the problem clear enough to understand. I know there must be a way to do this. Please help! Thanks!
 

Answer:Excel 2007 Question: How do I auto-populate data to inidividual sheets?

7 more replies
Relevance 79.54%

I have setup a auto response for a particular mailbox

In the auto response email I want the subject heading to appear in the body of the email. Does anyone know any strings or code I need to put in

Answer:OLK 07 subject heading in the body of the email from a auto response.

I have to admit that I am not 'well versed' in this subject.
However, I came across this guide, which appeared to me, to be quite versatile:






Quote:
In this article we?ll give you step by step instructions on how to create an auto-responder of your own. While this article will cover the steps to setup an auto-responder using Outlook 2010, you can set up an auto responder with Outlook 2007/2003 as well. The basic steps are the same for previous versions of Outlook, though navigating to the appropriate menus maybe a little different.


Auto-Responders for Outlook 2010 | Favorite Office Automation

1 more replies
Relevance 79.54%

Hello

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

Hello,

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

I found how to send an email from an Excel Macro (http://forums.techguy.org/business-applications/1056070-solved-excel-email-outlook-code.html)

Here is the code I'm using:
Code:

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
Etc:
Etc:
Comments:
I'm perfictly willing to look at how-to documentation if someone can point me in the right direction.

Thanks
firstshot
 

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
Code:

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

Hi:
I have a couple of questions regarding the below code and the attached spreadsheet. What do I have to do to make this macro execute at the time indicated in col m of the spreadsheet? The dates are going to be different for each row.
Also how do I get cell data [a4] [h4] [g4] [m4] [n4] to populate from the worksheet into the email?

Sub Mail_small_Text_Outlook()
'Working in Office 2000-2007
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
strbody = "Andean Funding Closing Document has not been recieved" & vbNewLine & vbNewLine & _
"Andean Tracking Number: [a4]" & vbNewLine & _
"Requested Amount: [h4]" & vbNewLine & _
"Case Number: [g4]" & vbNewLine & _
"Closure Document Due NLT Date: [m4]" & vbNewLine & _
"Staff Coordinator: [n4]" & vbNewLine & _
"Please contact OGL immediately to correct this situation" & vbNewLine & vbNewLine & vbNewLine & vbNewLine & vbNewLine & _
"Judy De Santis" & vbNewLine & _
"Office of Global Enforcement" & vbNewLine & _
"Latin America Caribbean Section" & vbNewLine & _
"Office: 202-307-4609" & vbNewLine & _
"Cell: 202-345-9257" & vbNewLine & _
"Fax: 202-30... Read more

Answer:Excel 2007 -How do I get cell data to populate email?

6 more replies
Relevance 76.26%

See Attachment. The idea would be to have the user provide the Probability and Impact (Low, Medium, or High) and the Overall Rating would autopopulate with color (red, yellow, green) and the value (1L, 2M, 3H, etc...) from the crosschart. I'm working with 2003 so using conditional formatting is not a viable option. In my actual spreadsheet the Overall Rating is contain in I4:I500
 

Answer:Need VBA to populate auto populate value and cell color

Try this

I just put some code in the worksheet's project
I count the number of entries in the colum A2:24 and the ones in B2:B4

the varaiables are hP, mP, lP for probability
and idem hI, mI and lI for Impact

See if it means something to you and if you get the right colors, it won''t calculaten until ccount =6 (that means that all the 6 fields contain data and the sum op the h,m , l variables is 9

The it's just a question of seeing if the conditions are met to color the range.
 

1 more replies
Relevance 76.26%

I have two data bases. One is Vendors, and one is where the job info is. I want to add a sub form of the vendors to job info, combo box the vendor name and auto populate all their insurance info, GL expriration, WC Exp, and Auto Exp. In Vendors, they are two seperate tables. I have linked to Job info the tables I need. But I cannot make the auto populate work.
I want to choose the company name and the threee fields autopopulate
Thanks for any help.
 

Answer:Solved: Auto Populate

7 more replies
Relevance 75.85%

Firstly Hi,
I'm Hodge and this is my first post on this forum, please (HELP)

I have been looking around the various forum's trying to figure this out myself but with little success. There are many variants of this problem throughout these forums with many solutions, but none of which i've been able to adapt or use.

I basically run a diving team with 27+ divers and have various spread sheets to manage the team, from equipment servicing to personnel run out dates. I have been trying to find/create a Macro that will automatically send me an email, with Cc's option, when cells in column M & O turn yellow or red. Then copy all the data within that row and email the address in column P as an attachment. I have looked at Ron de Bruin's code, and tried to adapt it without success. Once I have the correct code, I believe i will be able to adapt it to most, if not all of my spreadsheets.

Hopefully someone has used this type of code before for the same reasons, Sorry must mention that I'm working on MS Office For Mac 2011, but don't think the process is much different. I don't really know much about VBA, so any help will be welcomed.

I've attached one of my spreadsheets just incase.

Thanks in advance for any help you may be able to offer.

Hodgey
 

Answer:Solved: Auto Generated Email in Excel

16 more replies
Relevance 75.85%

Hi, I have download a template from http://www.rondebruin.nl/sendmail.htm and make some modification to create a tracking program for own use. Now, I would like to add in some features to my tracking program which hope it will serve better. I have few questions here which would like to seek for the expert support.

Refer to the attachment:
1. How could I make the email to send out the OPEN and OVERDUE items only(excluded the closed items)?
2. I have set the conditional format, it work in the Excel but not work in the email. How could I solve this (It's just shown differently)?

Hope to hear from you soon.
Thanks in advance.

Regards
Ykit
P/S : I am using Excel 2007 and Outlook 2007.
 

Answer:Solved: Excel - Auto Email Problem

16 more replies
Relevance 75.85%

Hi,
Outlook express... Does anyone know how to block emails with no subject line? I have been getting a rash of spam, with no subject line.
Your help would be greatly appreciated!
Thanks

 

Answer:Solved: Blank subject line

7 more replies
Relevance 75.03%

Hi guys,

Really need your assistance ..
Attached is example for my problem.

I only know how to set the parameter for the 'status' (using condiitonal formatting), but i dont know how to create the code in VBA to create emails on certain condition .. I'm not used to VBA, and still learn about it (my head was spinning lately).

So, I wish someone here could help me ..

Regards.
 

Answer:Solved: auto email based on certain condition in excel

16 more replies
Relevance 75.03%

I'm using Outlook 2002 with Windows ME. With EVERY email I send, the word [SPAM] is attached in the Subject line when it is received. Even those addresses that are listed in my "safe recipients" list.

I've tried everything! Can anyone help? Please....
 

Answer:Solved: [SPAM] in Outlook Subject Line

I'd suggest to you it is the receiver's e-mail client that is adding the [SPAM] and not your Outlook. Listing them in your "safe recipients" file will also not effect their receiving it. Somehow your e-mail is looking like spam to the receiver's e-mail program. There are several things that can cause this that include sending to many people at the same time or the subject line in the mail. Some programs deem anything from a domain is spam like "[email protected]'sCompany.com". The bottom line is that unless you change the above, it is out of your hands. Anyway, that's my view.
 

3 more replies
Relevance 74.21%

Hey everyone,

I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.

I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.

What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.

I send emails from the road on my Android phone.

Any ideas? Thanks!
 

Answer:Solved: Outlook Email to Auto-Fill Excel spreadsheet

8 more replies
Relevance 73.39%

I've always copied & pasted recipes into my e mail & mailed to myself,but now when I receive them they always say,"Spam***** before the name of the recipe I type into the subject line. I have Vista & Windows Mail. Any way to prevent this-it never did this before. Thanks, Rosebud65

Answer:Spam**** before Subject in Subject line

The "spam" classification is either being added by your email provider's spam filtering service, or by your security software's email scanner.For example, my Norton Internet Security email scanner is integrated into Microsoft Outlook. If a message is classified as spam incorrectly, I can click a button in Outlook's toolbar called "This is not spam", then a dialog-box opens where I can tick the option "always trust messages from this email address". The message is then moved to my Inbox, with the "Spam" word removed.Now any new messages in future from that email address will not be marked as spam.However, any messages I send to myself are never classified as spam anyway, so I don't know what's happening in your case.

3 more replies
Relevance 72.98%

I have Word 2003. I do a lot of literature reviews, copying and pasting from .pdf files. When I do this, the text is pasted into word only filling a partial page. I want the text to completely fill a line within the margins. So I manually go to the end of a sentence, hit the space bar once, the delete once to delete the new line/paragraph marker. Sometimes I have to do that twice. Then I go to the next sentence and repeat the steps until it is all completed. It seems this would be a good use of a macro. I can record a macro and go through these steps once but not looping through every line until the end. Can someone please help?

Zeda
 

Answer:Solved: Looping Line by Line in Word Macro

6 more replies
Relevance 72.16%

I have no idea if this is even possible, but I would like to create a spreadsheet that auto-populates a series of dates based on one date that the user enters. Let's say I have a goal date to complete a project, and for every project I work on, something needs to happen 6 weeks prior to the goal date, another thing needs to happen 4 weeks prior to the goal date, and something else needs to happen 1 week and 5 days before the goal date. I would like to set up 4 cells in Excel: one for the goal date, and three for the various things that need to happen leading up to that goal date. I would like to be able to enter the goal date into the main cell and have the other three cells auto-populate with the correct date based on what I enter in the goal date. For example, if I enter a goal date of 11/01/2016, I would like the other three cells to automatically populate themselves with: 09/20/2016 (6 weeks prior), 10/04/2016 (4 weeks prior), and 10/20/2016 (1 week and 5 days prior). Is this possible? Can Excel return dates in that way?

Answer:How can I auto-populate dates in Excel based on other dates?

Sure, it's easy. Excel internally stores Dates and Times as numbers. Each day is a whole number and time is the decimal portion of that day. See here for a pretty good explanation of how Excel deals with Dates and Times as well as links to all the various Date and Time functions that Excel offers:http://www.cpearson.com/excel/datet...As for your question, simply subtract the number of Days required from the cell with the Goal Date.With 11/01/2016 in A1, use this to return 9/20/2016:=A1-42(42 is 6*7, or 6 weeks.)I'll leave the other two formulas to you. ;-)Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 72.16%

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

Answer:Excel date auto populate date/time

11 more replies
Relevance 72.16%

First time poster here,

I need help writing a macro which I will link to a button. Here is what I'm looking for:

I have 4 columns of data starting in rown B29 and ending in G29 (one of the columns is actually 3 merged columns which is populated by a dropdown list). 2 of the columns have formulas.

I would like the user to click the button, which will add a blank row with all the formatting from above (including the same drop down list and formulas). However, I would like to be able to add multiple lines and have the new line always appear at the end of the list.

As if that weren't complicated enough. I want to add another button to act as a 'reset' button which will delete the added rows, leaving me with the original blank row.

I tried recording my own macro but that doesn't work because the merged cells un-merge as the new row is added. And I can't get the new row to always appear at the bottom if I add more than one.

Is that enough info?

Brian
 

Answer:Excel Macro to Add Line while Copying Formats/Formulas

6 more replies
Relevance 72.16%

I have a list of banned words which I have named "content_check" and are in a tab called "Guide". I want to make a macro which will check cells G13, G15, G19, G21 and E30:E6000 (if not blank) in the tab "A+_Creation" and highlight in red any words which match those in the banned words list.I'm currently using conditional formatting which turns any cells which contain a banned word red, but given that the list contains almost 400 words it would be much better if only the word turned red instead of the whole cell. Would anyone know how to go about this or if there is a forum that has already covered this? I have basic knowledge of macros, but it's not advanced enough for something like this.Any help would be hugely appreciated!

Answer:Excel Macro to color certain words in a line of text

A couple of questions just for clarification...Could you give us an example of what is in the cells that need to be checked? Are they sentences, lists, etc?Could there be more than one banned word in a given cell or is it a case of "Once a banned word is found, we can move on to the next cell."If there are any other details you think we need, please provide them. Thanks.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

10 more replies
Relevance 72.16%

Hello,

I've got this code to get rid of all leading apostrophes in the Excel (2003) Cels:

Code:
Sub Auto_Open()

Dim S As Range, temp As String
Worksheets("qryOfficeNetForeign").Activate
With Worksheets(1)
If MsgBox("Are you sure you want to remove all leading apostrophes from the entire sheet?", _
vbOKCancel + vbQuestion, "Remove Apostrophes") = vbCancel Then Exit Sub
Application.ScreenUpdating = False
For Each S In ActiveSheet.UsedRange
If S.HasFormula = False Then
'Gets text and rewrites to same cell without the apostrophe.
S.Value = S.Text
End If
Next S
Application.ScreenUpdating = True
End Sub
This code runs fine when I use the shortkey for it (CTRL + R), but when I try to autorun it I get an error:

Code:
Runtime Error 91: Object Variable Or With Block Variable Not Set
When I click the debug button, this line is selected:

Code:
For Each S In ActiveSheet.UsedRange

How can I autorun this code on opening of Excel, I would also like to run the code only if the sheetname is: "qryOfficeNetForeign"
I am no VBA expert, so am getting only errors
Thanks,
Wouter
 

Answer:auto run macro on excel start

7 more replies
Relevance 72.16%

I have started creating an Access 2007 database for users to audit part number setup information entered in separate ERP system, but need advice on best design to allow for auto-populating some of the values and user-entry for other values. Need to record part info audited, auditor name, audit date, pass or fail, add'l concerns or comments.

Scope of Auditing
Performed Monthly and Quarterly
Multiple clients with unique criteria for some values
Hundreds to thousands of parts audited monthly
Tens of thousands of parts audited quarterly
Multiple useres performing audits
Criteria for two of the values audited can change
weekly (or in a some cases more often)

Manual auditing due to frequency of changes to criteria on the two values, but considering ways to automate the auditing in the future.

Working on Quarterly Auditing functionality first because that will provide most benefit.

Database has a table "Quarterly Audit" with fields populated from query that links to tables in ERP system and has criteria to pull the correct parts and part info. It also has following fields to record auditing info - "Performed By", "Date", "Pass or Fail", and "Addl Concern(s) or Comments".

I have a login form in place and am setting a global variable "gbl_User" = username. Value set during login to the database.

I have a form "frm_QuarterlyAudit" with a subform "frm_QuarterlyAudit_sub" bound to the "Quaterl... Read more

Answer:Solved: Easiest Way To Auto-populate And User Enter Info Into Table?

9 more replies
Relevance 70.93%

My sister sent me a e-mail saying that all her e-mails when sent out suddenly have ***SPAM*** inserted in the subject line right in front of the subject she has typed. Even if she forwards an e-mail it inserted in the subject before the FW: see below an example:

Subject: *** Spam *** FW: HPSD Antenna

Has anyone seen this before? She uses Outlook as her mail client sw. Please advise, thanks
 

Answer:Subject: *** Spam ***apeares in subject of all email

Not seen that one, but.........

SpywareBlaster 3.4 http://majorgeeks.com/download2859.html
SpyBot V1.4 http://www.majorgeeks.com/download2471.html
AdAware SE 1.06 http://www.majorgeeks.com/download506.html
MS AntiSpy - http://www.microsoft.com/downloads/...a2-6a57-4c57-a8bd-dbf62eda9671&displaylang=en (XP and W2K only)

DL them (they are free), install them, check each for their
definition updates and then run AdAware, MS AntiSpy (W2k/XP) and Spybot, fixing anything
they say.

In SpywareBlaster - Always enable all protection after updates
In SpyBot - After an update run immunize

Do these and reboot before the next step.

Then get HiJack This V1.99.1 http://thespykiller.co.uk/files/hijackthis_sfx.exe - double click the DL file and click unzip letting it extract to its default folder C:\Program FIles\HiJackThis, run it from there, DO NOT fix anything, post the log here.
 

2 more replies
Relevance 70.93%

Hello,

I have an Excel sheet that contains data per row. At the end of each row, I want to put a button (or a hyperlink to a file) that will put the data from that row into a new Word document, something like a printer-friendly document.

Please find enclosed the Excel file and the DOC format that I need.
 

Answer:Solved: Populate Word Document from Excel

16 more replies
Relevance 70.93%

Have a spreadsheet, with a macro that runs on start up.

It uploads data from the web and places it in a worksheet named data, and from that worksheet certain info is used in another worksheet all of which are in the same workbook.
Macro is such that when a new month commences a new worksheet with month/year is opened

All has been working until yesterday 1/6/12 (Aust) .

The data uploaded is always 1 day behind actual date so on 1/6/12 the latest data would have been for 31/5/12 and would have gone into the May 2012 worksheet.

The problem I have encountered is that the file becomes blurry and I am unable to close it down .
Have had to manually shut down and reboot to use computer.

Ran a quick scan with Malwarebytes and it cam up with one infection "Pup.Bundleinstaller.Bi " which I had removed.
Have since run full scan with no infections

Details from Hijack this log show
Logfile of Trend Micro HijackThis v2.0.4
Scan saved at 10:22:20 AM, on 02-Jun-12
Platform: Windows 7 SP1 (WinNT 6.00.3505)
MSIE: Internet Explorer v9.00 (9.00.8112.16421)
Boot mode: Normal

Running processes:
C:\Program Files (x86)\Common Files\Acronis\Schedule2\schedhlp.exe
C:\Windows\vVX1000.exe
C:\Program Files (x86)\Google\GoogleToolbarNotifier\GoogleToolbarNotifier.exe
C:\Program Files (x86)\Skype\Phone\Skype.exe
C:\Program Files (x86)\Google\Google Desktop Search\GoogleDesktop.exe
C:\Program Files (x86)\Google\Google Desktop Search\GoogleDesktop.exe
C:\Program Files (x86)\TaskPlus\taskplus0... Read more

Answer:Problem opening Excel fiel with auto run macro

Problem solved it was not a virus .

Thanks to all who looked at asisting

Pedro
 

1 more replies
Relevance 70.52%

HiExcel XP2002 - I want to be able to put figures into cells going from top to bottom and have a "totals" cell at the bottom of these. When I reach the last cell to insert a figure I want another line to be automatically inserted and the formula in the "totals" cell to take account of that line insertion.Is it possible an if so how. Any IdeasRegards

Answer:Excel Auto Line Inserts

Enter your numbers into A1, A2, A3 ........etcIf the number of entries is, say 12, then in A13 type =B14 (assuming all entries are of equal length)In A14 type =sum(A1:A13) Which will automatically adjust the total when you have completed column B.It's much easier Done that Said.

8 more replies
Relevance 70.11%

Hi All,

I really hope someone can help me. I've been looking through all the forums and haven't quite found a macro code that has worked for me. I know this is very simple, but I have no idea what I am doing. Here it goes....

I have a very simple expense report on Sheet 1 of an Excel (2007) workbook. In this worksheet, the first couple of columns simply list the expense items. However, there is a table with only 14 rows (including the header) of data (6-19). Underneath row 19 is a total row that sums the 2 columns of information (don't need to worry about this row but thought I'd tell you anyway). This table only has 4 columns as follows:

Column G - Code
Column H - Category
Column I - $ (this column is using the SUMIF function to calculate the expense category totals)
Column J - % of Total (this column is simply dividing column I by the Total $)

I don't know if this matters or not but there is also a pie chart linked to this table of information.

I would like this table (H6:J19) to automatically sort by % of Total (in descending order) any time I add new expenses so that I don't always have to sort manually.
If there is a way to do this, I would so appreciate simple instructions. I've attached a sample of what the report looks like.
I hope you guys can help!!!
 

Answer:MACRO NOVICE - Simple Auto Sort using Excel 2007

Hi Janel, welcom to the board

I think this should do the trick, I don't have 2007 here but I used your sheet in 2003

Add the following code the the Sheet1 project

Code:


Private Sub Worksheet_Change(ByVal Target As Range)
Sheet1.Range("G7:J19").Sort Key1:=Range("J7"), Order1:=xlDescending, Header:=xlNo, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
End Sub

To do this just right-click on the Sheet1 tab and select view Code, you will automatically be in the VBAProject.

In the right screen paste the code above.

every time you change values in the list the range G7:J19 without hearders will be sorted by Total % descending order, th epoie chart will do it's own work since it's related to this table.

Happy coding.
 

1 more replies
Relevance 69.29%

Hi,

My VBA/Macro knowledge is very basic, but I am able to record macros and edit them. I have a scatter plot (with 5 series) and I want to automatically change the line style (i.e. solid or dashed etc.) depending on the text in a cell. This is what I tried, but I cannot get the code to reference the cell which contains the text:

--------------------------------------------------------------

Sub Macro14()
'
' Macro14 Macro
'
'
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Select
With Selection.Format.Line
.Visible = msoTrue
.DashStyle = msoLineSolid
End With
End Sub
--------------------------------------------------------------

For the line ".DashStyle = msoLineSolid" I tried ".DashStyle = Range("A7").Select" but this does not work.

Is there a simpler way to set-up a macro to format graphs automatically based on a cell content/format/colour, does anyone know a good guide to do this?

Thanks
 

Answer:Excel Macro to automatically change chart line style based on cell text

Hi,

I'm not familiar with charts. But, see if this helps.

http://social.msdn.microsoft.com/Forums/sk/isvvba/thread/50180062-37e0-435e-bf52-0f6de482d8ef
 

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

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

JPL

Any
 

Answer:Excel Email Macro

Hi JPL,

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

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%

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

Hello

I have a need to find a text of X in a document go to end of line select whole line and delete line and then find next X in document. With 3500 X Id like to loop till end of document. In 2010 my (pc at home) the find X part of a recorded Macro does not show up. In 2007 it shows up so I can see how it works at office. I just need to know how to loop, the above of instruction "find X, select whole line, delete, find next X" and loop this.

Eg

YYYY 1
AHKJUSKL XX
AGSJUJ ()*(IO XX
ASJ
L:JOPO
AKLSJXX
DADAD

needs to look like

YYYY 1
ASJ
L:JOPO
DADAD

using XX as the reference of which line to delete.

Cheers
Al
 

Answer:Solved: Word Macro Loop of 1) Find 2)Select line 3)Delete line 4)find.

6 more replies
Relevance 68.06%

Hello I found an answer to this question but it was specific to his form. I have several Excel Logs (Tables) that contain information that is also entered into a separate form. Some forms are in excel and some are in word. I would like to hit a button that transfers a row of data to the form so i only have t enter data once. The forms will have additional information that will be entered. The forms are saved as a specific file type and are also printed so the answer that i found on this site may work but it puts the data into a different spread sheet in the same workbook and i need to send the data to a new workbook and in one case to a word doc. Can someone help me out. I have attached a couple examples of what i currently do.

Thanks for the help
 

Answer:Solved: Populate Excel Form and Word Form from Excel Table

16 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,
Rohit"
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 @companyurl.com?I 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.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!

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

Hi:
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.

desantisj
 

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: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
'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%

Hello,

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.

Chris
 

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

http://www.rondebruin.nl/mail/folder3/mail4.htm

I have done the looping attached.
 

2 more replies
Relevance 66.42%

Hi
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.

Rollin
 

2 more replies
Relevance 66.01%

I have a table titled time_slips used to track the amount of time an attorney spends with a member. In the time_slips table there is a field titled reference_id which is a combo box pulling it's displayed information from another table titled references. Also in the time_slips table is a field named details which is native to this table.

My question is, can I have the details field auto-populate "no charge" when a certain reference id is selected (i.e. 300)?

Thanks for any help you can provide.
 

Answer:Solved: Access Auto-Populate a Field using a field from another table

15 more replies
Relevance 66.01%

Hi,
I need to add an empty line between each of the rows I have populated on a spreadsheet (Microsoft Excel 2000)

Example:
select line 2, insert row, format the cells on the new line 2.
select line 4, insert row, format the cells on the new line 4.

I need to repeat this process for hundreds of rows and don't want to have to do it manually.

I created a macro to do this but was wondering if someone could help me with a command that would automatically increment to the next even line without me having to write it out as I did below.

Any help would be much appreciated. A programmer I'm not. Thanks K2
Rows("2:2").Select
Selection.Insert Shift:=xlDown
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
Rows("4:4").Select
Selection.Insert Shift:=xlDown
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Selection.Borders(xlEd... Read more

Answer:Solved: incrementing a line Macro help

Click in a cell in the row that you want to start in and run the following macro.
Code:
Public Sub InsertRows()

Do Until ActiveCell.Row = Cells(Rows.Count, "A").End(xlUp).Row + 1

Rows(ActiveCell.Row).Insert Shift:=xlDown
Rows(ActiveCell.Row).Select
Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone
Selection.Borders(xlEdgeLeft).LineStyle = xlNone
Selection.Borders(xlEdgeTop).LineStyle = xlNone
With Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.Weight = xlThin
.ColorIndex = xlAutomatic
End With
Selection.Borders(xlEdgeRight).LineStyle = xlNone
Selection.Borders(xlInsideVertical).LineStyle = xlNone
ActiveCell.Offset(2, 0).Select
Loop

End Sub
Rollin
 

2 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
etc

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?
Code:

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:
Code:

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
Next

Does anyone have a better solution?
 

1 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
.NewSearch
.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 65.19%

Firstly i would like to say hi to everyone and thanks in advance for any advice / help.

Here is my problem...

I have a spreadsheet and it contains a list of our employees and when any of their work related certificates expire. What i would like to do is create a script??? or something that will run and send an email to a selected list of people informing them that a certificate is about to expire.

The spreadsheet is excel format and the email software my work uses is Groupwise.

Also something to note would be that there may be multiple people who have expiring certificates at the same time, would it be possible to send just one email or would individual emails be the only way to go.

I have attached a very simple spreadsheet so you can get a better idea of what i mean.

Once again, thanks guy for any help you can provide.
 

Answer:Auto Email from Excel

why oh why do spamers exist
 

2 more replies
Relevance 65.19%

Hi there

can someone help me trigger auto email from the attached excel sheet ?

The email should be triggered upon the 'status' with corresponding message from 'remarks' column
 

More replies
Relevance 65.19%

hello,
i am trying to sent out an automatic email anytime the workbook has been changed and for example 3 days have passed from a certain date on the worksheet. this would have to be applied to close to a hundred rows per sheet and would be sent to outlook 2007. not express or anything. wondering if it would require multiple VBA codes or not.
i have looked on the Ron site and many postings but i just found out what a macro was and would love to learn how to write VBA but dont have the time. looking to try and solve this. also need to know if the computer im working on has to have outlook or if i can do it from one that doesnt.
Have an example and any details for further assistance just ask. any help would be greatly appreciated thank you.
 

Answer:Auto email using excel

16 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:

http://exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html

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. "

Code:
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
Worksheets(2).Delete
Wend
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"), _
Workbooks("WorkBookName.xls").Worksheets("Sheet2")
Click to expand...

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

Apologies again
 

1 more replies
Relevance 64.78%

All of a sudden the subject line of e-mails that I compose in my Netscape Messenger 7.02 changes to a yahoo search address if I hit the enter key after typing the subject. As an example, if I enter the subject as "Test" in Messenger and hit the enter key to proceed to the body, the subject line changes to http://search.yahoo.com/bin/search?p=test

What's going on?!
 

More replies
Relevance 64.78%
Question: BCC subject line

While I'm here I might as well ask another question.

In my e-mail program how do you get the BCC to show up along with CC? I have it under one of my addys but forgot how I got it. TIA

Cin

Answer:BCC subject line

What Email application are you using?
Thanks,
John

4 more replies
Relevance 64.37%

I am new to the world of Visual Basic & Macro's so please excuse my ignorance.


I am looking to create a macro to populate

Excel Template
Word Template
from an exsisting (master) Excel file

once these documents populated I want to create a zip file containing the newly populated templates.

and then add this zip file and the details from the (master) excel file to an microsoft outlook meeting request

is it possible to do this using macros or will I have to generate some sort of code/ script

I understand there are a lot of factors i am trying to combine into one simple command and may be trying to run before i can walk, but any input, guidance or suggestions would be greatly appreciated,
 

More replies