We've created a report that is intended to be delivered as a CSV file. This
report contains contact information that users will import into Outlook. We
would like this to be as seamless as possible. We are running into issues
with importing email addresses. By default, Outlook expects the column in
the CSV file to be named "E-mail". When SRS exports my table, it ignores
the column headers and instead uses the textbox names for the first row of
the CSV. SRS will not allow us to the textbox "E-mail".

We cannot turn off column headers on the server. We have too many other CSV
exports working just fine, unless there is a way to turn it off for a single
report. We really perfer the users don't have to do a custom mapping when
they import the file.

Does anyone have any sugesstions on how to either get SRS 2005 to export a
column named "E-mail" or what other label we can use that Outlook would use
to automatically map our column to the "E-mail" field? We've tried a few
varition of Email to no avail.

SRS 2005 SP2
Outlook 2003 and greater

Any help would be appreciated

- Chris

All else aside, the correct field names to just import the email address
only for the purposes of auto-mapping would be one of the following:

1) E-mail Address (for most people - this would be the one to use)
2) E-mail 2 Address
3) E-mail 3 Address

The field name E-mail fields represents the corresponding combined fields
and shouldn't be the field name to be used in any case - (as can be seen by
expanding the E-mail field by clicking on the plus sign when viewing the
Outlook field map in the import wizard)

E-mail Address
E-mail Type
E-Mail Display Name

Importing an invalid "E-mail Type" will cause you problems and really
shouldn't be done unless you know exactly why you are doing it. Importing a
valid POP3 email address will result in the "E-mail Type" field being
automatically populated with "SMTP" (unless of course it gets resolved to an
Exch email address in which case the result will generally be "EX")

Karl
__________________________________________________ _
Karl Timmermans - The Claxton Group
ContactGenie - Importer 1.3 / DataPorter 2.0 / Exporter
"Power contact importers/exporters for MS Outlook '2000/2007"
http://www.contactgenie.com



"Chris Walls" wrote in message
...
We've created a report that is intended to be delivered as a CSV file.
This report contains contact information that users will import into
Outlook. We would like this to be as seamless as possible. We are
running into issues with importing email addresses. By default, Outlook
expects the column in the CSV file to be named "E-mail". When SRS exports
my table, it ignores the column headers and instead uses the textbox names
for the first row of the CSV. SRS will not allow us to the textbox
"E-mail".

We cannot turn off column headers on the server. We have too many other
CSV exports working just fine, unless there is a way to turn it off for a
single report. We really perfer the users don't have to do a custom
mapping when they import the file.

Does anyone have any sugesstions on how to either get SRS 2005 to export a
column named "E-mail" or what other label we can use that Outlook would
use to automatically map our column to the "E-mail" field? We've tried a
few varition of Email to no avail.

SRS 2005 SP2
Outlook 2003 and greater

Any help would be appreciated

- Chris

Just pinging this to keep the post alive.

"Chris Walls" wrote in message
...
We've created a report that is intended to be delivered as a CSV file.
This report contains contact information that users will import into
Outlook. We would like this to be as seamless as possible. We are
running into issues with importing email addresses. By default, Outlook
expects the column in the CSV file to be named "E-mail". When SRS exports
my table, it ignores the column headers and instead uses the textbox names
for the first row of the CSV. SRS will not allow us to the textbox
"E-mail".

We cannot turn off column headers on the server. We have too many other
CSV exports working just fine, unless there is a way to turn it off for a
single report. We really perfer the users don't have to do a custom
mapping when they import the file.

Does anyone have any sugesstions on how to either get SRS 2005 to export a
column named "E-mail" or what other label we can use that Outlook would
use to automatically map our column to the "E-mail" field? We've tried a
few varition of Email to no avail.

SRS 2005 SP2
Outlook 2003 and greater

Any help would be appreciated

- Chris