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" <email@example.com> 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
...Resolution to printing mail merge 4 up
Here is what I had to do in order to print postcards 4 up mail merged
properly so that each name is on their own card. I am using Publisher 2003 so
I don't know if this will work in other versions.
Using the Tools>Mail Merge Wizard, Set up the mail merge the way you want it
to appear (steps 1 thru 4). Only stop at step 4 DO NOT continue to step 5.
Go to File>Print Merge
At this point you can select the printer, properties etc as well as change
copies per sheet and print range or all.
This seems to work and will place a different name/address on each card on
I ...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 <firstname.lastname@example.org>
> 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 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...Word as Outlook e-mail editor
I'm using Windows XP and Microsoft Office XP standard, 2002 version. Word
has always been my e-mail editor, but today when I tried to respond to an
e-mail I got the following message:
"This form requires Word as your e-mail editor, but Word is either busy or
cannot be found. The form will be opened in the Outlook editor instead."
After a delay, the form opens, but when I click "Send," Outlook crashes. Any
...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 ...multips errors when emailing from CRM 1.2
Since installation, I have received the following 2 errors in my app log on
every email that passes through my exchange server, even it if has nothing
to do with CRM. Now, I cant send any emails at all and I get the last error
Event Type: Error
Event Source: CrmExchangeQueueService
Event Category: None
Event ID: 5892
Time: 2:36:51 PM
The message 'CQFS001 - 03-01-2004 20-36-50-937ms' failed to deliver to all
For more information, see Help and Support Center at
and ...e-mail attached files: asks for administrator approval? my lapto
In using e-mail with attachments: clicking on the attachment, asks for
administrator approval????? my single laptop at home, no connection with
"jwb" <email@example.com> wrote in message
> In using e-mail with attachments: clicking on the attachment, asks for
> administrator approval????? my single laptop at home, no connection with
> anyone else????
Since you don't state the exact error message. I can only guess, but I guess
this: http://www...Urgent #2
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" <firstname.lastname@example.org> wrote ...mail size restriction
how to restrict the maximum size of message is 2MB for all
user to send through my exchange server 5.5 both local and
You can set restrictions on the IMS,.
Local user restrictions in 5.5 are a bit more tricky. However, by
forcing messages through the MTA and applying the limits on the MTA,
you can accomplish that as well.
Value : No Local Delivery
Test of course!
On Sat, 1 May 2004 22:37:43 -0700, "jameel"
>...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.
THanks for your reply. Wil this be fine even if my users have mailboxes
round about 1GB. My GM's mailbox is 4GB. Can i start moving the mails back
to the exchange DB and how will it affect the performance of my exchange
>I suggest applying Exchange SP2, editing registry to allow DB size to
>accommodate your storage needs and increasing storage limits.
>After all, .psts are kept on the server too, taking space. Message in
>.pst needs the same or more disk space than in Exchange DB. Also the
>same message sent to many recipients stored in Exchange DB...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...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" <email@example.com> wrote in message
> Hey guys, I cannot user Outlook Web Access anymore,...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. ...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?
...Forwarding Mail to an external Address
I receive email as I am a member of a distribution group. I want to set a
rule up in Outlook to automatically forward items addressed to that
distribution group, to an external email address. Is this possible? I tried
to set up the rule, but could not get it to work.
On Thu, 20 Oct 2005 17:17:01 -0700, RayRedSoxFan
>I receive email as I am a member of a distribution group. I want to set a
>rule up in Outlook to automatically forward items addressed to that
>distribution group, to an external email address. Is this p...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...urgent (high importance) messages #2
Is there a way to remove the high importance flag from messages sent through
We have a number of users that always set this flag even though the subject
matter of the message is not important at all.
Might be, in one of the policies that are Outlook/Office based?
Sorry can't be more specific than that...
On Thu, 10 Feb 2005 04:53:03 -0800, "Scott"
>Is there a way to remove the high importance flag from messages sent through
>We have a number of users that always set ...Clicking on new mail notification does not open email
This is a multi-part message in MIME format.
I finally upgraded from WLM 2 to 3 (14.0.8089.0726) this afternoon (Win =
XP SP2). When I get a new mail notification via Messenger and click on =
it the email does not open. I have to go to the inbox to open it. Any =