send the same e-mail with one or two fields changed.......
I would like to send the same e-mail to many differnet people with
one or two fields changed (for example the name of recipient and the
date).How canthis be done?? I would also like to be able to save the
e-mail and use it again and again.
can anyone help
If you have Word installed and it's the same version as Outlook (both 2003,
for example), you can do a mail merge between the two. This would allow you
to set up the text the way you want it to, and you can save the document for
future use. Look at the following page for further information:
http://www.slipstick.com/con...Ugly lines between emails in viewing pane
Operating System: Mac OS X 10.4 (Tiger)
Email Client: pop
I have Outlook at work and you can turn these lines off but I cant find anywhere to turn these off in Entourage 2008. They weren't there in Entourage 2004. Is there anyway of turning these off to get a clean view? I've looked in preferences and customising only seems to extend to choice of columns. Andrea
> I have Outlook at work and you can turn these lines off but I cant
> find anywhere to turn these off in Entourage 2008. They weren't the...Tracking shared records
I need to create a report that shows which records are shared and with whom.
Can someone guide me in the right direction? I can't seem to find it anywhere
online. thank you
Sharing is recorded in the PrincipalObjectAccess table in the SQL database.
Advanced find does not allow you to access this so you will have to create a
report on the directly on the database.
Patrick Verbeeten (MCPD)
Extended Entity and Plug-in browser:
> I need to create a report that shows whi...if cell is text move left one column
ColB is a long list with sections names followed by category codes
I need to move the text into colA leaving colB with codes only (all numbers)
Dim lngRow As Long
For lngRow = 1 To Cells(Rows.Count, "B").End(xlUp).Row
If Not IsNumeric(Range("B" & lngRow)) Then
Range("A" & lngRow).Value = Range("B" & lngRow).Text
Range("B" & lngRow).Value = ""
...Showing 0 after decimal with ROUND
I'm using the ROUND function like this:
=ROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
Unfortunately, if the numeral after the decimal is a 0, then it doesn't
display. How can I force a 0 to display after the decimal?
Format the cell as Number with 1 decimal place - it would appear to be
formatted as General.
Hope this helps.
On Dec 4, 1:44=A0pm, Libby <Li...@discussions.microsoft.com> wrote:
> I'm using the ROUND function like this:
> =3DROUND(C29*(92%),1) &- ROUND(C29*(108%),1)
> Unfortuna...100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
• B21:M21 - contain the names of the months from Nov – Oct
• B22:M22 - money taken in
• B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I don’t need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show in...Formatting a subtotal line with a macro
I already have in use a macro that runs a sort and subtutal function. I
would like to format the subtotal row using visual basic since there is
already a macro in place.
Look at this:
ActiveCell.Font.Bold = True
"DJDKAL" <firstname.lastname@example.org> skrev i meddelelsen
>I already have in use a macro that runs a sort and subtutal function. I
> would like to format the subtotal row using visual basic since there is
> already a macro in place.
This is what I've g...Reporting IRA distributions
I have an IRA account with corresponding cash account. I
am trying to get the distribution from the IRA to show up
as "Retirement Income" in the Tax-Related Transactions
report. How to do it?
The distributions are handled as a transfer from the IRA
Investment cash acct to a checking account.
Thanks for any help. Money 99, BTW. Do I need to
upgrade to a later version?
...publisher. why does webpage preview show only half page
When I'm viewing my webpage design in webpage preview I am getting a large
empty space on the right hand side and bottom of the page
On Fri, 17 Feb 2006 17:50:02 +0000, yousane wrote
(in article <65E39911-B9CA-4785-BD48-358D03F3695A@microsoft.com>):
> When I'm viewing my webpage design in webpage preview I am getting a large
> empty space on the right hand side and bottom of the page
And your problem is...? That's how it's supposed to be. Web pages designed in
Publisher do *NOT* fill the entire screen. I suggest you learn to use the
right tool for the job (I&...Multiple domains on one Exchange server / All but one domain shows up as spam #2
I am sorry if this is on the board somewhere but I have been searching
forever and havn't found a hint yet.
I have multiple domains setup on my exchange server. Lets say abc.com,
def.com, and hij.com. We only send email with @abc.com but can receive
from any domain name. Recently we merged with another company and we
brought back their email to our server, lets say xyz.com. Now I
configured a new recipient on Exchange 2003, so I now have two
policies. The first policy has the three original domains in it with
@abc.com as the primary domain. In the second policy I have configured
xyz.com t...Duplicate record in RM tables
We experienced an issue in Apply Sales Document that may have caused a
duplicate record somewhere. We found this when running Paid Sales
Transaction Removal and received this message:
Violation of PRIMARY KEY contraint PKRM3101. Cannot insert duplicate key in
I ran the RM duplicate tool found in the automated help area of this website
and found the following:
--- Begin copy here ----
Duplicates between RM Open and RM History
Document #: 07-003021-17 Customer #: 079100 RMDTYPAL #: 7
--- End copy ---
It looks like the duplicte tool also logs the qu...How to track ActiveControl.Name when switching records in form with multiple subforms
I need to have a global variable always contain the name of the
current form field. This bit of code is attached to the GotFocus
event of all fields and the Enter event of all subforms:
gxCurrentField = Me.ActiveControl.Name
However it doesn't work properly when changing records in a subform.
My parent form contains two subforms in a many-to-many relationship.
The above variable usually ends up containing the name of the first
field in the second subform when switching records in the first
How to correctly code this? Or is there some native variable I'm not
aware of? I...Excel Grid Lines in Outlook Preview Pane
Is there any way to send a spreadsheet to a mail recipient in the body
of the message and not have the grid lines show up in the Outlook
preview pane when the recipient views the e-mail? If you open the
e-mail in Outlook, the grid lines disappear, but in the preview pane
they are there.
Using Excel and Outlook 2003.
Uzytkownik "Kimberly" <Blackrose73@gmail.com> napisal w wiadomosci
> Is there any way to send a spreadsheet to a mail recipient in the body
> of the message and not have the grid lines show up ...line chart with NA() values
12 month line chart, with some values being 0.
I am using an if statement that turns any 0 values to #N/A so they do
not show on the graph (which is what I want).
My problem arises when the 0 values fall in the middle of my data.
So for example:
1) data for all months (Jan-Dec), the line shows across all 12
2) I have data for only 6 months (Jul-Dec), the line starts in Jul and
ends in Dec (perfect);
3) When I have data from Jan-Mar, and Oct-Dec, the line connects
between Mar and Oct. I want 2 distinct lines with no line where there
is no data (#N/A).
gri...Does any one know of a template for purchases, business card siz
I would like to be able to have a business card size card that I can punch
the amount of purchase for my customers. After they make a certain amount of
purchases I would collect them and they would receive a discount on their
next purchase or a free item.
On Sun, 7 Mar 2010 15:54:01 -0800, captured memories <captured
>I would like to be able to have a business card size card that I can punch
>the amount of purchase for my customers. After they make a certain amount of
>purchases I would collect them and they would rece...Exchange server crashed, please help....! Need to restore two priv.edb and pub.edb files into one....!
I was wondering if I could get some help with the following problem we are
having on our company.
Here is the scenario; Our Windows NT 4.0 SP4a server running Exchange 5.5
SP4 crashed (Server 1) due to the exchange database reaching its 16 Gig's
max limit. I went ahead and moved some mailboxes' e-mails to a few .pst
files in order to make some space. This worked ok. Then, I decided to build
another exchange server (Server 2) to moved some mailboxes and alleviate the
load. Once the server was ready and configured as part of the current
exchange site, I went ahead and move...Report Can Grow not aligned horizontally
I have a report where I have 1 row of text, memo, number, and date fields.
The memo field can contain up to 4-5 lines of wrapped text. I have set all
teh rows to "can grow". However, on my report, the conditional formatting
For instance, the fill (which I have set to a gray color) in the memo field
is about 3 lines deep when there is a lot of text in the memo field, but the
text and number fields associated with that record are actually only 1 line.
This essentially looks like a mess, small gray filled boxes for the text
fields and a large gray ...Custom reports #3
I want to pull a report on how many customers I am getting
every hour of the day. Does anyone out there know how to
do that? I can try writing a query if someone can tell me
which table I can find this information in (timestamp,
transaction etc). Any help is appreciated.
This info is given at the end of the Z report.
If you want to use it in a query open the Z report
recipt file using the Notepad and see the fields that
are used... Report.Hour.HourSales etc...
Hope this helps...
> I want to pull a report on how many cust...when opening an excel file, 2 files open (one is book1)?
When I click on an excel file, 2 excel documents open up. One document is
called Book1 and the other document is the actual document that I want to
open. How do I stop this from happening?
To prevent Book1 from opening you can append /e to your shortcut for opening
"C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\EXCEL.EXE" /e
Alternative to the above............
Go to Start>Settings>Folder>Options>File Types. Scroll down to MS Excel
Worksheet. Then if running Win98 OS Edit> select "Open" and Edit.
If using WinXP OS you would scroll down to...how to run onhand value report
I get the message enter parameter when entering the zoom feature
On Sat, 6 Mar 2010 17:36:01 -0800, junebugg
>I get the message enter parameter when entering the zoom feature
You'll have to give us some more context than that, junebugg. What's the
"onhand value report"? What's the "zoom feature"?
You can see your database; we cannot!
John W. Vinson [MVP]
...Duplicating one Field from One table to Another
I have two tables - one position, one personnel - which has a 1-to-many
relationship (1 position record to many personnel records). The department
had a new requirement which made it necessary to change some coding (I
inherited this). I'm using tab forms so that when a position is pulled up,
you can click on the tab that has the personnel information (if there is
any). There is a button on the Personnel form that allows the user to add a
new Personnel record. Since I am using an Auto-number field in the Position
table (which doubles as the PK) the functionality is fine. Wh...mysession & deleting a line item on the pos screen
I want to automatically have my dll delete a line on the pos screen. So I
have tried to do a myssion.transaction.entries(1).Delete and other sorts of
things. Does anyone know of a way to accomplish this?
Thanks in advance for any help on this.
Use code like this:
For Each item In mysession.Transaction.entries
If FindItem(item.item.id, item.quantity, item.item.description) Then
> I want to automatically have my dll delete a line on the pos screen. ...Excel 2007 Line Chart
Is it possible to configure a line chart in Excel 2007 to ignore the
intervals and graph straight to the next value. For example if I have
Jan with the value 1000
Feb with the value 900
March with the value 500
April with the value 0
May with the value 0
June with the value 0
I want the March value to drop directly from 500 to 0 ignoring the
interval to April, I do not want a curved line it must drop directly
to zero then the line is straight across to April.
I have no idea if this is possible, any ideas?
On Tue, 11 Oct 2011 15:40:45 -0700 (PDT), TyreDu...Items for review wont show up
I am using MS Money 2004 Small Business. My checking account balance is
downloaded each day from my bank. For the last couple days, it continues to
download transactions, and tells me that there are now 8 items to review,
but when I open up the account, nothing is bold faced to review. On the
pane to the left, it still lists 8 items to review. I even went to the bank
website and downloaded in the most recent transactions, but this only made
the list of items to review larger. I still can't accept any of them. I
have tried a quick repair. I also tried restoring the back up, bu...referencing lines and series points
what is the VBA code for referencing to individual points in a line on
line graph? i would like to create a macro to change indiviual points
shapes and the color or the lines in between them to different color
depending on different parameters. is this possible
medicenpringles's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1645
View this thread: http://www.excelforum.com/showthread.php?threadid=39101
Ther easiest way to do this is to first record a macro doing what y...