|
|
I imported my Access data base that contains my "mailing list" into Outlook
contacts. Now, when change my "current view" of contacts (in Outlook), some
of the views show some of the info & some do not. Address Cards: No header
info, so I have lots of phone #'s - I just do not know who they belong to.
Detailed Address cards show me names, phone #s & the "notes" portion of my
Access data table (NO "detailed ADDRESS") Phone List appears to be OK.
Category, Company, Location & follow up flag all seem to be OK ( I have no
categories or companies set up.)
It appears as if the only address that shows up on the Address Card view is
my own (it is in a gray ?header? field.) It also shows my e mail address.
Does not show my name at all. When I double click my address header to open
the contact, with "full info" , my name appears, but shows I have no email
address.
|
|
The data in BCM after an import from Access is going to depend on two
factors.
(1) How the Access table's columns were mapped to BCM's fields.
(2) The data in the Access table's columns.
For example, if in the Access table you have a column named "email"
and you map that to BCM's "Email1Address", then after importing into
BCM, all the rows in the Access table should have created a new BCM
Contact. Where the row had data in the email column, the corresponding
Contact will have that data in the Email1Address field.
If you don't have header info, then either no Access column was mapped
to a BCM name field, or the Access column does not have data.
The only time I've run into a single imported record getting split
into two BCM Contacts, with some columns in one Contact and the rest
in the other, is when importing from CSV files. CSV files are expected
to have one line per record, and when some programs export to CSV,
they don't strip the newline characters from the data, so a single
database records gets written as several lines in the CSV file.
On Jan 26, 6:52 pm, Caryl <C...[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > I imported my Access data base that contains my "mailing list" into Outlook
> contacts. Now, when change my "current view" of contacts (in Outlook), some
> of the views show some of the info & some do not. Address Cards: No header
> info, so I have lots of phone #'s - I just do not know who they belong to.
> Detailed Address cards show me names, phone #s & the "notes" portion of my
> Access data table (NO "detailed ADDRESS") Phone List appears to be OK.
> Category, Company, Location & follow up flag all seem to be OK ( I have no
> categories or companies set up.)
> It appears as if the only address that shows up on the Address Card view is
> my own (it is in a gray ?header? field.) It also shows my e mail address.
> Does not show my name at all. When I double click my address header to open
> the contact, with "full info" , my name appears, but shows I have no email
> address.
|
|
My reply above assumes you were importing in BCM Contacts. If instead
you were really importing into "Outlook Contacts"--I just noticed that
rereading your post--then you should ask the microsoft.public.outlook
newsgroup. This is the BCM newsgroup.
On Jan 27, 8:44 am, "Luther" <enown...[ at ]gmail.com> wrote:
[Quoted Text] > The data in BCM after an import from Access is going to depend on two
> factors.
>
> (1) How the Access table's columns were mapped to BCM's fields.
>
> (2) The data in the Access table's columns.
>
> For example, if in the Access table you have a column named "email"
> and you map that to BCM's "Email1Address", then after importing into
> BCM, all the rows in the Access table should have created a new BCM
> Contact. Where the row had data in the email column, the corresponding
> Contact will have that data in the Email1Address field.
>
> If you don't have header info, then either no Access column was mapped
> to a BCM name field, or the Access column does not have data.
>
> The only time I've run into a single imported record getting split
> into two BCM Contacts, with some columns in one Contact and the rest
> in the other, is when importing from CSV files. CSV files are expected
> to have one line per record, and when some programs export to CSV,
> they don't strip the newline characters from the data, so a single
> database records gets written as several lines in the CSV file.
>
> On Jan 26, 6:52 pm, Caryl <C...[ at ]discussions.microsoft.com> wrote:
>
>
>
> > I imported my Access data base that contains my "mailing list" into Outlook
> > contacts. Now, when change my "current view" of contacts (in Outlook), some
> > of the views show some of the info & some do not. Address Cards: No header
> > info, so I have lots of phone #'s - I just do not know who they belong to.
> > Detailed Address cards show me names, phone #s & the "notes" portion of my
> > Access data table (NO "detailed ADDRESS") Phone List appears to be OK.
> > Category, Company, Location & follow up flag all seem to be OK ( I have no
> > categories or companies set up.)
> > It appears as if the only address that shows up on the Address Card view is
> > my own (it is in a gray ?header? field.) It also shows my e mail address.
> > Does not show my name at all. When I double click my address header to open
> > the contact, with "full info" , my name appears, but shows I have no email
> > address.- Hide quoted text -- Show quoted text -
|
|
Luther - Thanks for the replies! You were right the 2nd time. I clicked on
the wrong heading. Meant to post question to Outlook Contacts. Is posted
there now & am waiting for reply. Actually, your reply is helpful -
probably a mapping thing! I'm going to retry the import after I delete the
current contacts. I'll let you know how I make out. Also, just curious -
Business Contact Mgr- does it mainly just have more fields avail than the
Outlook Contacts? Or does it have lots more bells & whistles? Any advantage
for me to use BCM?
"Luther" wrote:
[Quoted Text] > My reply above assumes you were importing in BCM Contacts. If instead
> you were really importing into "Outlook Contacts"--I just noticed that
> rereading your post--then you should ask the microsoft.public.outlook
> newsgroup. This is the BCM newsgroup.
>
> On Jan 27, 8:44 am, "Luther" <enown...[ at ]gmail.com> wrote:
> > The data in BCM after an import from Access is going to depend on two
> > factors.
> >
> > (1) How the Access table's columns were mapped to BCM's fields.
> >
> > (2) The data in the Access table's columns.
> >
> > For example, if in the Access table you have a column named "email"
> > and you map that to BCM's "Email1Address", then after importing into
> > BCM, all the rows in the Access table should have created a new BCM
> > Contact. Where the row had data in the email column, the corresponding
> > Contact will have that data in the Email1Address field.
> >
> > If you don't have header info, then either no Access column was mapped
> > to a BCM name field, or the Access column does not have data.
> >
> > The only time I've run into a single imported record getting split
> > into two BCM Contacts, with some columns in one Contact and the rest
> > in the other, is when importing from CSV files. CSV files are expected
> > to have one line per record, and when some programs export to CSV,
> > they don't strip the newline characters from the data, so a single
> > database records gets written as several lines in the CSV file.
> >
> > On Jan 26, 6:52 pm, Caryl <C...[ at ]discussions.microsoft.com> wrote:
> >
> >
> >
> > > I imported my Access data base that contains my "mailing list" into Outlook
> > > contacts. Now, when change my "current view" of contacts (in Outlook), some
> > > of the views show some of the info & some do not. Address Cards: No header
> > > info, so I have lots of phone #'s - I just do not know who they belong to.
> > > Detailed Address cards show me names, phone #s & the "notes" portion of my
> > > Access data table (NO "detailed ADDRESS") Phone List appears to be OK.
> > > Category, Company, Location & follow up flag all seem to be OK ( I have no
> > > categories or companies set up.)
> > > It appears as if the only address that shows up on the Address Card view is
> > > my own (it is in a gray ?header? field.) It also shows my e mail address.
> > > Does not show my name at all. When I double click my address header to open
> > > the contact, with "full info" , my name appears, but shows I have no email
> > > address.- Hide quoted text -- Show quoted text -
>
>
|
|
On Feb 1, 7:04 pm, Caryl <C...[ at ]discussions.microsoft.com> wrote:
[Quoted Text] > Luther - Thanks for the replies! You were right the 2nd time. I clicked on
> the wrong heading. Meant to post question to Outlook Contacts. Is posted
> there now & am waiting for reply. Actually, your reply is helpful -
> probably a mapping thing! I'm going to retry the import after I delete the
> current contacts. I'll let you know how I make out. Also, just curious -
> Business Contact Mgr- does it mainly just have more fields avail than the
> Outlook Contacts? Or does it have lots more bells & whistles? Any advantage
> for me to use BCM?
>
>
>
> "Luther" wrote:
> > My reply above assumes you were importing in BCM Contacts. If instead
> > you were really importing into "Outlook Contacts"--I just noticed that
> > rereading your post--then you should ask the microsoft.public.outlook
> > newsgroup. This is the BCM newsgroup.
>
> > On Jan 27, 8:44 am, "Luther" <enown...[ at ]gmail.com> wrote:
> > > The data in BCM after an import from Access is going to depend on two
> > > factors.
>
> > > (1) How the Access table's columns were mapped to BCM's fields.
>
> > > (2) The data in the Access table's columns.
>
> > > For example, if in the Access table you have a column named "email"
> > > and you map that to BCM's "Email1Address", then after importing into
> > > BCM, all the rows in the Access table should have created a new BCM
> > > Contact. Where the row had data in the email column, the corresponding
> > > Contact will have that data in the Email1Address field.
>
> > > If you don't have header info, then either no Access column was mapped
> > > to a BCM name field, or the Access column does not have data.
>
> > > The only time I've run into a single imported record getting split
> > > into two BCM Contacts, with some columns in one Contact and the rest
> > > in the other, is when importing from CSV files. CSV files are expected
> > > to have one line per record, and when some programs export to CSV,
> > > they don't strip the newline characters from the data, so a single
> > > database records gets written as several lines in the CSV file.
>
> > > On Jan 26, 6:52 pm, Caryl <C...[ at ]discussions.microsoft.com> wrote:
>
> > > > I imported my Access data base that contains my "mailing list" into Outlook
> > > > contacts. Now, when change my "current view" of contacts (in Outlook), some
> > > > of the views show some of the info & some do not. Address Cards: No header
> > > > info, so I have lots of phone #'s - I just do not know who they belong to.
> > > > Detailed Address cards show me names, phone #s & the "notes" portion of my
> > > > Access data table (NO "detailed ADDRESS") Phone List appears to be OK.
> > > > Category, Company, Location & follow up flag all seem to be OK ( I have no
> > > > categories or companies set up.)
> > > > It appears as if the only address that shows up on the Address Card view is
> > > > my own (it is in a gray ?header? field.) It also shows my e mail address.
> > > > Does not show my name at all. When I double click my address header to open
> > > > the contact, with "full info" , my name appears, but shows I have no email
> > > > address.- Hide quoted text -- Show quoted text -- Hide quoted text -
>
> - Show quoted text -
BCM has several features, and different audiences appreciate different
aspects of it. I like being able to look at a Business Contact and
seeing a history of all the emails with that Contact. Many sales
people like being able to track opportunities. If you have Microsoft
Accounting and have integrated with BCM, it's helpful to open a
Contact in BCM and see the financial history right there; without
having to start a separate accounting app.
|
|
|