Seeking advice on how to print a price list
I am trying to produce a price list from a large Excel spreadsheet -
it comes down to roughly 10000 items on three columns - I'd do it in
Excel but want to get three columns to the page but don't want to
manually format each page (the previous version was in this format and
took roughly 60 pages of text)
Copying and pasting into Word crashes Word while I've not been able to
effectively figure out mail merge to create what I'd like.
I'm using Office 2003 but do not believe there's any way to get Excel
to print multi-column as I'd like to. Therefore I think I'm ...list box #5
I have created an in-cell drop down box that works perfectly, except that it
shows blank until you scroll to the top of the list. Is there a way that it
would show the first option in the list, rather than start at the end?
Are you sure you don't have some blank cells selected in your vaildation?
If the cell with the data validation list is blank, and there is a blank
cell at the end of the source range, that's what will be selected when
the list is opened.
If you're leaving blanks so the list can grow, you can use a dynamic
name for the range instead. There are instructi...How to get a list of opened MDI child windows in MDI main frame?
To active a speciffic child frame by calling
void CMDIFrameWnd::MDIActivate( CWnd* pWndActivate );
However, how do I get the pointer of the child frame? Should I create an
array variable to keep these pointers? Or there will be more better way?
CDocument has member functions which you can interate through different
views. Here's an example.
POSITION pos = GetFirstViewPosition();
CView* pView = GetNextView(pos);
// do something with pView
Check the help file for more information on these two functions in
&q...Smart List Export to Excel
When I export smart list data to an Excel Spreadsheet, I cannot use the month
function on date fields. They look like dates, and have serial numbers like
dates, but the function returns 01-04-1900 instead of the month. Is this an
Excel issue or an issue with date fromatting from samrt lists?
What versions of GP and Excel? I just tried it on my GP 9.0 SP 2 and Excel
2007 - dumped a bunch of Account Transaction lines to Excel, and the MONTH
function worked correctly......
Dynamics GP MVP
Flexible Solutions, Inc.
"Bob Gunderson" &l...Recovery of Outlook and Outlook Express addresses and messages 04-25-10
I used Outlook Express and my wife used Outlook on the same computer. I had
to reload Internet Explorer and it erased my Outlook Express. I retrieved
the address book (.WAB) and was able to import it into Outlook to get myself
Subsequently, the computer had a major failure of the CPU and I have moved
that disk drive into a USB external enclosure. I need to recover my wife's
Outlook addresses and those of mine as well but do not know the naming
protocol within Outlook.
I would also like to retrieve the messages left back in Outlook Express and
those in the tw...Junk mail "Safe list"
I have a serires of junk mail filters that are working quite well...but from
time to time I get an e-mail that I want to read that is deleted. I have
tried to add the the sender's address to the "safe sender" and "safe
dommaine" lists...but this does not seem to work...their mails are still
deleted. What am I doing wrong????
"ajb" <email@example.com> wrote in message
> I have a serires of junk mail filters that are working quite well...but
> time to time I get an e-mail that I want to r...Sorting a list
I need to sort a list by group #. The list consists of 8 colums of info
accross, and so i need to sort left- to right. Not sure how to go about doing
this correctly without losing info!
Select the entire sheet by clicking the grey box above row 1 and to th
left of column A.
Go to 'Data' on the top menu bar.
Check the box for Header row if your data has headers.
Then select, using the drop down arrow, Group # or the correspondin
column with the Group #.
Does this help
-------------------------------------------------------...E-mail to every e-mail address in an Excel column?
Say I have an Excel spreadsheet with one column of e-mail addresses. I want
to send the same piece of e-mail (a WORD file) to each address. Is there an
Try this one with the e-mail addresses in "Sheet1" column C
Visit also my site for more examples
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Dim strto As String
For Each cell In ThisWorkbook.Sheets("Sheet1") _
If cell.Value Like "*@*" Then
st...creating a list from a column of semicolon
I have one column that contains 1000 values. The problem is they do not
occupy one value per one cell with 1000 rows.
Some rows/cells have 10 to 15 values, each separated by a semi colon.
How can I sort or filter the entire column and separate each value into it's
own unique cell in one column?
I would suggest using <data><Text to columns> <delimited with ;>
after doing this I would use <edit><goto><special><last cell> to identify
the highest column with data.
Sequencially Back to column B, I would sort these columns Cut and paste the
How do I create a mailing list in excel? Excel looked like a math thing which
scared the daylights out of me. Up to this point in my career I've been able
to dodge using excel, but my luck has run out. Please help. I need to create
a mailing list and then....and then....do a dreaded mail merge!
Karen, set up name, address, ..... in a diffent column and have a look at
the links below for help on using Word mail merge with Excel as the data
http://www.mvps.org...Integration manager and list pricing
Apologies if this ends up being a double post. Not sure my first post
actually went through.
I am trying to import a selection of inventory items with a list price.
My integration has the List Price pulling from a source field with a valid
dollar amount in it. The LISTPRCE field of table IV00105 is never populated
Does anyone have an idea of what might be wrong and how to fix it?
populate the list price in the currency tab
"Christopher Williams" <Christopher Williams@discussions.microsoft.com>
wrote in message news:C21C1D0C-9219-40A1-8B24-4...Smart list for net invoicing for 2 companys
I'm am trying to get an idea of what can be done with smarlist builder. I
need to create a Smart list report: net invoicing for 2 seperate companies;
also would like to have collumns for us, GBP, and originating currency. Would
this be better done in Smartlist Builder/ FRx/ or somthing like reporting
services or Chrystal?
You can certainly accomplish this in any of the tools you mentioned.
SmartList Builder, in particular, will require you to create a SQL Server
view -- preferrably in the Dynamics database -- that consolidate the
information for all the companies involved. That vi...Create a toolbar button to automatically address an e-mail message
I have tried using MS Outlook help to create a button
which automatically addresses a mail message. I cannot for
the life of me succeed at this because the Help on outlook
is so poor. Has anyone done this or knows how to do this??
All I am trying to do is create an "email template" that
will automatically cc a colleague as they need to be cc on
nearly all of my emails. So if there is an easier way to
do this, that would obviously be better.
...Problem showing memo field in list box
I am using Access 2007 in 2002-2003 mode.
I have a memo field in a linked table tbl_tasks.description. When I
use the Listbox wizard to create a listbox, at the point where the
wizard shows me what fields are available to include in the Listbox,
it does not show me the memo field.
I bypassed that and created the listbox anyway, then modified the
rowsource of the listbox to add in the memo field. When I tried this,
and when I open the form, Access prompts me for the value of
When I search the newsgroups on this general subject, I see that
listboxes generally show a t...Remove mailbox from Everyone distribution list?
I have a mailbox user that I do NOT want to be part of
the "everyone" distribution list. I don't want to make it
a "hidden" mailbox since I do want people to send emails
Any ideas if this is possible?
I'm on Exch 5.5 in a Windows 2000 environment.
"Pablo" <firstname.lastname@example.org> wrote in news:1fdc01c44a45
> I have a mailbox user that I do NOT want to be part of
> the "everyone" distribution list. I don't want to make it
> a "hidden" mailbox since I do want...Using drop down lists to set value for formula
I have a worksheet that I am trying to calculate material prices on.
have the user input Length, Width and calculate SqFeet. I then let th
user choose the material to be sued from a lsit. The lsit is reference
from sheet2. I would like to assign the price to each material fro
sheet2 and when the user selects the material have the price b
multiplied by the SqFeet and displayed in a price field. I have create
the list, I just can't figrue out how to assign dollar values t
choices or use them in a formula.
Any help would be appreciated
+-------------------------------------------------...Hiding Address' in the GAL
How do I hide certain items in the GAL? I want this to be group based
as well so that domain admins see everything but people in the Sales
team only see what I specify.
You will need to setup multiple GALs with custom queries and permissions on
XADM: How to Manage Address Lists When You Host Virtual Organizations
Hope that helps,
This posting is provided "AS IS" with no warranties, and confers no rights.
Please do not send email to this address, post a reply to this newsgroup.
Use of incl...Printing address and email lists in Publisher 2007
I have just purchased this software and have spent about and hour trying to
figure out how to print the address list I created in Publisher in the My
data source file. Does anyone know how to do that? I can't believe something
so simple is this hard.
Select a label, the first one will do, 2.625 X 1 inch, 30 per page. Insert your
fields. In step 3 Merge to a new publication. In print setup select *Multiple
pages per sheet.*
Or simply merge to a plain letter stock sheet using the aforementioned label.
"Sandy" <Sandy@discu...Members of Distribution List visible in GAL
This is probably a stupid question, but I am just not 100% sure. We
have a forest with 5 domains. There is a DL in domain A that a user in
domain B can see, but when they go to view the members from the GAL it
Is this by design or it just a simple rights issue?
thanks for any insight.
>This is probably a stupid question, but I am just not 100% sure. We
>have a forest with 5 domains. There is a DL in domain A that a user in
>domain B can see, but when they go to view the members from the GAL it
>Is this by des...View Marketing list for Campaign Activity
In crm you cannot see the marketing list used on a campaign activity. You
can only see the MLs used for the whole campaign. But crm keeps the relation
in the campaignactivityitem entity which is apparantly a hidden entity in
between campaign activity and marketing list.
Is there a way to visualise that relationship? It would be nice to have a
'Marketing lists' nav item on the left in Campaign activiy. Viewing all the
activities for a ML is not needed.
...Losgt Address Book
All contacts were lost when we upgraded from ME to XP Pro.
Can we locate the contacts which had all our email
You provided no detail that would explain your problem or permit
Please feel free to do so.
All Outlook data is stored in PST files. Search for and open each PST file
you find until you find your data.
<email@example.com> wrote in message
> All contacts were lost when we upgraded from ME to XP Pro.
> Can we locate the contacts which had...Global Address List issue
Recently migrated to Exchange 2003 sp1 from Exchange 5.5. We have a problem
that did not exist before the migration and I am wondering if it's an
Exchange 23K or AD security thing...or what...
Some of our users use Outlook 23K and some use Outlook 2000...both have same
issue - for the people who still use a "personal address book, aka PAB", they
can no longer add members from our Global Address List to a personal dist
list in their PAB. However, they CAN add users from the Global Address List
to a personal dist list in their CONTACTS. Is this by design? We Exchange
Ad...How do I change to a new e-mail address?
I'm having to change my e-mail but I don't know how to change Outlook to
accept when i request a download of new e-mails.
> I'm having to change my e-mail but I don't know how to change Outlook to
> accept when i request a download of new e-mails.
Delete the old defunct e-mail account. Create a new e-mail account. Or
just change the settings in the old account defined in Outlook to match up
with your new account. Follow the unidentified e-mail provider's help on
what are their settings.
make a new account
...Repeat labels in Pivot Tables
Is there a way to get excel to repeat the label on a pivot table so that
there are no blank fields on the report?
No... Apparently in XL2010 that is a new feature but at this point... No
> Is there a way to get excel to repeat the label on a pivot table so that
> there are no blank fields on the report?
Not and keep it a pivottable.
If I don't need the pivottable, I'll convert to values (select the entire PT
range and edit|copy, then edit|Paste special|values).
If I need the pivottable, t...Outlook 2003 Out of office forwarding to SMTP address
I will out of the office for sometime, i know i can use out of office to
forward to another member of my team (internal email), I have tried to
forward the email to my hotmail account, instead of a team member of mine.
But this does not seem to work. Is Outlook 2003 capable of doing this?
Please help asap
It's not Outlook 2003 limiting you in this but the mail server settings. By
(secure) default automatic forwarding to the Internet is disabled on an
Exchange server. To enable;
Robert Sparnaaij [MVP-Outlook]