Import File To Outlook From Excel With Mapping

**jaslake** · 06-10-2010, 10:16 PM

Hi

Some time ago, I found a macro on the web that would import a file from Excel into Outlook. The macro included "mapping code" such that you could map Excel columns to Outlook fields. I had a system crash and lost that code. I believe it ran from Outlook and not Excel.

Do any of you have an idea if that type of code is available?

John

**tony h** · 06-11-2010, 02:03 PM

I don't know of any general purpose code but if you post a description of what you are trying to achieve someone may have an answer for you.

**jaslake** · 06-13-2010, 04:33 PM

Hi tony h

I recently found this code at http://www.codeforexcelandoutlook.co...ba-automation/

It does what I want but it writes the contacts to the default Contacts file. I'd like to do one of two things:

Modify the code to add a Contacts file from user input, create the file and then write the records to that file, or

Simply specify in the code the file name that the contacts are to be written to.

Please Login or Register  to view this content.

I also found this code at http://forums.techguy.org/business-a...nto-new-2.html

Same questions regarding modification.

Please Login or Register  to view this content.

Any ideas?

John

**darbid** · 06-15-2010, 07:24 AM

Originally Posted by jaslake

Hi tony h

I recently found this code at http://www.codeforexcelandoutlook.co...ba-automation/

It does what I want but it writes the contacts to the default Contacts file. I'd like to do one of two things:

Modify the code to add a Contacts file from user input, create the file and then write the records to that file, or

Simply specify in the code the file name that the contacts are to be written to.

Do you mean that you want them to be able to choose the Contacts FOLDER and not put it into the default one?

If yes then I think you are going to need to put in there this method to allow them to choose

http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

Once you have your Folder which is what the obove will result in, then you add a contact to this folder.

**jaslake** · 06-16-2010, 10:09 PM

Hi darbid and tony h

Thanks forr your input. I've spent MANY hours on this project and have finally resolved it to what I want to do. The code creates an Outlook contacts file from an Excel data file then manipulates the Outlook contacts file such that it uploads the file into a named contacts file in Outlook and creats a distribution list in the named contacts file for those contacts that have an Email address. It also provides for up to two Email addresses for each contact (I suppose this could be expanded).

I'm including the code in the event others may have similar issues

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope this helps someone.

John

**nuttycongo123** · 02-03-2011, 07:32 AM

Dear J ,
I can use the following code to creat distribution list for my customers also ...Like I have 325 customers in my portfolio and I can creat a distribution list ...When I am tryin to run this code ...it's not executing ...can u advice ..

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hope this helps someone.

John[/QUOTE]

**DonkeyOte** · 02-03-2011, 07:34 AM

@nuttycongo123,

Your post does not comply with Rule 2 of our Forum RULES.
Don't post a question in the thread of another member -- start your own thread.
If you feel another thread is particularly relevant, provide a link to it within your own.

**nuttycongo123** · 02-03-2011, 07:48 AM

Originally Posted by DonkeyOte

@nuttycongo123,

Your post does not comply with Rule 2 of our Forum RULES.
Don't post a question in the thread of another member -- start your own thread.
If you feel another thread is particularly relevant, provide a link to it within your own.

@ Sorry D ,
It was done in error ,no harm /hijacking intended ..