What's the best way to copy email addresses from Outlook to Smartsheet?

Hello, this is my first question so I apologize if it's not formatted correctly.

For months I have been able to copy email addresses directly from my "To" fields within outlook to Smartsheet when trying to share a sheet. However, in the last ~month I've been unable to do it.

Smartsheet now breaks the first and last names into separate entries and says that they do not have a valid email address.

When I paste the email addresses into word to verify format I see: John Doe<john.doe@email.com>; Jane Doe<jane.doe@email.com>

To me, it seems like the formatting is correct, so it seems to be the way that Smartsheet is interpreting this information when pasting it in.

Any help you're able to provide is appreciated!

Thanks!

Find more posts tagged with

email address confirmation

Accepted answers

All comments

Eric_

Hi!

The same happened to me. I now use the email address alone, not "name <xxx>". Indeed not the best solution as you need to extract it first from outlook.

David Sv

https://community.smartsheet.com/discussion/comment/426372#Comment_426372

What is the best way you've found to extract from outlook? And, when you use just a list of emails, does it pull in the names into your projects for task assignments?

Hopefully someone from Smartsheet (or another user) has another way that maybe we're missing haha.

Eric_

Fortunately, I don't have to do this too often and with a lot of email adresses. Recently, when I had to authorize around 20 people, I entered all people in a dummy email, then I copied/paste the adresses from the To: field to Excel, then with a few keystrokes, I was able to get only email adresses. If you do this often, building a simple macro would probably help. However, as you do, I keep wondering if I'm not missing something obvious!

jrprehn

Has anyone found a better solution for this issue? This seems like such an obvious use of smartsheet… And I know it used to work properly but I still can't get it to work with the latest upgrades. All I want to do is go directly between outlook and smartsheet… If I have to build other columns or things to get the info into a contact list I need to know how to do that… I haven't been able to make it work smoothly. Then I want to be able to sort my data and copy the cells for an email group and paste back into outlook… All the data is there in Smartsheet… but it won't export the information correctly. sigh…

David Sv

I haven't found a better solution at this point - it's still all manual work instead of what we used to be able to do.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.