to begin with i have no great excel skills
what I am looking for is a macro that I can easily use
to send mail to a list of users I have made a web page that students
sign up on http://biosciences.utoledo.edu/prs
enter there info when they press submit the data is saved to a text
file that can be opened as a csv file in excel I would like to have a
macro go row by row down the page and extract the email from column G
and insert that in to an email and also the students name from coulmn
B. The csv file is set up like this
ID Fname Lname StudentID TransmitID Section e...Office X 10.1.6 Update: Fonts missing?
> This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
Content-type: text/plain; charset="US-ASCII"
After updating to 10.1.6, some fonts are missing (KidPrint, Lucida
Content-type: text/html; charset="US-ASCII"
<TITLE>Office X 10.1.6 Update: Fonts missing?</TITLE>
<FON...Find Next Row With No Value In It
I've got this
nextrow = Cells.Find(what:="*", searchdirection:=xlPrevious,
searchorder:=xlByRows).Row + 1
which will find nextrow with nothing in it and select cell in Col A,
but now I've got formulas in the cells, so instead of finding the next
row with nothing in it, I want to find the next row with no value -
even if it's got a formula in it. Can I do this by amending what's in
the what:="*" part of this code?
It's always better to include all the parms for .find(). If you don't, then
you're at ...Need VB code to edit cell values
I need some VB to do the following please (My VB is not good enough yet)
Starting from the active cell (call it the StartCell)
In the cell to the left..
ThreeChars = Value.right(3) (the last three chars)
Value = Value - last three characters (assume value is text & at least 3
value = ThreeChars (as text, overwrite any contents of StartCell)
move active cell one down from StartCell
Examples of before/after
Microsoft MVP Excel
"Stephen Ford" <Stephen_Ford_no@spam_uwclub....Routing Engine not starting, please help ASAP
Exchange and Windows 2003
I cannot get the Exchange Routing engine to start up. Upon startup I get an
event ID 7023 telling me that the path is not found. Everything else works
and starts up just fine, people can open mailboxes, but cannot send/receive
I read online that it sounds like the metabase.bin file is corrupted. I
uninstalled/reinstalled IIS, reinstalled Exchange 2003, and have reinstalled
Exchange 2003 SP1, everything works except that I still cannot get the
routing engine to kick back on.
Any suggestions! Thanks!
Was this an OEM preinstall? I recently bought a ser...Help Microsoft Office 2003
After now using Microsoft Office 2003 for about 3 months now, have suddenly
noticed that my email messages have just started showing strange symbols for
certain punctuation. This does not show as I type... but the recipent sees
these symbols when the message is received. I can see it when they reply
The strange symbols show for the apostrophe and sometimes for the
exclaimation. I do not recognize the symbols.
I do not have caps lock on, do have number lock on. None of the symbols show
on my keys.
it's caused by character encoding. What email client and....pst folder help
How do I put a .pst folder in My Documents for constant up to date copying?
Mine seems to be in a folder called Office Data File which I cannot open but
do not see any pst file...can someone kindly help me out here?
Right click the pst in outlook and select properties and then click Advanced
You will see the location of the file.
Depending on your view settings it may be hidden.
Close the pst, (right click it, close)
Move the file to the location you desire.
select File - Open - Outlook Data File
Browse to the file and select it. OK
&quo...Help with macro to choose printer
I am new to macros in Excel and this is what I did to print a worksheet:
ActiveSheet.PageSetup.PrintArea = "$A$1:$W$35"
Selection.PrintOut From:=1, To:=1, Copies:=1, Collate:=True
Works great except that I want to select the printer to use and the macro
won't stop at the point to choose printer.
Any way to work around this?
Any help is greatly appreciated.
Emilio,this wil...Help with an expression to calculate a profit from one of three fi
Using Access 2003 SP3 - in Forms
I know I'm probably asking a very complex question, so a very big THANK YOU
to whomever can help.
I am doing a detailed inventory and need help with an expression in my form
that will calculate my profit based on one of three fields. Only one field
would have the end data.
To clarify what I am working with: Most stock items come by the "unit" and
contain multiple "subunits" which, in turn, contain smaller "pieces."
However, some "units" only come with "subunits" and some only come as &quo...Printing checks #13
When i print a check in money deluxe 2005, It put the payee name on the pay
to the order of line but also prints it below this line. Id this acceptable?
and is there anyway to stop it from printing the payee name twice?
Go to Tools, Settings, Print Checks and uncheck Print payee name in first
line of address field.
"vermonter" <firstname.lastname@example.org> wrote in message
> When i print a check in money deluxe 2005, It put the payee name on the
> to the order of line but also prints it below this...how do you formula's but leave the value.
hi,how do you formula's but leave the value.
if a1=1 and b1=2 and you have a code in c1 that says
c1 value would = 3
but how do you then delete the formula so that is stays
i hope you understand what i mean.
copy (don't cut) C1 and then click on C1 again and choose Edit / Paste
now choose values
and click Ok
this should give you what you want
"craig" <email@example.com> wrote in message
> hi,how do you formula's but leave the value.
> if a1=1 ...Help with Lookup #2
I have an excel worksheet that has approximately 20,000+ records. I
would like to classify these recorded based on two columns. The first
column's name is "YB Description" and the other is "Sold Date". The YB
column mainly contains 4 digit numerical values, with approximately
300-400 records that are text, ie. "classified", "not verified",
"public use". The Sold Date column is pretty self-explanatory, all the
records are dates with the following formatting - M/D/Y. What I would
like to do is create a third column called YB/Sold that classi...recurring meetings 03-26-10
How do I transfer ownership of a recurring meeting on my Outllok calendar?
"Janet Hi-Stat" <Janet Hi-Stat@discussions.microsoft.com> wrote in message
> How do I transfer ownership of a recurring meeting on my Outllok calendar?
You can't. You must delete the existing event and the new owner must create
Brian Tillman [MVP-Outlook]
Since MS Security Essentials was NOT able to prevent me about the virus Pushbot.gen!C (it has accused its presence, but did not remove it), I don´t get to start Outlook 2007.
The message it shows is "Outlook was not able to open extend.dat file". The next message is "you don´t have the permission to open the C:\users\xxx\AppData\Local\Microsoft\Outlook\Outlook.pst".
I have administrative privileges and use Windows 7 OS.
I´ve des- and re-installed Outlook twice and the same error appears.
I´d appreciate a help on this subject.
Felix ...Need a code
I need a code that does the following:
If C3>D3, B3 value will start blink and if C3<D3, E3 value will start blink.
Any help please.
Thanks in advance.
Personally, I would recommend against blinking text, but if you insist on
employing it, this website should help you get started...
NOTE: Pay particular attention to the second of the two points delineated in
the Summary section at the bottom of the webpage.
Rick (MVP - Excel)
"MAX" <MAX@discussions.microsoft.com> wrote in message
news:C7E6...Help with ACT! to CRM migration
Hi to anyone that can help.
I am trying to do a trial data migration from our ACT! database to MSCRM to
see what it will look like. I have installed the migration framework and
appear to have CRM running fine on a server in our network (no errors on
install and all windows appear ok).
Since I do not have a strong database background I was wondering if someone
could confirm what I believe is MS's way of migrating my data accross.
I have exported the data from ACT! to a text file. I imported this into
excel and repleaced the Free/busy data with a unique number for each record.
I the...duplicate records 10-26-05
How can i make a field as primary? For Example: in the account record, can i
make the account name as Priamry.
How can we control duplicate records in CRM? like cases, contacts, accounts
Do we need any customization? What tools can we use to accomplish this?
In CRM 1.2 you can not change the primary field and there is no duplicate
checking. There are 3rd party tools that can do searches for duplicates and
let you merge them, but nothing really effective at preventing duplicate
records. For CRM 3.0 there is an example in the SDK of how to create a custom
duplicat...Minutes and Seconds Formula
I'm developing a workout programs for runners. I need a spreadsheet that
will allow a user to enter min/seconds that is their target for running a
Then I need a formula that will provide intervals at every 16th of the mile
of what there time should be.
Any help. I thought i knew how to format to show min/sec but i'm having all
kinds of problems
Put your target time in A20, and in B20 add =$A$20*COLUMN(A20)/16, then copy
across to Q209.
I input a target time of 4:32, and got values of 00:17, 00:34,00:52, etc.
(remove nothere from the em...How do you convert a formula cell to a constant cell
I use a formula to calculate the value, such as time difference, and want to
save the value not the formula. The value (constant) will be used later to
adjust both time cells used as arguments in the original formula--thus the
need to preserve the value computed rather than the formula.
After calculation, copy the cell with the formula then Edit - Paste Special -
Values on the same cell. HTH
> I use a formula to calculate the value, such as time difference, and want to
> save the value not the formula. The value (constant) will be used later to
> ...Experts Needed for Color Coding
Hello: this ought to be a challenge.
I have a spreadsheet with 10 columns
Col A contains an ID
There are various color coded cells in each;
Row 1: B - C are red; F is yellow
Row 2: C is green; E is yellow, etc.
Row count could be up to 300
Before refreshing this report (from Access query)
1. identify cell color for cells in rows
2. After refresh, find row (per the ID field) and replicate the color
New unique rows may be added during the refresh; these will not be color coded
The color is applied without consistent rules in many cases
Rather than refreshing the repo...Help with Links to Files
I have a file in Word 97-2003 compatibility mode. When I select the Office
Button / Prepare I see an option to Edit Links to Files. If I convert the
file to 2007 format the option for Edit Links to Files is no longer there.
Where did they go?
This is strange. The Edit Links to Files option should be available even if
you save in Word 2007 format. Are you sure you didn't inadvertently break
the link to the automation object?
You could press Alt+F9 to see that the field code for the object is still
intact. (Note that you can only see the field co...Need help backing up OL2002 items (or folders)
"If you want to create a folder to which you can drag items for
safekeeping or to distribute to another computer.
Create a new data file (.pst) and drag items to it. If you used the
default name for the folder when you created the data file, the folder
will be called Personal Folders . In the Folder List (Folder List:
Displays the folders available in your mailbox. To view subfolders,
click the plus sign (+) next to the folder. If the Folder List is not
visible, on the View menu, click Folder List.), drag any item from your
current folders to the new folder. Press CTRL...NEed report of income and expenses broken down
I'm using Microsoft Money 2006 and I entered all of my checking
account transactions for last year and categorized everything. Now I
need a report of the income and of the expenses broken down by
category, with the transactions listed. If I go to reports, all I can
get is a pie chart or bar chart. I need a printed report with numbers
to give to the accountant tomorrow. I was able to export a report to
a spreadsheet, but all it did was show the total expenses in each
What I need is a report showing the categories for income and for
expenses, list the transactions in each ca...Need to sort dates before 1900 in proper order
I need to sort dates before 1900 in proper order -- ones after 1900 are all
fine but any dates like 03/29/1865 will always sort by month and day but
NEVER the year except in the month area. Don't know if I am making sense --
but will be like:
I can provide a chunky workaround, until someone provides a better
Assuming your 5 sample dates are in cells A1 ~ A5, and that single
digit months and days are always expressed with a leading zero:
In cell B1, enter this formula:
In C1, ente...network 06-27-10
im running xp pro x64.
my problem being i have an workgroup drive listing that i would liked removed.
when i r/ click on it i dont have a delete option.
how do i remove it.
of course it is not my drive...hehe
Thank you in advance
"SMJD" <SMJD@discussions.microsoft.com> wrote in message
> im running xp pro x64.
> my problem being i have an workgroup drive listing that i would liked
> when i r/ click on it i dont have a delete option.
> how do i remove it.
> of course it ...