I have a 2k line excel doc witht he following
Item 339393 no longer in stock - Tuesday, September 11, 2007
I need to separate the data into 2 cells
how can i remove the date infomation from the field and put it in a
new cell by itself?
Select column A>Data>Text to Columns>Delimited>Next>Other> put - in box next
"Mrbanner" <firstname.lastname@example.org> wrote in message
>I have a 2k line excel ...How do I send copies emails without sending attachments?
I send emails with attachments to our bank. My boss wants a copy of the
email but not a copy of the attachment. How do I do that?
Steve Bramblett wrote:
> I send emails with attachments to our bank. My boss wants a copy of the
> email but not a copy of the attachment. How do I do that?
Each recipient gets the SAME copy of the e-mail. If you want different
recipients to get different versions of your e-mail, you have to send
...No message in outbox
I tried to send a message with 1Mb attachment to 40 recipients in the bcc
field. It gave me an error message from the isp's server, the message was
NOT sent (I've checked), it did NOT arrive in Sent Items, but neither is it
in the Outbox any more. I can send and receive email successfully.
Problem is, every few minutes Outlook tells me it's sending message 1 of 1,
it fails and gives me the same error message. Yet there is no message in
the Outbox. But what happened to the original message when it first failed
to send? I guess it's 'stuck' somewhere but I can...Sending mail from selected email address
As I have 4 email accounts set up in Outlook, I understand that I can send
mail from each or any account.
The accounts are listed under tools / Send and Receive / then each of the
How can I choose which account to send from so that the recipient see's who
I want it to be from??
Hope that explains it.
On Sat, 16 Apr 2005 21:10:48 -1000, The Fatman <email@example.com>
> Hi All,
> As I have 4 email accounts set up in Outlook, I understand that I can
> mail from each or any account.
> The acco...Sending a macro to another PC-how?
How do you send a macro you've written to another PC so
that they can save it in their Personal.xls file (at
Program Files\Microsoft Office\Office\XLStart)?
You can export a macro and save it, to do this from your workbook,
right-click the workbook's icon and pick View Code. This icon is to the left
of the "File" menu this will open the VBA editor, click on the module you
want to save and go to file and export file, then save it to a floppy or
what ever you backup to, then import it to the new workbook.
Always backup your data before trying something new
Using ...Always on top dialog
Hi everyone, how can I make my dialog-based program always on top? Is there any setting
Thanks in advance
SetWindowPos(&hwndTopmost, 0,0,0,0, SWP_NOMOVE | SWP_NOSIZE);
On Thu, 22 Apr 2004 21:07:01 -0700, Robson <firstname.lastname@example.org> wrote:
>Hi everyone, how can I make my dialog-based program always on top? Is there any setting?
>Thanks in advance
Joseph M. Newcomer [MVP]
MVP Tips: http://www.flounder.com/mvp_tips.htm
Well, I think he wants it always on top, not only when it is activated.
Perha...Sending mail from remote location
my mail works great while at home. when I go on the road I can receive
ail but not send. I get the following error message:
Subject 'SKIDOO MACH Z 800LT (long track / long tunnel) (Jackson)',
Account: 'Jeff', Server: 'smtp.charter.net', Protocol: SMTP, Server Response:
'571 imp11 smtp.charter.net OTcuMTQ3LjE2LjIzMA== You must connect from
Charter IP space. E1110', Port: 25, Secure(SSL): No, Server Error: 571,
Error Number: 0x800CCC61
It worked on my last laptop and I have not been able to figure it out on
this one. I can't remember what I...anchor picture to text box
(Publisher 2003) I have a newsletter with a Kudos box. In the corners of
the box I have a happy face. I'd like the happy faces to be anchored to
their corners so when I enlarge or shorten the box, the faces move along with
the text box.
Why not create a rectangle, insert the happy faces, group. The problem as I see
it would be if you resize, the happy faces could be distorted if you widen or
shrink the group. You would always have to re-size proportionally.
"Helen" <Helen@discussions.microsoft.com> wrote in message
My Outlook 2003, is configured with two e-mail accounts, how can I configure
Outlook to send messege using alternative e-mail account automatically if it
failed to send using the default e-mail account?
This feature was available in Outllok 2002
On Sun, 12 Feb 2006 16:42:30 +0200, "Mahmoud"
>My Outlook 2003, is configured with two e-mail accounts, how can I configure
>Outlook to send messege using alternative e-mail account automatically if it
>failed to send using the default e-mail account?
>This feature wa...2.0 Threads, Join() and Invoke
I just want to run several threads at the same time.
The code below just hang because - I guess - it can't access the
What is wrong with tis code ?!
public class Report
public TextBox _log;
private List<RptTemplate> _listeTemplate;
private List<CIF> _listeCIF;
public Report(TextBox logTextBox, List<RptTemplate> listeTemplate,
_log = logTextBox;
_listeTemplate = listeTemplate;
_listeCIF = lis...Send and Recieve Fix
For a long time I had a problem with my Send/Recieve function in Outlook.
This happended in both Outlook 2000 and my current version - 2007.
I found I had to re-boot my computer to perform a Send/Recieve in Outlook.
Otherwise the sequence would start then stop and say it could not perform
due to an error.
After extensive Internet and News Group research I decided it was time to
run a check on disk errors.
This Windows XP facility seemed to have fixed my Outlook problem.
I did this about a few months ago now and I have since had no problems with
my send and recieve.
Unfortunately I do have ...Unable to send?
I've got MOOL, and i"m usign ti with outlook. The emails that I'm
sending are just "stuck" in the outbox? Can anyone give me an idea of
what's going on?
Did it ever work? Are you able to receive?
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Rekks" <email@example.com> wrote ...Can I print 2 A5 side by side on A4 landscape
Using Publisher , how can i produce two identical A5 text layouts ,
side-by-side on a sheet of A4 landscape paper
Setup your printer first, select A4. In page setup select custom, landscape, input
14.8cm width and 20.997cm height. The dialogue on the page setup will say "Prints 2
copies per sheet, 2 columns of 1."
Mary Sauer MSFT MVP
"Molly" <Molly@discussions.microsoft.com> wrote in message
> Using Publisher , how c...RE: How do I get my new dialog box to invoke when I press New Menu Item
1. Machine and OS specifications
I have Windows XP running Office XP Standard Edition. These software
packages are installed on my dell Inspiron laptop. I have 128 MB RAM with a
40 GB HardDrive.
In excel, when I pressed the New menu item, a dialog box would appear
displaying all of the known templates. Now, only a new worksheet appears.
I would like for the dialog to appear again. Can someone tell me how to get
the dialog box back displaying all of my templates?
The default New button has always generated a new workbook, no dialog box.
There's ano...No Permission to Send/Receive Email???
I just replaced our server hardware, upgraded to WS 2k3
Enterprise and created a new domain. I transferred the
client files and desktop on our desk/laptop computers
over to the new domain. We do NOT have Exchange
installed yet, but use Outlook 2002 with the email etc.
saved on the client.
One one client machine (mine), the email, calendar, etc
are there, but when I hit the Send/Receive button, I get
a message saying that I don't have permission to perform
this operation. Also when I try and change the automatic
check for email option it tells me I don't have
permission. ...Web Access #2
Hey guys, I cannot user Outlook Web Access anymore, where can I troubleshoot
You haven't said what version, and given very little information to go on,
so this reply may be way off. You could start with the OWA troubleshooting
For Exchange news, links and tips, check:
"Melvin" <firstname.lastname@example.org> wrote in message
> Hey guys, I cannot user Outlook Web Access anymore,...Sending messages in Outlook
We have a user that everytime that she sends an email she
will get booted out of Outlook. The email does go
through, but she will have to get out of Outlook. When
she goes back into Outlook, everything is fine until she
sends another message. Any help would be appreciated.
...Send Do Not Send
When I attempt to email via a print server - OutLook
Express displays the message "A program is attempting to
email on your behalf" Send or Do Not Send - How do you
prevent this from happening? And just automatically send?
...Help please using a combo box with a query instead of the usual wildcards etc.....
I have nearly finished my database and I would like to add a query
that uses a combo box to get the results, not the usual paramater
style input. I suppose it would need a form and a query and a combo
box, but where to start !!!!!!!!
Any kind soul out there that can give me an example of where to
The generic approach you'd use is:
* create a new form, add a combo box that is set to return the value your
query would need
* create your query ... in the criterion "cell", put a reference to the
form's combo box's value:
...CListView Problem #2
I have a strange problem that 'just appeared' a couple of days ago.
Both views are derived from my CLView:CListView. I also have a CLView
object in another view not derived and driven from the doc that's fine.
I can only hope this rings a bell as I've shut _everything_ off in the
report view, (toolbars, initializing columns, writing rows, styles,
tooltips, anything my derived class does.) The only thing I'm doing that
is different than MFC is my doc manager deletes and creates views in the
main frame, but I doubt th...master pages #2
I have a two-sided Master Page in a booklet publication that I am using for
the cover page. In Master Page view, both sides of the page appear just fine.
But when I exit Master Page view, the publisher page only shows up as one
I am not using a Web publication, and I have selected two-page master when
I created the page, and I have applied the master page to the publication.
Why does the two-sided master page only show up as one page in the published
Try adding two pages. You must have four pages for 2 facing pages to "work."
The front "cover" sh...missing public folder #2
For some reason completely unknown to me, many of the public folders
dissappeared from the M drive and are no longer accessible from the
Outlook clients. On the other hand, when I look at the Exchange
administration program the folders are all there and the permissions
seem correct. Is there any way of getting these back without doing a
complete system/Exchange restore?
Sounds like Joe has exactly the same problem I am describing.
I did look at the EMS and all of the folders are indicated and the
permissions are correct. No one touched these things. Still they do
not appear on the M drive a...how to set mouse focus to first control in a dialog?
When my dialogs first appear, I need to press the mouse button twice - the
first time to make the dialog responsive to the mouse, the second to get a
response. What do I have to do to avoid the first mouse click? It seems
to me the dialog should immediately be responsive to mouse input as soon as
it appears. I've tried SetFocus, and GotoDlgCtl but they do not solve the
problem. Does anyone have any suggestions? Thanks for your time.
Do it in OnInitDialog and return FALSE if you want focus on a different control the first
control on the dialog.
Ajay Kalra [MVP - VC++]
aja...What was Outlook sending?
I downloaded my messages using the option "send and receive all".
However, the "Show Progress" box indicates that I was also 'sending something'.
But I had nothing to send!
I look in the "Sent items' folder and nothing was sent at this time.
What was Outlook 2003 doing?
The usual response here is, "You have a virus". It could
be that a virus program is using your Outlook to send spam
and/or a copy of itself to people in your address book.
I hope this is not the case, but please have the foresight
(aftersight?) to look into ...Sending on behalf... Exchange 2003
Is there a better way to give a few users the ability to send mails also
from the email@example.com mailbox without having them logout and login to a
different Outlook 2003 profile... Or without the text sending on behalf
of... So my question is, Is there an easy way that a user can select another
e-mail address and send mails out...?
Thanks a lot in advance!!
On Thu, 05 Oct 2006 12:57:12 GMT, "BY" <firstname.lastname@example.org> wrote:
>Is there a better way to give a few users the ability to send mails also
>from the info@dom...