Over 1 million tech questions and answers.

Importing Excel directly into a new Outlook Dist List Using Outlook 2007...

Q: Importing Excel directly into a new Outlook Dist List Using Outlook 2007...

From earlier posts a solution was offered to this problem (see below). After executing these instructions I received an error (also below).The "debug" option highlighted the code line: objRecipients.Add (Range("C" & i).Value).

Your suggestions for a fix would be greatly appreciated.

_________________

Open the Excel workbook containing the list of records. Make sure the first record is on line 1. Press ALT + F11 to open the VBA editor and then click TOOLS --> REFERENCES and set reference to Microsoft Outlook and then click OK. Next, in the VBA editor, click INSERT --> MODULE and copy and paste the code below into the blank module. Close the VBA editor, save the workbook and run the code by clicking TOOLS --> MACROS and then selecting the macro "DistributionList" When the distribution list comes up you can manually save it.

____________________

Error message: There must be at least one name or distribution list in the TO, CC, or BCC box.

RELEVANCY SCORE 200
Preferred Solution: Importing Excel directly into a new Outlook Dist List Using Outlook 2007...

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Importing Excel directly into a new Outlook Dist List Using Outlook 2007...

This macro work-around was originally submitted by Rollin_Again on 30 March 2007. If Rollin_Again is still 'rollin' perhaps he would jump back in this problem . . .

Read other 1 answers
RELEVANCY SCORE 183.6

Using Outlook 2007...

This is a project for work. Our marcomms lady has an Outlook email contact list of over 2000 contacts, and these are put into various business distribution lists (by country, by business type etc)...

An new campaign has started and we are about to add another 1300 new contacts and these come from a business application that exports to CSV format. Using Excel, I have created a "Named Range" and can import them with no difficulty into my own Outlook Contact's list as individual contacts. This was where I spotted the problem.

In the case of our marcomms lady with over 2000 existing contacts, if we import another 1300 from Excel, she will then have to trawl through 3300 contacts to find the one's she has imported and then create a distribution list for them, in line with her project. In fact this is what she has done for the past 18 months!! Nightmare!!

So, I want to find a way to import from Excel DIRECTLY into a new or exsiting distribution list in Outlook.

Outlook gives me no view of distribution lists in my contacts area, so does anyone know how to do this?

Chris
 

A:Importing Excel directly into a new Outlook Dist List

Read other 16 answers
RELEVANCY SCORE 128.4

Have been trying to follow suggestions from similar posts, but nothing working. Have tried to save as .xls and .csv, as well as trying to 'define names' of the various columns, but nothing allows me to import complete contact into Outlook. Please help, very important to get these contacts into Outlook asap. Thank you
 

A:Issues importing large contact list in Excel 2007 to Outlook 2007

Hi hbsurfer

Try going about it backwards.
Create one Contact in Outlook 2007, then Export that one Contact to a .csv file.
Then you will be able to see the format Outlook 2007 is using and reconfigure your headers in the Excel spreadsheet.
When all headers match, you should be able to Import it. Or copy the excel information to the one contact .csv file and Import that.

Let us know if that works for you or not.
 

Read other 1 answers
RELEVANCY SCORE 115.2

I recently deleted my colleague's distribution list. Fortunately I have another colleague who has the same distribution list on her PC . It is the same outlook 2007 on both PC . I followed the usual way of exporting and importing the csv file in both window and csv format . But I am still not able to get the distribution list on the deleted desktop ? What is the possible issue here ?

Andrew
 

A:Importing Distribution list from Outlook 2007 to outlook 2007

The only advise I have is to give you incite into the cvs file.

It is the equivalent of a XML markup, but a file a programmer likes to deal with better. It's laid out in what is known as comma delimited formatting. That means, when the file is being read by a program, it stops at the comma's. Everything before the comma is the current entry. Everything after the comma is the next entry, and before etc. The read stops when no more commas are found, and the last entry is taken.

Comma delimited format should allow for the cross platform exchange. If it doesn't try using the XML format instead.

Hope I helped.
 

Read other 2 answers
RELEVANCY SCORE 102.4

I have a message that has an attachment
which is an email distribution list
and saves as filename.msg

When its sent to thunderbird client , it changes to a
winmail.dat
attachment

I cannot therefor import and use that distribution list with Thunderbird.

I'm migrating a user onto a new PC and changing from outlook 2003 to use thunderbird, as the cost for outlook is around ?90

is there an add-in to do this at all
I have tried winmail opener , but that does not work

Thanks

Read other answers
RELEVANCY SCORE 102.4

I have a message that has an attachment
which is an email distribution list
and saves as filename.msg

When its sent to thunderbird client , it changes to a
winmail.dat
attachment

I cannot therefor import and use that distribution list with Thunderbird.

I'm migrating a user onto a new PC and changing from outlook 2003 to use thunderbird, as the cost for outlook is around ?90

is there an add-in to do this at all
I have tried winmail opener , but that does not work

Thanks

Read other answers
RELEVANCY SCORE 101.2

PC #1: Win98, Office XP, MS Mail.
PC #2: WinXP, Office XP, MS Mail.

User on PC #1 has a distribution list with about 8 MS Mail (interoffice, not internet) email addresses, including PC #2. All other emails go through; one will be returned as undeliverable - the one for PC #2.

I tried to duplicate the problem on my pc, but it all goes through.

If user on PC #1 sends an email to PC #2, not using a distribution list, it will go through, even if he sends it to a bunch of people.

I don't know if this matters, but there are two internet email addresses on this distribution list - most of it is interoffice email via MS Mail.

Windows & Office have all their updates & patches.

Anyone ever encounter this trippy thing? Any ideas of what to do?

Thanks,
Lisa
 

Read other answers
RELEVANCY SCORE 101.2

I have a message that has an attachment
which is an email distribution list
and saves as filename.msg

When its sent to thunderbird client , it changes to a
winmail.dat
attachment

I cannot therefor import and use that distribution list with Thunderbird.

I'm migrating a user onto a new PC and changing from outlook 2003 to use thunderbird, as the cost for outlook is around 90

is there an add-in to do this at all
I have tried winmail opener , but that does not work

Thanks
 

A:Solved: Outlook dist List emailed and used in thunderbird

Read other 12 answers
RELEVANCY SCORE 91.2

I would like to have the people on my distribution list see only the name of the distribution list in the "To:" field of the e-mail I've sent, rather than the names of all 25 members in the dist list. I'm aware of using the BCC method, but am wondering if there is a better way.
 

A:Show ONLY Dist. List name in "To:" Field, Outlook 2003

I think this is only possible if you are using a MS Exchange Server distribution list that was set up as 'Hide Distribution List Membership'.

I don't think you can do it with your local distribution list.

However, there are some clever people in TSG so .....

rgds
Hew
 

Read other 1 answers
RELEVANCY SCORE 88.4

I am converting my bosses antiquated rolodex contact files to electronic contact list. I have created a spreadsheet in Excel with all the information(using an exported contact list from Outlook as my format). When I go to import to my Outlook there is information missing, mainly all the phone numbers. The email addresses, names and mailing addresses all come over perfectly. What can I do to get those phone numbers to import. I have tried converting to CSV file and importing but when I do that I get names and phone numbers but no email or mailing addresses. I am using Office 2003. Please help!!
 

A:Importing Contact List to Outlook

Read other 6 answers
RELEVANCY SCORE 88.4

I am using Office 2007

WHen I send and email it gets sent immediately and shows in the Sent box. Even if it is a very large email it immediately shows sent/receive complete in the Progress window, and I can close Outlook.

The problem is that the email has not actually completely been sent. It is being sent and takes a few minutes for a large attachment as my upload speed is only 256 kbps.

If I disconnect the Net once it shows in the Sent folder the mail sending is incomplete if it is a large mail and is never received at the other end.

I am using Outlok 2003 on a different PC an there it does not go from Outbox to the Sent folder until the email is sent out of the computer.

Basically the problem I am facing is that Outlook 2007 puts the mail in the Sent box and I am never sure when to turn off my PC, as I cannot be sure that the mail sending has finished.

Never had this problem before.
 

A:Outlook 2007: Going directly to Sent folder (while sending)

Hi gaurav2004

Welcome to Tech Support Guy Forums!

I have removed your duplicate thread. Please do not create duplicate threads.
One thread for an issue, please.
Continue replies for this issue in this thread.
Thank you.
What anti-virus program are you using, is it configured to scan your e-mails?
If so, try disabling the scanning of messages and send a message addressed to yourself to test.
Are you also using an anti-spam program?
Try creating a new profile to test if the same behavior occurs in the new profile:
How to create a new e-mail profile in Outlook 2007 and in Outlook 2003
Cancel out of any prompts to import messages from the original profile.
Recreate your e-mail address and send a message addressed to yourself to test.

And/or,

in Outlook 2007, look in:
Tools > Trust Center > Add-ins
Disable any active Add-ins, restart Outlook 2007 then send a test message to yourself to test.

If the message goes through without problems, add back the Add-ins one at a time and test after restarting Outlook after each addition to see if the problem reoccurs.
Let us know what happens.
 

Read other 3 answers
RELEVANCY SCORE 87.2

I am in the process of switching to Vista from Windows XP.

I would like to import my email etc from OE 6 to outlook 2007. I do not have OE installed on vista (as it does NOT exist).

I tried
1) import from OE6 to Outlook - no luck
2) Import from OE6 to Windows live mail and then to Outlook 2007 - no luck

Any suggetion will be greatly appreciated.

Thank you very much
 

A:Outlook 2007 - Importing from OE6

Will this be any help to you?
 

Read other 2 answers
RELEVANCY SCORE 86

Here is the problem that we are having here at the office. We have a lot of people with Contact lists from Outlook 2003 to outlook 2007. The problem that arises is this: On my machine which has recently been re-imaged and a clean install of XP and Office 2k7 put onto it and when I Import or Export contacts it works just fine. When a person that has UPGRADED to Office or Outlook from 2003 to 2007 they get a Just-In-Time debug error when trying to Import old contacts, and outlook is forced to restart. HALP, we have been beating our heads against random monitors for a while trying to figure out this silly bug, any tips?

-------------------------------------------------------------------
 

Read other answers
RELEVANCY SCORE 86

Hi, I hope someone can help me with this problem. I have a friends xls file that he cannot get to work in outlook. It was a backup of contact information with several different pages or tabs in it. I was able to convert only the first tab to a csv file so that he could move the information over to a laptop. The rest of the data (pages or tabs ) does not include itself in the csv file. I cannot even get csv to come up in the save as other file type dialogue. Am I missing something? I just want to be able to get this data switched over to his laptop Outlook. Can someone help me? I have tried Microsoft knowledge base and a good googling but nothing helped me with this problem. Thank you so much.
 

A:Solved: Importing XLS to Outlook 2007

Read other 16 answers
RELEVANCY SCORE 86

Hello

I am helping a non-profit organization with their email - they are trying to export from 2003 into 2007.

The 2003 contacts contain sub folders that we imported to 2007 as a .pst file through the import function.

The contact folders show up as separate folders under contacts, but are not available to select from when sending a new email. The contacts folder is available, but not the subfolders.

Is there a fix?
Thanks for viewing.
 

A:Importing Contacts in Outlook 2007

Look at the properties for each contact folder and see if this is checked.
 

Read other 1 answers
RELEVANCY SCORE 85.6

I am having an issue sending attachments directly from any application outside of Outlook. Example: I try to send an excel spreadsheet from excel using the send to option in the file menu. When I do, it loads up outlook and attaches the excel file to a new message. When I hit send to send the message after addressing it, it does nothing. No errors, just nothing. Here is what is wierd. I can hit the save icon and it will save the message in my inbox. If I go to my inbox, select the message and hit forward, it comes up completely addressed as I had done earlier. I click send and it goes.
It's a minor irritation but, I would like to find out why I can send an attachment from a external app without going through these extra steps. I have tried it with Word 2003, Excel 2003, IE7 and a few other apps, same results.

Thank you in advance for your help in resolving my issue.

Mark
 

Read other answers
RELEVANCY SCORE 85.6

I am having a problem opening a file attachment with Outlook Express 6. I can save the attachement to the hard drive and open it, but when I try and open it directly from Outlook express, it says " the file cannot be found C:\Documents
and Settings\User\Local Settings\Temporary Internet Files\....\name.xls"

Other attachments is ok. Please advise.

A:Can't Open Excel Attachment Directly From Outlook Express.

While I do not have an answer for you why you cannot open directly, think on the bright side: You have to drag it out someplace first, then you can SCAN IT WITH ANTIVRUS, and finally open it. Safer this way!

Office files MAY contain malware behind any sheet, document and within macros.

Read other 2 answers
RELEVANCY SCORE 85.2

I just installed Outlook 2007. I have 2 problems. I am using Windows 7 Home Premium. I can't import my address book from Windows Live, Hotmail or Gmail. I have searched and can find only the opposite (to export). I have exported from Windows Live,Hotmail and Gmail, but they are different and won't work. The other problem is I can't change the stationary. It is grayed out and says no other themes installed. I reinstalled the themes and put in the extras. I have folders named stationary that has files in them. you can click on them and see them. I can't find a way to tell the program where they are. Any help will be appreciated.

Thanks, Clint

A:Importing address book in Outlook 2007

Re your [first}problem importing an Address book into MS {Office} Outlook 2007...
See if this link provides you with some help.

Importing and Exporting Address Books in MS Outlook 2007 | Information Technologies | University of Calgary

Read other 6 answers
RELEVANCY SCORE 85.2

Can you help. I have copied all emails and contacts from Outlook 2007 on a computer running Windows 7 to Outlook 13 on a computer running on Windows 8.
I have found the NK2 file in the old computer but it is showing as a word doc. I have download NKSEDIT.exe but it tells me it is not compatible with the version of windows I am running.

Help!!
 

A:Importing outlook addresses from 2007 to 2013

The address are NOT really in the nk2 file, that is just a temp list of the ones that you have typed into an email address pane.
As far as I know they can NOT be import into another version.

You need to make sure that you them in your "Contacts", and then as you use them they should appear in your drop down list as you type in a address in the email address pane.
 

Read other 1 answers
RELEVANCY SCORE 85.2

Hello all,

Perhaps someone may be able to help me out here:

Outlook caches it's autocomplete into a .nk2 file which is saved in:


Code:
XP: drive:\Documents and Settings\user name\Application Data\Microsoft\Outlook

Vista & 7: drive:\Users\user\Application Data\Roaming\Microsoft\Outlook
I want to transfer this file from an laptop with XP and Office 2003 to a PC with Windows 7 and Office 2007. How can I do this?

Thanks in advance

Tom

A:Importing AutoComplete (.nk2) File into Outlook 2007

Don't worry guys, I've found a solution - it may be a way around the problem but it definately works

Just in case someone else is suffering from the same problem here is my solution:

I downloaded NK2Edit - it's just an .exe file so it wont clog up your hard drive with installation files. I opened two windows, one with the old .nk2 file and one with the new .nk2 file and then I copied and pasted the emails and saved it as Outlook.nk2 and then I went to C:\Users\user\AppData\Roaming\Microsoft\Outlookand renamed the existing Outlook.nk2 to Outlook OLD.nk2 just as a back up. Then I pasted the new Outlook.nk2 into the folder then restarted outlook.

Read other 1 answers
RELEVANCY SCORE 85.2

I got a new computer at work and had backed up my old Outlook on a PST file. I have been trying to import that into the new computer and continue to get a message "The personal folder file (PST) is already in use in the current profile"

Sorry for my lack of knowledge on this front but if anyone could help me I really need to be able to import my contacts and messages from the old computer onto this one. Any help would be much appreciated.

A:Importing a PST file to Outlook 2007 on Windows 7

How to manage.pst files in Outlook 2007, in Outlook 2003, and in Outlook 2002

Read other 2 answers
RELEVANCY SCORE 85.2

I'm trying to move my Outlook 2007 rules from my desktop to my laptop. I exported the rules using the Import/Export feature and saved them to a flashdrive. I then imported them the same way onto the laptop, but something strange happened. All I have are the titles of the rules, but not the rules themselves. The "Rule Descrition" box is blank for all of them. I can't run them, and I can't delete them. I've tried restarting Outlook, but nothing helps. Has anyone else had this problem, and if so, what were you able to do about it?
 

Read other answers
RELEVANCY SCORE 84.8

I have a long list of appointments that I need to import into Outlook Calendar from Excel. I have exported my regular calendar to find out what fields I need. I have formatted all columns to be the same as what Outlook exports. When I import only the first two items import. Any ideas? Thanks for any help you can give?
 

A:Importing to Outlook Calendar From Excel

Read other 9 answers
RELEVANCY SCORE 84.8

Dear all,
I've an Excel WorkSheet similar belowe:
________________________
First Row | 1 | 2 | 3 ......
...(day of the month)
________________________
Second Row |Mr. Smith| Mr. Simpson|Miss.......

I want import my appointment from this worksheet
in Outloock calendar.
I'm not interested to import appointment time ....
Only Appointment.
Any Solution?

Thank's.
 

A:Importing to Outlook Calendar From Excel

Can you post your sample Excel file? Just change any sensitive info to dummy data. What you want to accomplish can be done using VBA code.

Regards,
Rollin
 

Read other 2 answers
RELEVANCY SCORE 84.4

Everytime I try to import this file in to outlook, it does not prompt me for the file, its as if it looks for it on its own, needless to say, it cannot . I never had Outlook Express on this computer so what directory do I create to throw this dbx file in to so outlook may find it and import?

"No internet accounts could be found"
"Would you like to import email messages and addresses from Microsoft Outlook Express or Windows Mail?" *yes*

It finds one file, welcome to windows mail. with todays date on it.
 

A:Trouble importing ,dbx file in to Office Outlook 2007

Assuming Vista - Take a look at this:

http://www.vistax64.com/vista-mail/103695-re-importing-dbx-files-into-outlook-2007-a.html
 

Read other 1 answers
RELEVANCY SCORE 83.6

I am using Outlook & Excel 2007. Trying to import contacts from Excel.

I've imported several times with different results and finally figured out the "name the range" rule and to save the Excel worksheet in the 97-2003 format. I also selected 'Do not enter duplicates" and then mapped out the entries.

I tried this last time using a dummy list of 10 fictional entries which included columns for first name, last name, email, address1, address1, city, state and zip.

After importing, I had 10 contact with just the first names, an additional 10 contacts with just last names, another 10 with just email addresses, etc. I don't understand why it would think that each column was a different set of contacts.....

I would GREATLY appreciate your help.

Also - I am practicing on my system so I can help a client import a huge 500+ list into her email program. She is on Windows Vista with Windows Mail. Any suggestions on how the process will be different on those systems/programs??

THANK YOU!

BkkprGal
 

A:Solved: Importing contacts into Outlook from Excel

I've played with it more and found out that I needed to save the spreadsheet as a CSV file. That has fixed my problem.

See I knew this site would help me!
 

Read other 2 answers
RELEVANCY SCORE 83.6

Whenever I import e-mails from Excel to Outlook they appear to have transfered without error. However, the e-mails have lost the "link" When I open up the Contact in the Outlook Address book, the e-mailed is underlined and appears to work but it won't send. I can solve this by going in and placing the cursor at the end of the e-mail address and clicking on enter and then saving the contact. However, this is a real annoyance.

I don't do this very often, but I have do have the occassional client that drops AOL and wants me to set everything up to Outlook. When there are 200 names it is just a waste of time.

Anyone have any suggestions or solutions? Thanks in advance!
 

Read other answers
RELEVANCY SCORE 83.6

Hi Rollin,
Appreciate your help in this area of my project. I am new to this interface; have tried this vba script from your website and I managed to import the contacts and create the distribution list. In the Outlook address book; I notice I have duplicate record of the same contact e.g. Fitz Bob (email address) and Fitz Bob (Business Fax). During the creation of the Distribution List my Outlook display the email address on the Name and Email columns.
My objective is using the excel worksheet to import the contacts into the distribution list in Outlook.
Appreciate if you can let me know where my mistake is.
Thanks,
learner123

*** I have attached Excel worksheet file with vba macro script in it.
 

Read other answers
RELEVANCY SCORE 83.6

I'm ready to pull my hair out over this, I just started working as the tech guy at this law firm and out of all the incredibly difficult things I fell really accomplished for solving... this thwarts me.

I have a list of like 1200 names and something along the lines of 20 different columns of information for each name (i.e. last name, first name, client ID, home phone, etc.) which I am switching from this archaic program they were using into outlook. To do so I copied the dBase file to Excel XP and asked the paper clip how to import it to Outlook (in case you couldn't tell before how desperate I am, now you know) and he said:

Name each column of information you want to send
Go to Outlook and hit File>import
Chose program, then file
Select location in address book (i.e. Contacts)
Drag each named column into whichever section in the contacts list I want.
Here it also says that if I want to add a section I can click a button for it, but I don't have that button either (this is XP pro)

And then it should all be okay, so to try it out I loaded a names column into "Name" and the corresponding e-mail addresses into "e-mail", and all I got was the field "display name" showing the e-mail addresses as well as the "e-mail address" section displaying the e-mail addresses.

So I figured I was just doing something stupid, and I just took the whole dBase file to Excel and then just tried to import without mapping the location of e... Read more

A:Importing Excel XP to Outlook XP Address Book?

Read other 7 answers
RELEVANCY SCORE 83.6

I am trying to get way from the nightmare of Windows Live Mail 2011, mostly due to two bugs that are still in the latest version of the program.

I'm trying to migrate from WLM2011 to Outlook 2003 and I have run into a brick wall on importing my email accounts. Microsoft has extensive help pages on migrating TO Windows Live Mail, but apparently they do't think anyone would ever want to go FROM Windows Live Mail.

There is a good article at Migrate from Outlook Express or Windows (Live) Mail to Outlook | HowTo-Outlook which covers migrating the messages and contacts, but no one seems to have found any way to get your account data from WLM into Outlook. WLM will export the account data as iaf files (just like Outlook Express did) but Outlook doesn't recognize the iaf files.

I found a couple of old Outlook help pages that talk about importing IAF files, but the procedure shown does not work because Outlook doesn't ever give you any chance to tell it where to look for the IAF files, it just says "No internet accounts were found to import"

A:Importing email ACCOUNTS from WLM2011 into Outlook 2003 or 2007

I usually just manually copy the Account Settings data from one program to another. There isn't much data to copy and it reminds me of my server login information.

Read other 1 answers
RELEVANCY SCORE 82.8

Hi there,
I apologise if this has been covered before. I am planning on importing a large number of contacts from excel to outlook (both 2003).
Because there are so many contacts I want to be able to categorize them beyond the default categories provided in outlook (company, job title etc) so that I can then sort them alphabetically, ctrl+shift those of the desired category and send out emails. E.g. say I want to add the category favourite pizza, and then I may want to sort the contacts to email everyone whose favourite pizza is (say) vegeterian.
I have found two ways to add additional categories:
1) via the user-defined fields (text based)
2) Add an additional category to the master list (yes or no)
drawbacks:
1) I have not found a way to map these details to those in outlook, i.e. when trying to map I can't find the user-defined categories list anywhere (?)
2) this DOES map but you "can't sort by categories" when looking at a phone-list view of contacts. It is also possibly prone to error as all the information is not under the same heading (e.g. favourite pizza vs listing a number of different pizzas)
I don't think I explained that very well... but if it makes sense to anyone please help!
Thanks very much
 

Read other answers
RELEVANCY SCORE 82.4

Hello All!
I am having a heck of a time importing email messages from Vista Windows Mail. This is my situation: I have a new laptop with Windows 7, I have Outlook 2007 installed on it. I have backed up data from the old hard drive using an IDE to USB cable and Cobian Backup Black Moon Edition. When I try to import the address book and the messages, it imports the address book, but not the messages. Can anyone help me to figure out another way to do this, or if there are other settings that I need to change in order to make this happen.
 

A:Need help importing email messages into Outlook 2007 from Windows Mail Files

It is best to export the messages from Winmail, then import them into Outlook.

Not sure how you backed up your Winmail.

Also see this
http://www.vista4beginners.com/migrate-to-Outlook-2007-and-Windows-Vista

.
 

Read other 1 answers
RELEVANCY SCORE 82

I need to import contacts from Excel into Outlook Contacts 2003. When I name the range in the Excel worksheet then close the workbook I open Outlook Contacts then click import from Excel. I then locate the workbook and find the named range of contacts. I then proceed to import them after mapping. However when I then search the Outlook Contacts folder I cannot find any of the new contacts.
Any suggestions please?
 

A:Problems importing contacts from Excel to Outlook in Office 2003

Please post a sample XLS file without personalised data
 

Read other 2 answers
RELEVANCY SCORE 81.2

Hiyo.
To begin with, I just want to check if this is viable, and if so, which solution is best/easiest...

Office 2010.

Current situation:
An Outlook rule moves certain messages to an Outlook folder.
A macro button is used to run code that prints the attachments of all messages in that folder.
Think it then deletes the messages.

Required situation:
Instead of printing all attatchments, the macro needs to look at a specific column of data in an Excel file.
If a value in the Excel column matches (or part matches) the filename of the attachment, the attachment is printed.
All attachments with filenames that do not match the Excel list are left alone.

Alternatively, switch it round, so the macro is in the Excel file, and it checks the values in the column against the attachment filenames of messages in that Outlook directory, and prints those that match.

Alternatively, write something in Outlook code, perhaps using a form control, whereby the user can enter (paste in) the batch of values, and it then prints attachments accordingly, rather than trying to forge a link between Excel and Outlook.

Alternatively... use some 3rd party tool that accepts the batch of values and interacts with Outlook to print the attachments, bypassing the need to write and manage code.

Or something else?

Cheers.
 

A:Outlook/Excel - Print selected attachments based on Excel list

Alternatively... modify the existing Outlook macro to save all attachments to a dir on the PC instead of print, and then write an Excel macro to check the files in the dir instead of the Outlook folder.
 

Read other 1 answers
RELEVANCY SCORE 81.2

I have to sort out a huge base of about 2500 contacts infortunatelly in excel

The data is entered in a sloppy way ... you got writen comments next to mobile numbers, mixed Greek and English languages, full text Addresses (Not separated in Street, Region, Country etc), and any other stupidity you can immagine.

Nevertheless I managed to import this mess on to Outlook 2003 (the standard way - put headers in the excell according to Outlook requirements (LastName, FirstName etc) selected the data area (all data columns) and inserted a name for it. When mapping fields in the outlook import interface I decided to map the full text addresses column as Notes (full text supported)

All went fine (after several tries though) and imported this huge list of contacts.

THE PROBLEM: there is data missing randomly in over 50% of the contacts.
Some Contacts are without "BusinessPhone" numbers, others without MobilePhone and so on...

I cant figure out what is going on since every time I import the Contacts (tried many times to find some paterns) there seem to be different data missing ... even though Greek fonts (that I feared would be an issue)
are imported properly (Unicode Supported)

Could it be that the Outlook refuses to import some data because the formating in the excel sheet does not correspond to what it expects to receive ?

Is there any particular formating that has to be applied to the ecxel sheet or cells for the data to be properly imported?

Any ideas on what migh... Read more

Read other answers
RELEVANCY SCORE 80

I set up a new Distribution List and sent the email with newsletter attached this morning. I do not use the global address book. Everyone is listed in my icloud contact list. The list seem to send fine although the outbox folder showed the email still sending. I then received an email from a person on the list that he had received the email 11 times. I then open the outbox folder and deleted the email with the distribution list. The same gentleman send me another email that he had received another 4 copies of the email. What can I do to make sure that this doesn't happen again? What did happen? I have Windows 7 64-bit with outlook 2007. thank you for your help.
 

A:Outlook 2007 Distribution List

opmanager said:


I set up a new Distribution List and sent the email with newsletter attached this morning. I do not use the global address book. Everyone is listed in my icloud contact list. The list seem to send fine although the outbox folder showed the email still sending. I then received an email from a person on the list that he had received the email 11 times. I then open the outbox folder and deleted the email with the distribution list. The same gentleman send me another email that he had received another 4 copies of the email. What can I do to make sure that this doesn't happen again? What did happen? I have Windows 7 64-bit with outlook 2007. thank you for your help.Click to expand...

You might have him in the contact list in multiple places. This is often common when users are members of multiple groups in the same contact list. Thats why he's the only one that complained he received it multiple times. Chances are his email appears there by itself, then as part of a group, and yet as part of another group.

To resolve this you would have to remove all groups in the contact list. Verify that the individual emails appearing in the list are unique, remove the guys emails from the groups it appears in, and then re-add the groups back to the contact list. Please try this and post with feedback. Thanks
 

Read other 1 answers
RELEVANCY SCORE 80

about a week ago i could not access the contacts list in outlook 2007 it seems to have totally gone

what can i do to rectify this

thank you
aamir

A:outlook 2007 contact list

Do you mean that the Contacts button in the Navigation Pane is missing:
.

Read other 7 answers
RELEVANCY SCORE 80

Hello,

I have upgraded to Office 2007 from Office 2003. When I open an Excel attachment from email in Outlook 2007, the Excel application opens but the document itself does not. The document has a .xlsx extension. I need help resolving this issue please. If anyone knows why this is happening or the fix, I'd appreciate your insight.

JayT908
 

Read other answers
RELEVANCY SCORE 79.2

When I try to open an Excel document attached to a email Excel opens but the document doesn't appear until I click on the minimize button. Has anyone seen this before?

I'm Using Excel 2007 and Outlook 2007.
 

A:Opening 2007 Excel documents in Outlook 2007

Read other 12 answers
RELEVANCY SCORE 79.2

A distribution List was deleted by accident.

The distribution List was manually rebuilt, using the same name as before.

When clicking on the TO/CC/BCC fields to display the selection box of addresses, the newly rebuilt list DOES NOT appear. However, the AUTOCOMPLETE option will find the list. From what I understand, AUTOCOMPLETE is probably finding the OLD version (which happens to have the right addresses).

The difficulty is that many emails are sent to multiple Lists, and this one doesn't appear in the selection box to choose along with several others for a particular email.
 

Read other answers
RELEVANCY SCORE 79.2

I just recently switched to Outlook 2007. The program was used by another user so it had distribution lists already in it. I updated one of the lists by deleting some names and adding others but now when I send an email and put in the name of the distrubution list and then click on the + it shows the names I deleted and none of the names I added. When I look at the distrubition list under contacts it shows the correct list of names.

I've tried deleting the list and recreating it but still get the old list. What should I do?
 

Read other answers
RELEVANCY SCORE 79.2

It's a wierd issue , let me try to explain what happens.
I have distribution lists in Outlook 2007. It might contain some 15 names inside it. When I make an email and want to send it to this distribution list and hit the send button, the distrubution list dissapears and all left there are a bunch of semicolons (the normal separator between email addresses). The message of course doesn't go out since there's nobody in the email address, but doesn't give an error or anything.
Do anybody know what I can do?
Just to give a little more data, this will happen with any distribution list, even new ones that I create, and if I just put all the names in the distrubution list individually in the To:, it will work fine and send the message.
 

Read other answers
RELEVANCY SCORE 79.2

HELP PLEASE! It would appear that I've just accidentally deleted a distribution list that I had in Outlook Contacts.
Can this be recovered, as I cant see it in Deleted Items?

A:How to recover Outlook 2007 distribution list

HI,

Yes, you can recover your Outlook 2007 distribution list using these tips : Restore a deleted distribution list - Outlook - Office.com

Read other 2 answers
RELEVANCY SCORE 78.4

Yep, no matter what I do or try, all the mail for my Inbox goes straight into Junk Mail.

I have triple checked all the account, junk mail and security settings and they all appear OK.

Even when I mark one of these as "Safe", next time straight back to the Junk Mail.

Driving me nuts this one ..............
 

A:Solved: Outlook 2007 dumps ALL my mail directly into the Junk Mail - why?

Read other 7 answers
RELEVANCY SCORE 78.4

I recently purchased a new computer that has Office 2010 installed. I would like to move the contents of my .pts file from my old computer which has Outlook 2007 to my new computer which has Outlook 2010. Before, when I wanted to transfer my .pts file from one computer to another I would just copy the file to a portable hard drive and then transfer the file to the other computer. However, Outlook 2010 is completely different animal. When I go to C:, Users, App Data, etc., new computer, it is completely different from my other computer that had Vista. My question is, how can I transfer my .pts file and/or my address book, calendar, contacts, etc. for my older Windows Vista computer that had Outlook 2007, to my new computer that has Windows 7 and Outlook 2010 installed? Thanks in advance for any and all suggestions.
 

A:Solved: Moving Outlook Messages and Address Book From Outlook 2007 to Outlook 2010

Hello referee07;

Copy your .pst file from your old computer to the new one or your portable hard drive.

To launch the Outlook 2010 Export/Import wizard, first go to File menu, navigate to Open, and click Import.

In the Import And Export wizard, select Import from another program or file option and hit Next

Under File Type, select Outlook Data File(.pst) and hit Next

Now choose the file to import, select the options, and hit Next

Once done, finally select the folder to import from(if you want to import complete data don’t change any settings) and make sure Include subfolders is checked. You can either import the file to the current folder or choose the folder.

Hope this helps!

Dave
 

Read other 3 answers
RELEVANCY SCORE 78.4

I'm stumped. I have email addresses in an Excel file that I need to send an email with Outlook or Outlook Express. When I try to import the file, I get the error message that the Excel file has no named ranges. I have gone into the Excel file and highlighted the addresses, but to no avail. What am I doing wrong?
 

A:Put Excel list of addresses into Outlook?

Read other 16 answers