Insert Text and SendI need a macro will insert specific text into the body of the replying email
then send it. Any help is appriciated.
Thanks ... Dave
This example demonstrates how to change the Subject of a reply:
http://www.vboffice.net/sample.html?mnu=2&smp=9&cmd=showitem&lang=en
you can write your text into the Body or HTMLBody property.
--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
<http://www.vboffice.net/product.html?lang=en>
Am Wed, 12 May 2010 13:42:01 -0700 schrieb ...
Capitalize the 1st letter of text entered in a cellI frequently enter text into cells. Sometimes the text is entered in
lower case letters. I want the 1st letter to be capitalized
regardless of my entry. Are there any suggestions? Thanks in
advance.
Michael
You can only do this with code. There is no formatting command that
can be used. Right-click on the appropriate worksheet tab, choose View
Code, and paste in the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ErrH:
If Target.Cells.Count > 1 Then
Exit Sub
End If
If Not Application.Intersect(Target, _
Me.Range(&q...
RMS Item Picture format issues?!?Hello,
I've tried a number of jpg saves at various dimensions 300x300 pixels
down to 100x100 pixels. Sizes from 50K down to 20K. However, the
pictures still aren't visible within the "Special" Item Attribute
picture window. If the picture doesn't show up there, it doesn't show
up in my POS.
The "stock" images provided by MS, with the storelogo.jpg and
storelogo2.jpg work perfectly. I've even tried to save to the same
dimensions and filesizes, and still no dice.
Can someone please advise me as to the requirements of pictures to be
implemented (and maxi...
Changing text sizeHi,
We enter all our customers in our database in all caps (text) for the
names, and addresses. But when you put in the zip code and the database auto
finds the town and state it is put in upper, and lower case.
Is there a way to change this default to all caps for the auto fill.
I am experienced in editing xml. files ( just a note)
Any help would be appreciated.....Dennis
No, there's no way to change that in the front end, that's something that is
happening at display time and is meant to make the data more readable. You
could enter a suggestion on Customer Sou...
Pasting to Rows with with text onlyHow can I tell Excel to paste data in column A, but only to those row
that contain data? I know there is a way, but how?
Thanxs in advance...
--
Message posted from http://www.ExcelForum.com
Hi
one way:
- copy and paste your data (including formulas)
- select column A and hit F5
- choose 'Special' and check 'formulas'
- hit 'DEL'
--
Regards
Frank Kabel
Frankfurt, Germany
> How can I tell Excel to paste data in column A, but only to those
rows
> that contain data? I know there is a way, but how?
>
> Thanxs in advance....
>
>
> ---
> Message ...
Count values in Cells AccrossI want to calculate the values in cell A1 across.
Eg. Cell A1 has a value of 36. I want to calculate the values across
in the 36 non blank cells located in the same worksheet.
Any help appreciated.
Thanks in advance
Hi
see your other post
--
Regards
Frank Kabel
Frankfurt, Germany
Shari wrote:
> I want to calculate the values in cell A1 across.
>
> Eg. Cell A1 has a value of 36. I want to calculate the values across
> in the 36 non blank cells located in the same worksheet.
>
> Any help appreciated.
> Thanks in advance
...
set all INCOMMING MESSAGES to open in Plain TextI was wondering if there is a way to make all outlook
messages open in plain text in outlook 2000 like you can
in 2002 and 2003.
thank you in advance
There's nothing built into Outlook 2000 to do this, but you might want to
install an add-in like Chilton Preview that will allow you to preview all
messages in Plain Text. You can also use VBA code to force plain text. See
http://www.slipstick.com/dev/code/zaphtml.htm for more information.
--
Jocelyn Fiorello
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve...
missing cell?Hello! The other day my girlfriend had to do some excel stuff. Curiosity
got the best of me and I had her explain what she was doing.
Here is a simplified version of her ordeal:
She had one hand written table with ~1000 rows and 2 columns: one for a code
and one for a description.
She also had a text file with ~16000 rows and 2 columns with the same codes
and similar (but different wording) descriptions.
She needed to produce one spread sheet with the ~1000 rows of the first spread
sheet and 3 columns: the code and the 2 descriptions.
After fat fingering a row of the hand written table she...
Start a file at a defaulted worksheet/cell?Howdy,
Having a few users to a file, can I have the file open to a default
worksheet/cell as I have directions I want them to read before playing...
Regards,
Kevin
Kevin, use something like this, put in thisworkbook code
Private Sub Workbook_Open()
Sheets("Sheet2").Select
Range("C3").Select
End Sub
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"...
Different Type of Picture in a DocumentI have received a document that i have to work on that was compiled by
various folks and I have no idea who did what.
When I select pictures within the document, I have some pictures with
the usual single border; circles at the corners, and squares at the
edge.
I have other pictures, that when selected, have a double border, that
is turquoise. There are three dots in a row at the sides and three
dots in a triangle at the corner. With this type of picture I cannot
explicitly set the size or other options available with the type
above.
Does anyone know why some pictures would be ...
changing cell value depending on list selectionI have a long coloumn of data which is entered by selecting from a dro
down list (data/validation/list)i want a numerical value to b
associated with each value from the drop down list. I would also lik
this value to be dependent on another value in another cell.
ie:
A B C
one build 1
two
three build 2
Coloumns A and B are drop down lists and C is a numerical value tha
appears only when Build is in coloumn B and the value depends on wha
is entered in coloumn A.
Hope this isnt too confusing!
Thanks
Rober
--
Message posted...
numbers as textUsing Excel 2007
I have entered a long numeric string (a bank account number) as text. The
entire Excel worksheet is then saved as a .csv file. The file is closed.
When the file is reopened, the long numeric string has been converted to a
scientific format (1.45684E+11) which can be converted again to text but
will not keep that format during the save process.
The bank is requiring the file to be saved in .csv format, so I don't have
the option of saving in Excel format.
Any suggestions????
On Tue, 15 Dec 2009 15:03:38 -0600, "BK" <nospam@nospam.co...
Saving from Excel to textI am trying to save an excel spreadsheet as a text (tab
delimited) file but for some reason chracters are being
replaced with a '?', does anyone know why?
Any help would be greatly appreciated.
Tracey -
How are you saving the file? Try highlighting the
spreadsheet, copy, open Word, paste. Highlight the text
in Word, go to Tools, Table, Convert Table to Text, and
choose the Tab delimiter.
HTH,
Carole
>-----Original Message-----
>I am trying to save an excel spreadsheet as a text (tab
>delimited) file but for some reason chracters are being
>replaced with a ...
Rotating Text Boxes on a ChartExcel won't let me rotate text boxes in my pie chart.
When I go to do it the rotate buttons are greyed out.
Also I can't figure out how to add text the curves with
the outside of the pie chart. Please help! Thanx!
Hi Jeff,
You won't be able to rotate textboxes.
If they are really data labels you can alter their alignment. But they
won't curve.
If you want text to wrap around the pie you could try using word art.
Although a pie with more than a few slices will probably result in text
not appearing next to the slice.
Jeff wrote:
> Excel won't let me rotate...
Lost Ability to Include Selected Text in RepliesVersion: 2008
Operating System: Mac OS X 10.6 (Snow Leopard)
Processor: Intel
I no longer seem to be able to select some text in a message, and begin a reply to that message quoting only the selected text. Either in HTML or plain text, the selected text does not appear. I have tried all Preferences>Compose, Reply permutations. Either all of the in-coming message is included, or none is included. Does anyone have a similar issue?
On 3/2/10 11:04 AM, AndyBobyarchick@officeformac.com wrote:
> I no longer seem to be able to select some text in a message, and
> begin a reply to ...
How can I undo text scaling in New mail windowI am using Outlook 2003, and when I try to compose a new mail the text that
is displayed is HUGE.
I want it as it used to be where the text is about size 10, unaffected by
whether my mail-window is large or not.
I have tried changing it to web layout, and this seems to do the trick, but
that only works for one mail, and when I create a new one I have to do it
all over again.
There must be a way around this?
Can anyone help?
Stian
...
For Each cell In Selection.....This is a multi-part message in MIME format.
------=_NextPart_000_002B_01CA80FF.54EDB200
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
The selection contains 1 column
The number of rows is variable
If i want to execute the "For Each cell In Selection" command, but i =
want the execute this for 1 row less than the actual selection...(the =
last row is not to be executed)
How do i do this ?
Thanx,
Luc
------=_NextPart_000_002B_01CA80FF.54EDB200
Content-Type: text/html;
charset="iso-8859-1"
C...
Resize cells to be able to view
I have (1) cell per line that has a lot of extra data in it. Therefore
because of this I can only view (2) rows on a page. There are 1,28
rows that I have to view and extract data from. For instance, the cel
that I am concerned with has:
Pentium 100MHz CPU with 16 MB RAM and 256 KB VRAM on a PCI and ISA Bus
One Hard Drive 850 MB EIDE HD, No CD/DVD-ROM Drive, (1) 3.5'' Flopp
Drive and No Free 3.5 Floppy Bays, Two Free 5.25 Floppy Bays, PS/
Keyboard and PS/2 Mouse, 1 Parallel Port and 2 Serial Ports, Sound Car
Not Included, USB Ports Not Included, Modem of Unknown Speed Included
10B...
Cell Format Issue #2This is a multi-part message in MIME format.
--------------040909020107010208010705
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
I need to create a cell format so that when numbers are typed they
appear as # / #, with a slash extending from the upper right corner of
the cell to the lower left corner. I need the numbers to appear left,
slightly above the slash and right slightly below, sort of in a
superscipt,subscript orientation. I do not want the data to appear as
a fraction. I tried experimenting with custom formats, to numerous to
l...
cell format #6Hi,
I have to convert the cell format from .123 to 0,123, how does it work?!
thanx!
Paul
Which version of Excel?
With 2002 or 2003 under Tools>Options>International you can change the decimal
separator to a comma.
Earlier versions would require you change your decimal separator in Windows
Regional and Language Options.
Gord Dibben Excel MVP
On Wed, 16 Feb 2005 23:58:55 +0100, Paul <taubenvergifter@saeuferleber.de>
wrote:
>Hi,
>I have to convert the cell format from .123 to 0,123, how does it work?!
>thanx!
Hi Gordon, thank you very much!
Gord Dibben schrieb:
&g...
Filling cells with Serial Port DataHi All
Anyone know how I would go about filling Excel spreadsheet cells with data
from the serial port?
Thanks
"Funster" <fun.ster@ntlworld.com> wrote in
news:z%oWb.9627$q%6.2970724@newsfep2-win.server.ntli.net:
> Anyone know how I would go about filling Excel spreadsheet cells with
> data from the serial port?
probably one of the first results on
http://www.google.com/search?q=excel+data+acquisition
will tell you what you want
--
My email address has an extra @ (spell it out) and an extra invalid. Please
remove them if you are not a spammer or list broker and ...
How to copy block of cells and keep grouping?
I have about a 150 by 30 block of cells. About every 5 cells are grouped
together, making it significantly smaller. when you click the "-" to
have them contract.
I will take me days to go through and make all the groups again if I
want to make the same block on the same worksheet.
Is there a way to copy a block of cells and include the grouping?
Thanks
--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24225
View this thread: http://www.excelforum.com/showthre...
is it possible to show a cell value using IF(AND functionI would like to show the value of Cell A1 in Cell A3 , what do I need to
replace "=A1" portion of formula
The cell format is set for numbers and there is also some conditional
formating
Formula contained in cell A3 =IF(AND(A1>0.1,A1<99),"=A1","")
Displays Result as =A1
Thanks in advance all assistance or guidance greatly appreciated.
Hi
Almost there!! Just replace the "=A1" with A1
=IF(AND(A1>0.1,A1<99),A1,"")
--
Regards
Roger Govier
"FennisDuck" <Fennis@Menace.AOL.com> wrote in message
news:%...
Run Macro button after info is entered in a cellI want users to enter data in I3 then be able to click a "find" button which
will run the macro below, but the macro won't work because excel is waiting
for the user to click "enter" or "tab" after entering data in I3. How can I
make the macro work?
Range("J3").Select
Rows("4:5").Select
Selection.EntireRow.Hidden = False
Range("I3").Select
Until you finish inputting the command into I3, XL won't do any macros. Is
there some significant reason why the user can't hit "enter", "tab...
Is there a way to "glue" a matrix rectangle of cells together?The cells would only be moved as a group, but could be detached from each
other at some point.
Dshope -
One way: First select the rectangular range of cells. Then move the cursor
near an edge of the selection. When the cursor turns into a four-arrow
shape, click and drag the entire range to a new location.
- Mike
http://www.MikeMiddleton.com
"Dshope" <Dshope@discussions.microsoft.com> wrote in message
news:94B03F9D-84F2-44E3-8DE7-5A5992C6EEAD@microsoft.com...
> The cells would only be moved as a group, but could be detached from each
> other at s...