Creating CSV for Outlook: E-mail

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Walls - 31 Jan 2008 21:38 GMT

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

Reply to this Message

Karl Timmermans - 31 Jan 2008 22:03 GMT

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

> 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
[quoted text clipped - 21 lines]
>
> - Chris

Reply to this Message

Chris Walls - 07 Feb 2008 14:09 GMT

Just pinging this to keep the post alive.

> 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
[quoted text clipped - 21 lines]
>
> - Chris

Reply to this Message