how do i e-mail one page only in excel(trial)
i am attempting to e-mail one page of a workbook and can not figure out how.
i do not wish to attatch the complete workbook.
If you mean one worksheet and not one "page", you could copy that worksheet to a
new workbook and send that as an attachment.
If you mean one "page" from a worksheet, select and copy then paste into the
body of your email message.
Or File>Send to>mail recipient>send current sheet as message body.
For all Excel email questions get answers at Ron de Bruin's site.
Note the SendMail add-in available as well as the code.
http://www.rond...Fetching data from another worksheet
hiya, i need help. what i want to do is get worksheet A to look,by name
for another worksheet and collect data to be displayed in a cell within
worksheet A......is this possible? many thanks in advance. Please bare
in mind i am a complete muppet with excel and probably shouldn�t be
attempting this so please be kind with any answers.
c2k2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31676
View this thread: http://www.excelforum.com/showthread.php?threadid=513705
This formula, ...Inventory transfer costs
We are new to GP, and are entering inventory Trasfers to our other location
for the first time, and the item costs are not automatically showing up even
though the costs are all entered into the inventory cards. Is there a way to
have those appear automatically??? It is very time consuming to have to go
to the card to see what the cost is and enter it manually for each item,
especially when you have 500 items to transfer.
Thanks for your suggestions!
What Inventory Valuation method are you using? The Perpetual methods use the
Current Cost while the Periodic methods us...Select Noted Memo Field
I have a table with 25 memo fields used sequentially for separate comments,
i.e. if MemoFielD4 is in use then so are 1, 2, and 3. The Note field in this
table has a number which is used to draw attention to a particular memo
field; if Note is 2 then MemoField2 should be the only memo field selected,
if Note is 23 then MemoField23 should be selected - later to be used in a
form and report. How can I have a query that displays only the memo field
marked by Note?
BAD DESIGN. You really should have a memo table with three (or more fields)
ID (reference to the pr...Search one folder only in OL2007
Using OL2007, how can one search the contents of one folder only? For
instance, when I search for something, OL looks in the Inbox, Junk Mail,
Sent Mail and all other folders on my computer. How can I restrict the
searching to one folder only?
"Blake Kaos" <MGKXLAXBUSTL@spammotel.com> wrote in message
> Using OL2007, how can one search the contents of one folder only? For
> instance, when I search for something, OL looks in the Inbox, Junk Mail,
> Sent Mail and all other folders on my computer. How can I restrict t...Outlook to Lotus notes email
I wouild like to use Outlook to connect to lotus notes email instead
of the lotus client to read and respond to email.
Does this work properly? Do I need anything more than out of the box
outlook to connect?
Powcha <email@example.com> wrote:
> I wouild like to use Outlook to connect to lotus notes email instead
> of the lotus client to read and respond to email.
if you have Outlook 2002, you can use the free-from-Microsoft Lotus Notes
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerosp...At least one recipient is marked as "Do not allow" email
This message pops up when sending an email to someone in the office who is a
CRM user. I presume their is a flag in the system that needs changing but I
cannot find it. I have full access to the CRM options.
Search for the user's email address under contacts and accounts. My bet
is that you will find them there (with the do not email option)
It is advisable not to have users email addresses in anywhere other
than users. We generally recommend creation of second email addresses
for all users for use in contacts if that is required.
> This message pops up ...Corporate Notes
How do you find a ticker symbol for a particular note?
...Unable to open one or more attachments
im hoping someone can help me, im running exchange 5.5 sp3
on Nt4 sp6 and clients are having problems when using
outlook (97,98,2000 and XP) when trying to open emails
when they are actually opening the email that has an
attachment, (not the attachment itself) outlook is
reporting a "unable to open one or more attachments" and
the body of the message appears but it doesnt seem to have
the attachment there, if they then proceed to close and
open the email a few times, the attachment appears without
the error message.
This is happening at different s...How do I transfer all Windows Live Mail & file to my new XP machin
On the old WinXP machine, WLM runs well with familiar folders, accounts,
messages, and contacts. I don't want to have to set up the folders and
accounts and "export" and "import".
How do i transfer all of this to my new WinXP machine?
...Transferring Addresses in Outlook
My old computer has Win 98. My new computer has XP Home
Edition. I am trying to transfer the Outlook address
book from my old computer to the new one. I used the
Export function and saved the address book as a .csv
file. When I sent the e-mail to my new computer,
however, I got the following error message from Outlook:
"OE removed access to the following unsafe attachments in
your mail: address book.csv"
HELP! What am I doing wrong?
...N00b Ques? 2 flyers one page
Hello people i would like to print 2 flyers on one piece of a4 paper. I
would then like to cut a4 paper (once in the middle) with a guillotine. The
problem im facing is that i can never get spacing between the flyers the
same as the spacing between the flyer and the edge of paper. I have gone to
file_>page setup_>change copies per sheet and fiddled with the gaps , but i
can never get the spacing right?
Is there an easier way to do this??? Does anyone know of a template ?
Landscape or portrait?
If you type 14.8cm in height for portrait, or vice versa for landscape, you
shouldn...TRANSFER OUT TO TRANSFER OUT
I HAVE BEEN WORKING WITH RMS FOR OVER A YEAR AND HAVE NEVER SEEN THIS
STORE A MAKES A TRANSFER OUT AND STORE B RECEIVES A COMPUTER TRANSFER IN THE
TRANSFER OUT WINDOW INSTEAD OF A TRANSFER IN. IN ADDITION TO THAT THE
TRANSFER HAS BEEN CLOSED AT STORE B'S END AUTOMITICALLY AND IT IS EMPTY.
AN KNOWLEDGE AS TO WHY THIS HAPPENS
Check HQ Client for errors, or from HQ Manager, view the event log for that
store. You'll probably find some errors at Store B on the 401 that created
I would guess that Store A used a transfer number with more than 14
c...Finding Duplicates and somehow flagging them in another column
I have a friend who needs to find duplicates in an Excel spreadsheet. She
then needs the duplicates to me marked some way to show they are a
duplicate...like putting a checkmark for that item in a separate column.
Any advice or help is greatly appreciated.
See www.cpearson.com/excel/duplicat.htm for some examples.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"KenRamoska" <KenRamoska@discussions.microsoft.com> wrote in
>...hierarchy in one table
I have a single table that has an employee and the manager they report to.
This table consists of all employees regardless of management level. Since I
have this table with the employee/manager relationship. How can I query to
show me the hierarchy of a high level manager. For example a GM has four
directors who each have two managers and the managers have 6 employees.
Iwould like to get a query that shows that this GM has a total of 48 persons
My guess is that you are going to need to write a recursive function that
you pass the EmployerID to.
In that fun...Data Validation does not work when selecting another cell.
I have a cell with data validation rules set. When an invalid entry is typed
in and the Enter key pressed, the rules work fine and reject the entry.
However, if an invalid entry is typed in and the another cell is selected
with the mouse (without pressing Enter), the invalid data is accepted in the
cell. Is there any way of stopping this ?
It worked for me when I tried it.
You may want to post more details or try it again.
Simon Jefford wrote:
> I have a cell with data validation rules set. When an invalid entry is typed
> in and the Enter key pressed, the rules...Transfer quote using eConnect?
It does not look like eConnect supports transferrring a quote to an order.
Can I read in the quote information from GP and then use it to create an
order then? Is this a big no no?
Is this a quote in GP that you want to transfer to an order in GP? What
message do you get when you try the Transfer process? We need more
information to understand why you are using eConnect.
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"Susan" ...AS400 transfer diredtly to xl sheet
I use the addin to transfer records directly to a worksheet.
Is there anyway to automate this procedure?
Currently my macros will set up a sheet and advise the user of the directory where the DTF is
I'd rather have this as an automatic procedure i.e.. upon calling the routine for the download
have the DTF execute automatically.
I've tried creating a BAT file but the output is display only vs. loading direct to the sheet.
In Excel I do this all the time, but never use a macro to get the data. I
simply get the data from Excel using Data>Import...Can I install Office 97 on my new windows xp computer?
I had Microsoft Office 97 on my old computer operating on Windows 95. My new
computer has Microsoft Works and uses Windows XP. It will not read my Office
97 Excel files from my old computer. I have the Office 97 cd. Can i install
this on my new computer with Windows XP?
In article <569D8416-360C-4DBB-82A6-D1090EB53395@microsoft.com>,
"whitedog" <firstname.lastname@example.org> wrote:
> I had Microsoft Office 97 on my old computer operating on Windows 95. My new
> computer has Microsoft Works and uses Windows XP. It will not read my Office
> 97 E...Transferring Data in Excel...
I need to be able to link data from one workbook to another. Example, if workbook1 enters in several cells of data that data automatically transfers over to whichever workbook is specified (i.e. workbook2 or workbook3).
Please let me know if you have any suggestions.
Customer wanted to do an Inventory transfer from Site 1 to Site 2 and have it
have a new unit cost at Site 2 that not only includes the original cost of
the Site 1 in assembly but also adds the shipping charges as well to the cost
in Site 2.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree"...One liner challenge
Well at least it's a challenge for me :-)
What is an elegant way of referring to the first string item delimited by=
a space without
assigning to a string array variable as a separate step?
Normally you could do...
dim strArray() as string
MyStr =3D "1 2 3"
strArray =3D Split(MyStr)
Debug.Print Split(MyStr,,1) 'return one sub string parameter naturally =
Why am I doing this?
MyStr is already used in a complicated IIF statement but I only want the =
first item in the
While some may say that readabi...transferring e-mail addressess from Outlook
I do not know how to get my e-mail addresses from Outlook. It says on your
site that they should be transferred over to this acct. HELP
What site might you be referring too..?
This newsgroup is for Vista's email client Windows Mail. It is a public forum of your peers(users like yourself)....it is not
The most common method for transferring one's contacts from Outlook to another email client is to use Outlook's built-in capability
to export the contacts list as a Comma Separated Value file[ *.csv file(Windows format)] and save the fi...Laptop clients work one day and not the next.
Help! We have about 10 users on the CRM 3.0 with Update 1 on the server. All
laptop clients are CRM 3VC Client. The problem happens to the same users over
and over. One day CRM works without a hitch. They all have new machines as of
last week. The same folks who had issues on their old machines have issues on
their new machines. I have repaired the server installation and checked the
server logs and machine logs. Nothing stands out. No errors on the network
cards for server or machine. Usually the fix is to close Outlook and exit the
CRM Hoster Application. Then fire up Outlook. Then so...One Pop Account
We have a client that is part of a franchise group, they
only have 1 pop account issued from head office for their
site of 20 people.
The owner wants to see all the e-mails that come in to
keep on top of the business as it is a sales environment.
How can i make it so that all sales staff have to send
the e-mail to a receptionist who can send smtp mail with
the reply address of email@example.com and then also
have the outgoing e-mails sent to the owner to monitor
They have SBS 2003 and only the 1 pop e-mail address held
at head office.