Computer Support Forum

Solved: Outlook macro to import contacts from excel

Question: Solved: Outlook macro to import contacts from excel

Hi, I am looking for a macro to import contacts from excel. We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I would like to create the macro for all the team so that they can periodicaly update their contacts. I trust this makes sense
Thanks
Moved to Business Applications.

More replies
Relevance 100%
Preferred Solution: Solved: Outlook macro to import contacts from excel

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.)

Relevance 86.42%

Moved from Software Development
Hi, We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in to emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed so they could be updated by all. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I have updated an excel spreadsheet containing all the information and I would like to create a macro for all the team to periodicaly import this data in to Outlook Contacts and possibly create distribution lists from these. I trust this makes sense I am using Outlook 2003.
Thanks
 

More replies
Relevance 105.78%

I have an excel spreadsheet which has names ( first and surname in single column under NAMES ) and email addresses (under EMAIL) which I want to import into my Outlook Personal Address book. I have followed advice of previous post but still only get the email addresses, no names. Tried suggestion of inserting a userdefined name for the spreadsheet but I still only get the option of email address in the import-from column. I have tried renaming the columns, I have tried changing them around. Is it because I don't have addresses and phone numbers?
 

Answer:Solved: Import contacts from Excel into Outlook 2003

8 more replies
Relevance 105.78%

I'm trying to import a contact list from Excell 2003 (11.80...) SP3 to Outlook 2007 (12.0) MSQ (12.0)
When I try to map the fields, I can only drag one "vlue" at a time, and when I I try to map another one, it seems to disapear. I went and maped all the fields, one at a time using the Map Custom Fields and it imported all the Excell fields into one Outlook field.
I'm useing Windows XP
I tried and tried all day, can somenoe help???
 

Answer:Solved: Can/t import contacts to Outlook 07 from Excel 2003

7 more replies
Relevance 95.53%

I'm trying to create a email distribution list. I've got all the names in excel and I figured the only logical way to do this would be to import the excel spreadsheet into my contacts in outlook and then create my outlook distribution list from my contacts in outlook.

When I go to import my spreadsheet I get the following error message.

"An error has occured in the Microsoft Excel translator while getting the contents of a file system.

The Microsoft Excel file "c:\folder\excel.xls" has no named ranges. Use Microsoft Excel to name the range of data you want to import."

The error makes sense but I don't know how to name a range.
 

Answer:import contacts from excel into outlook

7 more replies
Relevance 94.71%

hi,

I try to import contacts from Excel but I get an error message
(the records are in columns, each column a field)...

In addition I tried something else:
1) I create a record in Contacts
2) Export this in a Excel file
3) Pasted the records from my file
4) Import in Outlook
5) PROBLEM. Only the first record was imported

to overcome this I created 180 Contacts and again steps 2,3,4,5
and it was ok....

This doesn't seem right is there any other way, method. Some rules and conditions i should know?

Answer:Outlook 2003, import contacts from Excel

export your contacts folder to a pst file instead. import the file in outlook.

Move contacts to another computer - MS artical

1 more replies
Relevance 93.48%

Hi Guys,
Any clue on how to import data from excel to outlook contact list and creat distribution list ...
Thanks in advance ..
 

Answer:import Excel to outlook contacts in specefic format

Create a distribution list in Outlook and then export the contacts list to a CSV file. THis will give you an idea of how the DL's are formatted and how individual contacts are referenced as a part of that DL.
 

1 more replies
Relevance 87.74%

Hello!
My computer was upgraded with new processor and hard drive. A copy of the original hard drive was stored on a server. Would you tell me how to import my old Outlook contact file from there to new hard drive. I would really appreciate it.

Also, where is the file containing the addresses created in Netscape? Either one will work.

Thank you, dyna

[This message has been edited by dyna (edited 09-19-2000).]
 

Answer:Solved: Import Outlook Contacts

In a nutshell, you will EXPORT from your old PST file and then IMPORT to the new location. You will be able to select what information (inbox, contacts, calendar, etc.) you want to work with.

The PST file by default is named OUTLOOK.PST and is stored on the hard drive. This, however, may have been changed by the individual that original setup your PC.
 

2 more replies
Relevance 86.51%

I'm kind of new to Access and I've been teaching myself. I'm trying to import several contact lists from Outlook 2000 into an Access database. I want all these different contacts in one table. Can anybody tell me how to accomplish this? Thank you very much. You people are very smart.
 

Answer:{SOLVED} Access: Import Outlook Contacts

7 more replies
Relevance 85.69%

Hi,
how can I import messages and contacts from Microsoft Outlook 2007 into Windows Live Mail 14, or any other e-mail program?
Tanks in advance,
sahanavatu
 

Answer:Solved: import messages and contacts from Microsoft Outlook

6 more replies
Relevance 85.69%

First of all, I don't have Business Contact Manager installed in either computer. I am moving my Outlook 2007 Contacts from XP to Vista in the new computer. I used to know how to move my address book in Outlook Express, but I'm strictly a novice with Outlook. Please, can anyone help me?
 

Answer:Solved: Import/Export Outlook 2007 Contacts

7 more replies
Relevance 81.18%

I'm working on a Bill of Material creation automation project that requires some expertise in VBA, and I have none.
The objective is to run a macro from an excel spreadsheet called "PGE BOM", to do the following:
1) Go to the folder "C:\Documents and Settings\Desktop\Auto Project"
2) Find all the .mdb databases in this folder
3) Find "HistoricalMaterialItemsAll" table in EACH of those databases in step 2, and import the data from the columns listed below into PGE BOM.xls's columns C through G:
DrawingNumber
ItemNumber
Quantity
PgeCode
Description
The following is a VBA code that my friend had written in Excel 2007. Unfortunately I have an older version (2000) and the code does not seem to be compatible with Excel 2000.
Sub ImportAccessData()
Stop
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
sRow = 2
bFile = False
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath)
strFlNm = Dir
If strFlNm = "" Then bFile = False
Loop
End Sub
Sub GetData(fl)
Stop
strSQL = "Select HistoricalMaterialItemsAll.* From HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, xlCmdTable
Set WB = Application.ActiveWorkbook
Set WS = Applicatio... Read more

Answer:Excel Macro - VBA code to import access data to excel

Hello, and welcome to the board!

When posting code, please use CODE tags, which extremely helps with readability.

Perhaps you could try using the code constant???...
Code:

Option Explicit

Sub ImportAccessData()
Dim dPath As String, sFile As String, strSrch As String
Dim TargetWB As Workbook, TargetWS As Worksheet
Dim sRow As Long, bFile As Boolean, strFlNm As String, strPath As String
dPath = "C:\Documents and Settings\Desktop\Auto Project\"
sFile = "*.MDB"
strSrch = dPath & sFile
sRow = 2
bFile = False
Set TargetWB = Application.ActiveWorkbook
Set TargetWS = TargetWB.ActiveSheet
If Dir(strSrch) <> "" Then
strFlNm = Dir(strSrch)
bFile = True
End If
Do Until bFile = False
strPath = dPath & strFlNm
Call GetData(strPath, TargetWB, TargetWS)
strFlNm = Dir()
If strFlNm = "" Then bFile = False
Loop
End Sub

Sub GetData(fl As String, WB As Workbook, ws As Worksheet)
Dim strSQL As String, iRow As Long, sRow As Long
strSQL = "SELECT HistoricalMaterialItemsAll.* FROM HistoricalMaterialItemsAll"
Workbooks.OpenDatabase fl, strSQL, 3 'xlCmdTable
iRow = 2
Do Until ws.Cells(iRow, 1) = ""
ws.Cells(sRow, 7) = ws.Cells(iRow, 5) 'Get the Description
iRow = iRow + 1
sRow = sRow + 1
Loop
Application.DisplayAlerts = False
WB.... Read more

1 more replies
Relevance 79.13%

I am new to VBA Macro. I am trying to create a VBA macro to import CSV file to excel. The following is the code that I recorded it, however, I manually finished writing the last part of the code because there was an error saying "Too Many Line Continuations" however, it is not liking it. I am not sure where I did wrong. Some times I get the error message saying statement too complex. It is actually pretty straightforward. The most part is the datatype. The file I am trying to import has about 3700 columns. It would be great if someone can help me out here. Thank you.
Code:

Sub VBAMacroInpatient()
'
' VBAMacroInpatient Macro
'
' Keyboard Shortcut: Ctrl+Shift+I
'
With ActiveSheet.QueryTables.Add(Connection:="TEXT;Z:\Alex\Inpatient.csv", _
Destination:=Range("$A$1"))
.Name = "Inpatient"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 437
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
... Read more

Answer:HELP: VBA Macro to Import CSV to Excel

16 more replies
Relevance 78.72%

Tried doing this but I get scattered pieces imported.

Got as far as dragging address from an excel file to email field in Outlook, but get an error and bits and pieces.

Don't want to import one by one.

i shortened the excel file to just one column with e-mail addresses.

Got to be a way.
 

Answer:Solved: Import e-mail addresses to Outlook from Excel

Hi holymoly

In the Address Book in Outlook Express, enter at least one contact.

Then Export the Address Book as a Text File (Comma Separated Values) (.cvs) file to the Desktop.
This will give you a template to work with.

Open the .cvs file and paste the e-mail addresses into the correct field.
Save and close the .cvs file, then Import it into the Address Book.
File > Import > Other Address Book > Text File (Comma Separated Values) > Import
Browse to the .cvs file on the Desktop.
Let us know if that works for you or not.
 

2 more replies
Relevance 78.72%

Hello Helpful Folks,

I have searched with no luck for a solution to my problem. Here's the rundown:
Running Windows XP
Using Outlook 2007, Excel 2007

I want to take a database in Excel and import it into Outlook. Not sure if my screenshot is attached, but I do not have an option to "Import/Export" under File. Any other way around this?? Thanks for the help.
 

Answer:Solved: Cannot Import Addresses from Excel to Outlook 2007

6 more replies
Relevance 78.31%

When trying to import from Excel I don't have the option as the instructions say under Help to "Import from another program of file". I have 3 options which are: "Export to a file", Import Internet Mail Account Settings" and Import Internet Mail and Addresses. Can anyone help direct me, this seems simple but I am stuck.

Answer:Import contacts from Excel file

What email program are you using?

7 more replies
Relevance 77.9%

Hello,
I'm without any success hardly trying to modify (as begginer I'm still unable to create) some macro's I found in this forum in order to send data from Excel sheet into a specific public (or not if it's too heavy) calendar in Office 2010.
Import would take place with a push of a button and duplicates should not be allowed...

Even a simple line like: Dim olApp As Outlook.Application gives an error ...Maybe I'm getting tired...

And how should I modify those lines in order to select a specific Calendar (using Folder(Calendar name) in place of GetDefaultFolder in the lines mentioned here under?
Set olNS = OL.GetNamespace("MAPI")
Set olFolder = olNS.GetDefaultFolder(olFolderCalendar)

If someone would be kind enought to give me a help, here are some details about my Excel sheet:
Column A "Company", Column D "Date soon", Column G "Date Late"
Column A is fully completed, but columns D and G have some lines without any date...
 

More replies
Relevance 77.49%

Hello Group,

Trying to import one long Excel 2007 column which has only e-mail addresses, into a specific folder in my Windows Contacts. I want to then create a new contact group and then Open that folder with the imported addresses, and do a single Add step, selecting all the imported addresses, from the folder into the new contact group.

Have read some posts about this but it is not working for me (PC Windows Home Premium, Office 2007). Step-by-step:

OK, I save the Excel as a CSV file. Then Tools>Windows Contacts and open the destination folder. Clicking Import > CSV > Import and browse to the Excel file saved in CSV format > Open > Next

Then "Map the fields you wish to import" window appears, showing only the first e-mail address (from the top of the Excel column).

I click on Change Mapping and select "E-mail address" from the list of fields, tick the Import this Field box, and OK, then Finish. Voila.

The e-mails are imported, but they are scattered throughout my Contacts, and the destination folder remains empty.

How do I import to a specific folder in my Windows Contacts? I did not see a destination folder option during the import process, but that folder was opene when I did the import.

Thanks for looking in. Hope someone can solve this, as otherwise I must handle the addresses one-by-one into the Contact Group.

seekinganswers
 

Answer:Import Excel to Windows Mail Contacts

10 more replies
Relevance 77.08%

I had a distribution list for a mass email for some of our customers. But when we got Microsoft Exchange everything copied over but this one (the most important list!) did not copy over. But I checked through the sent messages and was able to copy the list from the BCC Field to a text file.

Now, I need to get this list of people back in a distribution list. If anyone knows how I can achieve this, please help me out! I've been google-ing this and cant seem to find something to work for me!
 

Answer:Solved: Import list of emails to Outlook Contacts or Distribution list

11 more replies
Relevance 77.08%

Hey guys, I am quite new to creating macros. I do have some primitive experience with code. My goal is to take 3 or 4 colums of information and put them into Outlook Calendar.

A- Discription B- Start -C Finish

So, in the Calendar in outlook it would show a discription and connect the dates in B and C to the days in the Calendar. I don't know if it can be done. At my current state I can't figure out how to get even one to move over. Any suggestions on where to start??

I am running Outlook and Excel 2003 all updated. On Windows XP Pro Service Pack 2.
 

Answer:Solved: Excel Macro to Outlook Calendar

16 more replies
Relevance 77.08%

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
 

Answer: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!
 

2 more replies
Relevance 76.67%

Running Outlook 2000 on Win2K.

Received an email with a large number of recipients in the "To" field.
Is there an easy way to save all of the addresses as contacts in my address book - preferably in a new folder so I can sort through them before adding to my main contacts.

Thanks in advance.
 

Answer:(Solved) Outlook - Import contacts from "To" field?

8 more replies
Relevance 76.67%

Hello guys

I need some help please in Excel macro and VBA.

I am a coop student, and my my boss wants me to do the following :

A software on my pc collects various csv files from several other pc's on the plant. There are 3 different files.

What I would like to do is to run a macro every day which opens that software, import all the csv files to an excel spreadsheet, add the specific header to each file ( I have 3 different headers in one excel file, one for each type of file) and then save the files in xls format.
Could someone provide me with the VBA code for this please?

Thanks
 

Answer:Running excel macro to import csv files from a software on my pc

8 more replies
Relevance 75.85%

I'm trying to import saved e-mail addresses from an Exel file to address book in Outlook 2003.It will only let me put the names etc into Contacts. When opening the address book to send mail there are no names listed.Can I copy the names from contacts to the address book as I don't fancy having to type them all in again.

Answer:Import contacts to outlook

click herethis may help...

2 more replies
Relevance 75.85%

Hi,
Can someone point me to documentation on how to import contacts into Outlook when the contact list is in some other format - in this case a .rtf file?
I thought it would be good to run some automated procedure to get the .rtf file into the format that outlook expects for an import of contacts.
Thanks
 

Answer:Outlook - Import Contacts

Would it be possible for you to create a CSV file instead of a RTF file?

Someone else maybe able to help you with this better, but I have heard that "A RTF file is difficult if not impossible to import into Outlook contacts."
 

2 more replies
Relevance 75.85%

I have an Acer desktop pc at home, running WIN8 Pro, and I use Outlook 2010 as my primary (POP3) email tool.
Obviously I have an extensive contacts file in there.

I have just bought a SP 128Gb and installed Outlook 2013 on the one month free trial.
So, far I like it.

I took it in to work today and the IT guys set it up for connectivity to the Corporate WiFi, VPN, etc.
Cool! Now it's a mini-me of my work pc!

My question is, and I'm a complete dummy here, is how can I copy my contacts info from my home pc into my Pro?

Thanks in advance for your assistance.

Answer:How to import Outlook contacts?

Did you try this? ↓
Export contacts - Outlook - Office.com
Import contacts - Outlook - Office.com

If yes, what problems did you have?

6 more replies
Relevance 75.85%

is there any way to import contacts from an old windows instalaion to a new one? i have the contact files in the contacts folder, but outlook doesnt recognize them.... HELP PLEASE!!!!

Answer:import contacts in outlook 07

This might help you

Backup and Restore | HowTo-Outlook

Steve

8 more replies
Relevance 75.85%

I am so confused about where outlook 2013 keeps things.

I have installed Outlook 2013 and would like to import my contacts from my outlook 2007 in another computer. I have already prepared the contacts.pst file from outlook 2007 and made it available in my public folders. I then imported the .pst file into Outlook 2013 via network. However the contacts shows up as a separate contact list rather than integrated into the outlook 2013 address book . How to correct it?

I must have got the process wrong.

Thanks

Answer:outlook 2013 import contacts from outlook 2007

OK. I found the imported contacts in a separate list inside the address book. There are 2 lists one is "In This computer" the other is just "contacts" . How do I make the "contacts "list as the default so I get an address book when I click on 'To" ?

1 more replies
Relevance 75.44%

Ok, just a bit of advice needed on this one for the time being...
I need a macro that will:

- Save all (Excel) attachments from the currently open email message (or a message selected in the Inbox) to a directory on the PC.

- Merge all the saved Excel files into a single file - they're all formated exactly the same - data in about 20 columns, no column headers or anything, just standardised data.

- Save the merged file with a standard name (i.e. every time this is ran, it needs to have the exact same filename).

- Delete all the files in the directory apart from the merged file.

I know there's probably a fair bit of code online for doing the individual parts of this. Can I do both from within Outlook? It doesn't particularly matter if I need to do this in 2 steps - an Outlook macro to save the attachements, and an Excel macro to do the file merge etc.

Cheers.
 

Answer:Solved: MS Outlook / Excel macro - extract attachments and merge

16 more replies
Relevance 75.03%

Hello,
The title would make it sound like a simple problem, but I can't figure it out for the life of me. Here is the situation. Last week a thunder storm blew through and sent a electrical spike through my protection and rendered my motherboard useless. My computer guy salvaged my data for all users from the drive. Once the motherboard was replaced, he had to repair the OS,(Vista). He then plopped the data into a folder on the drive. Now I just need to reload my programs and all that stuff. My question is this: I see the folder with all of my contacts in it. How do I get those contacts back in Outlook 2007? I tried the import wizard, but it seems that there is no option for importing that format. I looked at the properties of one of the contacts and it is listed as a .contact format. What is that? Any help would be appricated.

Answer:Import Contacts into Outlook 2010

Did you save the original Outlook.pst file? If so, just replace the new one with the original.

4 more replies
Relevance 75.03%

How do I import my Comacast contacts into Outlook2003?
 

Answer:Import contacts from Comcast to Outlook

7 more replies
Relevance 75.03%

Anyone know how to do this?

I have tons of contacts online (in Hotmail) and I would like to be able to acces them when i am at home using Outlook xp.

Can anyone help

Thanks
 

Answer:Import Hotmail contacts into Outlook

This may or may not work,
1. First have the HotMail acct installed in your OE application. To do this follow instrucitons at this link
2. Than open up Address Book> TOOLS> Press Synchronize Now.
3. This will move contacts from the Address Book's Main Contact folder
(not any contacts in sub-folders that you have created) to the HotMail
Address Book, and visa versa. You will need to check both address books
for duplicate entries, and delete as necessary.

Hope it helps

 

1 more replies
Relevance 75.03%

In importing contacts from Outlook 2003 to Outlook 2007, the name field is changed.
Specifically, "Adams, William and Cythia" is changed to "Adams, William R."
My client prefers to mail to the Husband and wife format, so is there a way to change this?
 

More replies
Relevance 75.03%

Basically here is my situation, I had an iPhone, I hate Apple, so I'm using the new Touch Pro 2 and I love it!

However, I'm trying to get all my contact on there, around 300, and they are all stored in the "C:\Users\{User}\Contacts" folder. I need to get them to sync with the Mobile Device Center. The only way I know to do this is to put the contacts in Outlook 2007.

If you have a better mouse trap or know how I can do this, please chime in.

Thanks SF.

Answer:Import Windows Contacts to Outlook

I had the same problem. Evidently you have to specifically check the folder that you want to import from the .pst file. So I did one import and go my archived data, but no sent or received. Then I did it again and chose sent. It worked. But no received, so I did it again and it worked. But no contacts. I did it again and chose contacts. It worked. Be careful to correctly select import duplicates or not and to correctly choose the existing personal folder to import into or you will get a duplicate personal folder in the list (its ok, you can delete it). In the end it was simple and I just needed to pay more attention to what I was doing. My fault for doing it at 3 am! -S

1 more replies
Relevance 75.03%

I have managed to import my Outlook Contacts to Vista Home Premium EMail using a CSV. file. Now I need to import my Group contacts from Outlook but not sure how to do this without having to do so by typing in each one manually :-( Is there any other way to do this?

Answer:Import my Group contacts from Outlook

scottishebelle1,
Welcome.
Try copy & paste.

1 more replies
Relevance 75.03%

guys I'm stumped.

an older Dell laptop that I had kept living for a Lawyer finally croaked, suddenly. The drive is fine, the system is toast. I have a number of small bus accounts and can't recall what version of office/outlook the guy used, so that's part of the problem.
but, found the .pst file intact and saved it off. put in a new WINDOWS 8.1 laptop and of course, the lawyer hates it. Put in Office 2007, imported the old .pst file, and the mail all looks good except the most important part: NO CONTACTS.

I went back and searched the entire drive for *.wab and *.pab files, ... nada. none. [side question: how do I determine which version of Office was on the dead system?]

so... I'm presuming the Contacts should have been somehow embedded in the *.pst file, but not populated. What now??
 

Answer:Outlook contacts no-show after import.. ??

Importing a PST file is always a bad idea; what you should do is load the PST file to a save location on your disk, then open the file with Outlook.

In Outlook 2007: File | Open | Outlook Data File.

P.S. Contacts may reside on a different PST file; make sure you get all PST files from the old HD.
 

3 more replies
Relevance 75.03%

I recently got a new PC.I used the import and export option in MS Outlook so that I could transfer my emails/contacts over to my new PC.However everytime I send an email I get this error message:Your message did not reach some or all of the intended recipients. Subject: teset Sent: 01/11/2004 14:49The following recipient(s) could not be reached:'[email protected]' on 01/11/2004 14:49571 [email protected] prohibited. We do not relay - please log in to your IMAP/POP account firstDoes anyone know the solution

Answer:Import CSV contacts to MS Outlook problem

I have also noticed that the addresses in my address book have SMTP listed next to them. Should'nt they have POP3 instead?

1 more replies
Relevance 75.03%

I have just set up an extra account as above above.
Is there an easy way to import 'Contacts' apart from copying to a folder etc?
Outlooked is linked to my Google account so why aren't they imported automatically?
Thanks.

Answer:Outlook/Hotmail Import Contacts?

OK. Discovered they are all under people and have to email from there.
Will resolve.

1 more replies
Relevance 75.03%

I want to transfer the contacts from a vista pc. the vista pc uses office 2007. I want to export or transfer the contacts from that pc to a windows 8.1 pc that has outlook 2013 installed. I tried WET, but that doesn't work with 8.1 from vista. advise please.

Answer:import contacts to outlook 2013

No good exporting default? (I dont have 2013) does 2013 not use .pst files?

Export to file:
Comma separated values
.pst
Tab seperated (dos/windows)?

I use Sync PST for Outlook. Allows me to load two pst files and copy (between the two either way) only what I want to e.x. contacts/email/calendar etc

4 more replies
Relevance 74.62%

Hi,

We have a spreadsheet that keeps track of when our computer warranties expire. Would like to run a macro using the warranty expired date to create an appointment in Outlook. That part I understand. The problem is that when I go to run the macro again, it creates a duplicate appointment if the appointment already existed. Very frustrating!

This is the code below, any help would be appreciated!!!! Thanks
Sub AddToOutlook()
Dim o As Outlook.Application
Dim ai As Outlook.AppointmentItem
Dim r&, sSubject$, sBody$, dStartTime As Date, dDuration#

For r = 4 To 10

sSubject = Sheet1.Cells(r, 1).Value
sBody = Sheet1.Cells(r, 4).Value
dStartTime = Sheet1.Cells(r, 3).Value
dDuration = 30
Set o = GetObject(, "Outlook.Application")
Set ai = o.CreateItem(olAppointmentItem)
ai.Body = "Service Tag= " & sBody
ai.Subject = "Warranty Expires for Server " & sSubject
ai.Start = dStartTime
ai.Duration = dDuration
ai.Close olSave

Next r
End Sub
 

Answer:Solved: Excel Macro to Update Outlook Calendar Creates Duplicates

6 more replies
Relevance 74.21%

Installed Outlook 2016 Preview on W7 with no problems. Address Book showed Contacts. Updated W7 to W10. All contacts now show in People app, but Outlook no longer sees those contacts.

How can I migrate/export-import the W10 People contacts into Outlook 2016?

More replies
Relevance 74.21%

How do I Export then Import my inbox/mail, sent mail, & contacts (everything) from one computer to another.
 

Answer:Export/Import: Mail/Contacts From Outlook

It all depends on what e-mail program you are using. If you are using outlook then you want to copy your *.pst files and *.pab files. *.pab files is your personal address book. Hopefully you created a *.pst files, this is your personal folders. if not then you can either create one or export it. you can also export your calender too.
 

1 more replies
Relevance 74.21%

Hi,

I'm trying to import 6,000 contacts into an Outlook Contact Form I took weeks to design.

Someone please help me, and tell me if it's possible.
Thanks
Ben
 

Answer:import 6,000 contacts into an Outlook Contact Form

The form only displays the data, just import it and it should work fine if the fields in the form correspond to the ones imported.
 

1 more replies
Relevance 74.21%

I have been using Outlook 2003. I want to use WLM in Win 8. I also have a copy of WLM installed on Win 7, although I haven't been using it - just there in case I get a call from a client about it.

I created an e-mail account in my Windows 7 WLM for my POP (ISP) e-mail account (the only account).

I exported my Outlook 2003 contacts to a CSV (comma separated DOS) file. I start WLM in Win 7 (or Win 8 they both work identical) and select contacts and then "Import" Comma Separated Values CSV and select the CSV file created with Outlook 2003. WLM goes through the motions like its importing but when its finished there are no contacts imported.

In Outlook 2003, I have "Contacts" and also a sub contacts folder for a club e-mail list. I only want my regular Contacts, not the club e-mail list. However, if I select "Address book for current user" in WLM it will import the club e-mail list only.

I've been over google searches and this forum's tutorials and searches and didn't come up with anything I haven't done or tried.

Jack

Answer:Unable to Import Outlook 2003 Contacts to WLM

I logged into my hotmail acount with WLM, but that made no difference. It still will not import my Outlook 2003 contacts, although it goes through the "motions" of doing it.

1 more replies
Relevance 74.21%

Hello all, how do I IMPORT contacts into Microsofts 10 Outlook Mail???Why don't they learn to make things easier??Thanks, gep

Answer:Import contacts into Microsoft Outlook in Windows 10

"Why don't they learn to make things easier??"Easier? It couldn't be any easier, it's just a case of knowing what to do. Don't blame Microsoft for your lack of knowledge. For one thing, there are guides all over the web explaining how to do it.I can't help you beyond that because you haven't said what email client you were using before you got Win10.

3 more replies
Relevance 74.21%

I am trying to migrate from XP to Windows 10. On XP, I have a large address book in a .wab file. I couldn't find any help about how to access it in Windows 10, so I tried clicking on the .wab file. Windows 10 then said it was importing my contacts. The process took a few minutes, and I could see my contacts' names flying by. It seemed to finish normally, but now I can't find the contracts on Windows 10. After the import, there was a message saying my contacts were in something called People. I found People in the Start menu under All Apps, but when it opened, it said "No contacts were found." Please help.

Answer:How to import contacts from Outlook Express (.wab file)?

jfniss said:

I am trying to migrate from XP to Windows 10. On XP, I have a large address book in a .wab file. I couldn't find any help about how to access it in Windows 10, so I tried clicking on the .wab file. Windows 10 then said it was importing my contacts. The process took a few minutes, and I could see my contacts' names flying by. It seemed to finish normally, but now I can't find the contracts on Windows 10. After the import, there was a message saying my contacts were in something called People. I found People in the Start menu under All Apps, but when it opened, it said "No contacts were found." Please help.



Put Contacts in the Search or Run box and it should take you to the Contacts Folder in C:\Users\YOUR_NAMZE\Contacts. I usually use Windows Address Book on WinXP to Export the contacts to a .csv/Comma Separated Value file which can be use for importing into a number of E-Mail programs and some Webmail and can also be opened in a spreadsheet program such as Microsoft Excel, Corel/WordPerfect Quattro Pro, Lotus 1-2-3, LibreOffice, OpenOffice, etc.
OEClassic has a built-in address book. OE Classic - Easy to use Outlook Express replacement

3 more replies
Relevance 74.21%

I recently lost my job and was able to have a coworker burn a copy of my .pst file to cdrom. I have "easily" imported the .pst to my home PC, however, the calendar and contacts are missing from my import. Needless to say, I am dumbfounded and frustrated.

I have searched the web, Microsoft, and this forum for answers, but I can't seem to do anything to get the .pst to show the contacts. btw I'm Running W98.

Here are my questions:

1. If I copy the .pst versus Outlook export function, do I lose my contacts/calendar info?

2. How do I retrieve my contacts from the CDROM? keep in mind I have already gone through the import function AND also tried copying to the windows\local settings\application data\microsoft\outlook folder with the same result.

3. Is it possible that the pst file did NOT contain the contacts folder?

Any help is appreciated. My other data source (PDA) ran out of juice and required reset.
 

Answer:Outlook 2000 Import contacts missing!

6 more replies
Relevance 74.21%

I posted this on the Windows 7 forum but never got any responses:

I have been using Outlook 2003. I want to use WLM in Win 8. I have installed WLM on Win 8. I also have a copy of WLM installed on Win 7, although I haven't been using it - just there in case I get a call from a client about it.

I created an e-mail account in Windows 7 and 8 WLM for my POP (ISP) e-mail account (the only account).

I exported my Outlook 2003 contacts to a CSV (comma separated DOS) file. I start WLM in Win 7 (or Win 8 they both work identical) and select contacts and then "Import" Comma Separated Values CSV and select the CSV file created with Outlook 2003. WLM goes through the motions like its importing but when its finished there are no contacts imported.

In Outlook 2003, I have "Contacts" and also a sub contacts folder for a club e-mail list. I only want my regular Contacts, not the club e-mail list. However, if I select "Address book for current user" in WLM it will import the club e-mail list only.

I've been over google searches and this forum's tutorials and searches and didn't come up with anything I haven't done or tried.

Jack

More replies
Relevance 74.21%

Hi, recently have been transferred from using Outlook for email to Lotus Notes at my workplace.

None of the techy guys have come up with a good way to transfer my Outlook contacts which are local to my laptop to my local address book in Lotus Notes.

Looking for a easy way to do this and free of course!!

Any ideas?

Thanks

Answer:Import Outlook contacts to Lotus Notes

In Outlook, click File, Import Export, select export to a file, select file type - most likely Comma separated or Tab separated will work.
But you may need to do some editing of exported file Excel to comply with LotusNotes field naming conventions, sequence of fields, etc.

Perhaps this will be useful to your techy guys (who should have prepared for this when they switched you, what were they thinking of!)
http://unlisnotes.unl.edu/notesteam/notesfaq.nsf/b1178870309c168b86256a860076cf8a/9456cd3c54b2b22e86256a5c004df7a4?OpenDocument

If you describe what your techs already tried and failed to do, someone here will find an answer. Also computer system and Outlook version might help.

3 more replies
Relevance 74.21%

I have inherited a large database in Word that I need to export to an Outlook Contacts format. Can anybody give me a quicker way than cutting & pasting each invidual entry? It'd take days!Each contact is in a Word Table consisting-Surname, First Name-Position-Name of Firm-Address Line 1-Address Line 2-City-County-Postcode (in some cases more than one of these last 3 are on one line)-Country-Tel-Fax-Email-WebsiteMost grateful if anybody can help save me some hours.I'm using XP Pro (SP1) & MS Office XP - specifically Outlook 2002,Excel 2002 etcFreddie Meynell

Answer:Import Word Table into Outlook Contacts?

I don't know if a database is different, but have you tried Outlook contacts/file/ import This brings up a wizard and you can choose what you want to import.In fact it gives database as an option.

4 more replies
Relevance 74.21%

how do i import my contacts from outlook 2010 to hotmail

Answer:how do i import my contacts from outlook 2010 to hotmail

This may help.ASCII question, get an ANSI

2 more replies
Relevance 74.21%

I am trying to migrate from XP to Windows 10. On XP, I have a large address book in a .wab file. I couldn't find any help about how to access it in Windows 10, so I tried clicking on the .wab file. Windows 10 then said it was importing my contacts. The process took a few minutes, and I could see my contacts' names flying by. It seemed to finish normally, but now I can't find the contracts on Windows 10. After the import, there was a message saying my contacts were in something called People. I found People in the Start menu under All Apps, but when it opened, it said "No contacts were found." Please help.

Answer:How to import contacts from Outlook Express (.wab file)?

Originally Posted by jfniss


I am trying to migrate from XP to Windows 10. On XP, I have a large address book in a .wab file. I couldn't find any help about how to access it in Windows 10, so I tried clicking on the .wab file. Windows 10 then said it was importing my contacts. The process took a few minutes, and I could see my contacts' names flying by. It seemed to finish normally, but now I can't find the contracts on Windows 10. After the import, there was a message saying my contacts were in something called People. I found People in the Start menu under All Apps, but when it opened, it said "No contacts were found." Please help.



Put Contacts in the Search or Run box and it should take you to the Contacts Folder in C:\Users\YOUR_NAMZE\Contacts. I usually use Windows Address Book on WinXP to Export the contacts to a .csv/Comma Separated Value file which can be use for importing into a number of E-Mail programs and some Webmail and can also be opened in a spreadsheet program such as Microsoft Excel, Corel/WordPerfect Quattro Pro, Lotus 1-2-3, LibreOffice, OpenOffice, etc.
OEClassic has a built-in address book. OE Classic - Easy to use Outlook Express replacement

1 more replies
Relevance 74.21%

Hi,

I have been trying to import my Outlook 2007 contacts to my Hotmail account.

I have exported a copy of my contacts from MS Outlook 2007 to a .csv file. But when in Hotmail I am unable to import the .csv file to my Hotmail contacts list.

I have followed the online steps for doing this and still nothing.

Is Outlook 2007 compatible with Windows Live Hotmail?

And does anyone have any ideas on how to overcome this problem?

Thanks,

watty.
 

Answer:Import contacts from Outlook to Live Hotmail

10 more replies
Relevance 74.21%

I want to know if Win8 mail (Windows Mail) can import my contact list from Outlook 2010. I have Outlook 2010 installed on Win8 and I've imported my contacts and they are visible in Outlook. I want to import them into Windows Mail, if that's even possible. Thanks in advance!

More replies
Relevance 74.21%

I have a friend who, at work, has an outlook contacts folder that he wants to export and then import into outlook express. the problem he's facing is that after he's exported the contacts file and emailed it home when he tries to import it from outlook express the only option he's given to import from is a wab. any ideas on how to make this import work?
 

Answer:Import Outlook Contacts into Outlook Express

Export from Outlook as a text file, import into Outlook Express from the text file. Let me know if you need specific steps. Most of this can be done right from the File-Import/Export menus.
 

1 more replies
Relevance 73.8%

Hi,

I need help with a macro. So far the macro is operating as it should , creating MS Outlook 2010 calendar appointments using data from an excel data spreadsheet (data base). The issue I&#8217;m having is that every time the macro is run for a new entry, duplicate calendar appointments are created for the already existing data in the data base. I would like to have the macro do a search to ensure an appointment does not exist before creating one. I have read a few threads with similar problems but have had major issues incorporating the solutions to resolve the issue I&#8217;m having.

I have attached the macro in txt. format for reference.

Thanks for your help.

kkfonty
 

Answer:Solved: Excel macro updating Outlook calendar is creating duplicate appointments.

Hi
You can use this function to check if an appointment exists based on the Start Day/Time

Code:

Public Function CheckAppointment(ByVal argCheckDate As Date) As Boolean

Dim oApp As Outlook.Application
Dim oNameSpace As Outlook.Namespace
Dim oApptItem As Outlook.AppointmentItem
Dim oFolder As Outlook.MAPIFolder
Dim oMeetingoApptItem As Outlook.MeetingItem
Dim oObject As Object

On Error Resume Next
' check if Outlook is running
Set oApp = GetObject("Outlook.Application")
If Err <> 0 Then
'if not running, start it
Set oApp = CreateObject("Outlook.Application")
End If

Set oNameSpace = oApp.GetNamespace("MAPI")
Set oFolder = oNameSpace.GetDefaultFolder(olFolderCalendar)

CheckAppointment = False
For Each oObject In oFolder.Items
If oObject.Class = olAppointment Then
Set oApptItem = oObject
If oApptItem.Start = argCheckDate Then
CheckAppointment = True
End If
End If
Next oObject

Set oApp = Nothing
Set oNameSpace = Nothing
Set oApptItem = Nothing
Set oFolder = Nothing
Set oObject = Nothing

End Function

For this to work you need to have Tools/References/Microsoft Outlook xx Object Library enabled.
Then alter your macro like this

Code:

Private Sub cmdOutApt_Click()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")
' Start at row 2
r = 2
Do Until Trim(Cells(r, 1).Value) = "&q... Read more

2 more replies
Relevance 73.39%

Somewhere in the update/install process of Windows 10 (and re-installing Outlook 2007), I lost my contacts in my Outlook account. The contacts remain in my iCloud account and on my iPhone. Can someone please instruct me on how to import all the contacts back in to my desktop Outlook 2007 application?

More replies
Relevance 73.39%

I am only using a Windows 10 system because my Windows 7 computer is sketchy and I need a reliable PC to work. I have Windows 10 up and running on a very fast system with a nice big new monitor. Migrating email to this PC is absolute hell. I can get Outlook 2010 setup with contacts imported and with email accounts. I cannot get it to receive email at all even though it shows the green check marks that it has successfully checked all accounts. I searched for answers to this and could not find any. I can live with this choice if I can get it to receive email and have it show up in the inbox.

Option 2, I have Mail and Calendar set up by I cannot get emails from WLM2012 into it nor can I get my contact list into it. I tried a work arount that said use my outlook.com account to import contact list to Microsoft. I don't have an Outlook.com account.

Anyone got instructions either on how to successfully get Outlook 2010 receiving email or how to get contact lists into Mail and Calendar? Microsoft is making me so livid right now. I lose money when this crap doesn't work.

More replies
Relevance 73.39%

Somewhere in the update/install process of Windows 10 (and re-installing Outlook 2007), I lost my contacts in my Outlook account. The contacts remain in my iCloud account and on my iPhone. Can some please instruct me on how to import all the contacts back in to my desktop Outlook 2007 application?

More replies
Relevance 73.39%

I wish to import my contacts list from my gmail account to microsoft outlook 2007 on my computer. any suggestions welcome.
 

Answer:import contacts list from gmail to microsoft outlook

Export your Gmail contacts to a CSV file and import them back into Outlook.
 

1 more replies
Relevance 73.39%

Hey guys!

I have a .vcf file with 200 contacts and am looking for a way to import them to outlook 2010, outlook only reads one entry and not the rest.

So I have to use a 3rd party utility, problem is I can not find a free one, how do they ALL COST MONEY??? In software 75 or more percent of the time there is a free alternative, perhaps anyone knows of one?

Thanks
 

Answer:Import VCF With Multiple Contacts to Outlook 2010 FREE

7 more replies
Relevance 73.39%

Since i switched to outlook 2k3 from outlook express i decided to transfer my contacts from palm desktop to outlook 2k3. after about 5 minutes of manually typing them in i figured theres got to be a better way. is there any program that will transfer all the contact info to oulook for me?
 

More replies
Relevance 73.39%

I have Outlook 2013 through Office 365 and liked it until I tried to import my contacts. It's a CSV file from Windows Live Mail. Unfortunately Outlook absolutely refuses to import my contacts properly. I get everyone's names but NO EMAIL ADDRESSES! Totally and completely useless. I have tried everything and Outlook just insists on ignoring the email field. I am beginning to hate that I pay $9 for this crap. It shouldn't be hard to import contacts!!! I tried to delete all the ones that had been imported since they are useless to me and of course Outlook refuses to let me do that too. I can't find the folder anywhere and it won't let me delete all. If I sound angry I am...I am frustrated and don't have time for this. I need my COMPLETE contacts. Why is it refusing to do something so simple? When I open the CSV file in Excel everything is there including emails, so it's not me messing up or the file. Help??

Answer:Outlook 2013 Refuses to Import Contacts Correctly

Here is a check-list for importing into Outlook 2013:
Import contacts - Outlook - Office.com

Hopefully something there will help.

1 more replies
Relevance 73.39%

I replaced my hard drive and made a backup of the old drive contents before hand.

I installed a new version of Outlook (2007) and have downloaded all my old emails off my web server - so my inbox is working perfectly. I want to add my contacts / calendar, etc, but I am afraid if I import or "add" my old PST file I may get duplicates in my email inbox. How can I prevent this??

Thanks!

Answer:Import contacts & calendar in Outlook after I already restored inbox?

You should just be able to select what you want imported.

3 more replies
Relevance 73.39%

I can not import my old contacts from Microsoft Outlook, to Microsoft Windows Live Mail. I open Live Mail, then go to Contacts page, then open "FILE" , then open "IMPORT", then try to select one of the types of files, such as CSV or Outlook, but NOINE of the file types are highlited, they are all grey, and you can NOT click on any of them.

Any ideas what is wrong??

Answer:Can NOT import contacts from Outlook to Windows Live Mail !

Forget even trying that. The closest you could import if possible would be from Vista's version of Windows Mail not from Outlook or Outlook Express. In WLM you simply have to manually add most of your usual contacts in or use the add name to contacts list when going to send the first mail out to someone. That can save time if you have a good number on the list.

3 more replies
Relevance 73.39%

Hi,
Today, I subscribed to two newsletters, and attached to both email confirmations I received, were .vcf (vCard) files. I never got those attachments before when subscribing to any newsletter. My Hotmail email program was recently updated to Outlook. I have Windows 7.

When I click on the vCard files, a Windows Contacts "Properties" box opens, containing basic contact information (email, name, name of company).

- Since they are .vcf and not .csv or .txt files, can you tell me how to import these contacts to my Outlook [live, previously Hotmail] contacts.
- Also, can you tell me whether these .vcf cards I receive attached to email subscription confirmations are a feature of the new Outlook interface?

Thanks for your anticipated help!

Answer:How to use .vcf files - How can I import .vcf info to Outlook (live) contacts

Hi please see these How to use the vCard feature in Outlook Send and save contacts as vCards (.vcf files) - Outlook - Office.com

5 more replies
Relevance 73.39%

Got an Acer with Vista & Windows Mail -- my old Dell had XP Pro and Outlook. I had no problem backingup Outlook to a Seagate external and connecting it to the Acer .. but Windows Mail does not seem to import Outlook .. only Outlook Express. My wife's computer has Outlook Express .. so I thought I would email her my backup file and import it to Outlook Express and then back that up and email it back to me and import that to W Mail ... but the email will not transmit with the backup file attached "not enough memory" the backup is 1.5m.

My next strategy is to go into my old computer and edit folders or do a few partial backups so I get a small enough file(s) to attach to email.

Any other suggestions ...

thanks

More replies
Relevance 72.57%

Still not liking Mail and Contacts. Is anyone using Outlook 2016 for email on Windows 10 without issue? Are you able to import mail and contacts from WLM into Outlook OK?

More replies
Relevance 72.16%

Hello all:

I am having problems importing a customer's address book from Outlook Express (XP) to Windows Live Mail (7). The addresses are being (mostly) split into each individual entry: some are just physical addresses, some email addresses, some phone numbers.

I searched on your forum here and did not find the answer to the problem (indeed, I didn't see anyone else having it!) so I thought I'd ask to see if you've heard of anything like this. I would appreciate greatly any response and I apologize if this is something that has already been posted.

Thanks,
Jacob

Edit: I've found that not only are some emails being split from their contact information, but there are 3 contact entries for every phone or phone/email contact. Help?

Answer:Outlook Express to Live Mail import problem: split contacts

  
Quote: Originally Posted by gn0sis


...I am having problems importing a customer's address book...

Edit: I've found that not only are some emails being split from their contact information, but there are 3 contact entries for every phone or phone/email contact.


The first part says the problem is with importing the address book but the Edit part says emails are being split. Is the problem with address book or emails?

6 more replies
Relevance 68.06%

Excel XP
Trying to import a spreadsheet with lots of email addresses (Import | Export) into
a contacts folder, error:
An error has occurred in the Microsoft translator while getting the contents of a file system
The Microsoft Excel file “C:\...xls has no named ranges. Use Microsoft Excel to name the range of data you want to import.

Note this has multiple sheets, if I copy the one sheet into a new file and then try the import then I receive error:
An error has occurred in the Microsoft translator while getting the contents of a file system
The File “C:\..xls was not recognised. The Microsoft Excel translator was unable to recognise this file. It could be the wrong file, a version of the file type which is not supported by this translator, or the file might be corrupt

I have saved the “one spreadsheet” as a txt file and tried to import this into contacts, but receive error saying that Microsoft outlook translator is not installed, when inserting my disc doe not seem to find it? (when going into control panel to see options Add | Remove in Microsoft Office I don’t see it here either?)
 

Answer:Excel XP Trying to import a spreadsheet into Outlook

Well.. managed to run this install (translator) from disc (kinda hung for a while?) anyhow I saved the spreadsheet as a csv file brought into outlook all ok (mapped the fields) all look good in the contacts folder. The reason for all this was to create a DIS list (80 email accounts) Now when going to File - New Dis List and selecting the members (button) and selecting the drop down box for my new contacts, which are all showing and clicking add all I see being moved accross to the other side is the , or ; symbol??? this is for all the contacts?
 

1 more replies
Relevance 67.24%

Am trying to export contacts from laptop (Windows XP) using Microsoft Office to laptop (Windows Vista) using Windows Mail. Actually, I would like to just copy the contacts so they'd be on both computers. Need step by step easy directions to do this -- and thanks.
 

Answer:Solved: Export/Import Contacts: Microsoft Office to Windows Mail

10 more replies
Relevance 67.24%

Help please. Trying to import names and e mail addresses from am Excel spread sheet to my Outlook Contacts. I know the process File<Import <Excel find file etc however when I get to the stage I get a warning ' Cannot import Excel Translator not installed. Would you like to install it now?. Select Yes system searches for the files and then informs me they are not available.

I have XP Home and MS Office Pro 2003 with full package. I have tried checking Installed components from Add remove Programmes and gone round innumerable circles.

Searches on the MS sites have not revealed any answers either.

Is there an easy fix for this can anyone help please. Hope I am posting in the right area - could not see anything specific about Office or Excel Translators.
Thanks
David
 

More replies
Relevance 67.24%

when i import data from excel to outlook calendar it imports it only as an appoitment. i wanted to import it as a meeting request. while the mapping fields in the import / export option of outlook show the 'required attendees' field which has been adequately filled in by me the same does not reflect after i check the imported record
 

More replies
Relevance 66.42%

Hi Folks,
I found the following thread:
http://forums.techguy.org/business-applications/541487-merge-excel-dates-into-outlook.html

At best I am capable of copy pasting code - and I guess I'm slightly failing at that even.
I simply wish to be able to update an excel with dates of future tasks, in a particular column, and have these automatically appear as tasks on a particular date in calendar. Ideally column a (name of task) and column F (date in format 1.1.1.) would both be incorporated into the task, which would be allocated to date X in calendar.
I am using Outlook version 14.0.4734.1000

I have associated with Outlook 14.0 object library already. This is what i have so far (the first line is incorrect, presumably amongst others):
Code:

Sub ExportAppointmentsToOutlook(14.0)
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "F").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = ... Read more

More replies
Relevance 66.42%

Hey guys, I had some great assistance from computerman29642 earlier on this macro. It works perfectly on my own calendar; however, I need to target a specific shared calendar. Hopefully it could be user imput by a msg box. I am struggling to find information on how to do this.

The first thread was this
http://forums.techguy.org/business-applications/835748-solved-excel-macro-outlook-calendar.html

So, as for now the example works. But before it writes to the calendar I want a msg box pops up asking for the desired calendar(Sometimes more than one word), and then target that calendar and write the data. A simple little box that confirms or denies progress (I am pretty sure I can figure that one out) Any suggestions or directions where I can learn more fire away please. Ill attach a copy of my test again.
 

Answer:Excel to Outlook Macro

16 more replies
Relevance 66.01%

I am trying to create a code that will autofilter data on an Excel worksheet. The code works fine to filter the data, but it does not hide the AutoFilter Arrows.

Below is the code I am using. What (if anything) is wrong with the code below?
Code:

ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>", Visibledropdown:=False
 

Answer:Solved: Excel 2007 Macro -> Hide Excel AutoFilter Arrows

I noticed that the code above (in Post #1) that the AutoFilter Arrows were beinf truned off on Field 2, but none of the others.

I have played around, and done some research to come up with the code below:
Code:

Dim c As Range

For Each c In ActiveSheet.Range("A1:D1")
ActiveSheet.Range("A1:D500").AutoFilter Field:=2, Criteria1:="<>"
c.AutoFilter Field:=c.Column, Visibledropdown:=False
Next

Does anyone have a better solution?
 

1 more replies
Relevance 66.01%

I’m using Windows 7 and I used a macro which worked totally fine under Excel 2003. Now, under Excel 2007 it does not run anymore but displays the following error message:

"Run-time error '445':
Object doesn't support this action.

The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored.

When I click on "Debug" the Visual Basic Editor highlights the row which says: Set FilSrch = Application.FileSearch

Can you help me with this? I've searched for a solution for a long time but could not find anything which worked.

The following is the start of the macro code:

Sub UpdateTable()
Dim X As Range, I As Integer, J As Integer, RecNo As Integer, CopyVal As Variant
Dim SourceBk As Worksheet, DestBk As Worksheet, StartRow As Integer, IndRange As Range
Dim ServRange As Range, SrcOpen As Boolean, SourceName As String
Dim FilSrch As Object, MyFilArray() As String

'MsgBox "This function not available in this version.", vbInformation, "Function Not Available"
'Exit Sub
'Sheets("LookUp").[a12] = Now
With Application
.ScreenUpdating = False
.StatusBar = "Counting source files ..."
End With
Set FilSrch = Application.FileSearch
With FilSrch
.NewSearch
.LookIn = ActiveWorkbook.Path
.FileType = msoFileTypeExcelWorkbooks
If .Execute > 0 Then
ReDim MyFilArray(.FoundFiles.Count)
For I = 1 ... Read more

Answer:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

7 more replies
Relevance 66.01%

Hello again,

I have a word doc that has a form in it. The form may have any number of fields (boxes) to type text answers into, or be a drop down list to select an answer from. I need an excel macro that extracts all data from the form, but with every five fields starting a new row in excel. So all data from the form will appear within 5 columns in an excel spreadsheet.

field 1 field 2 field 3 field 4 field 5
field 6 field 7 field 8 field 9 field 10
etc

Is that possible? I have had no luck to do it myself.

Sample form attached, thank you
____________________________
 

Answer:Solved: Excel macro to extract Word form data into Excel

7 more replies
Relevance 66.01%

Dear forum,

I need to come up with a way to import calender data from excel. My office is trying to coordinate calender data from other companies which they then can have the option to integrate into their own calenders. I have been googling around and the process seems, at first sight, to be way to laborious. Is there a way to (through initial programming or other ways) to create an excel sheet with data where a people can, with a click of a button, import the calender data in the targeted coloumn into their own outlook calender - without downloading any additional software? Non-clouding solutions are prefered.

Thank you in advance

Answer:How to import excel calender data into outlook - with a click of a button

Outlook can only import .ics & .vcs files for calendars, which excel cannot export.
Third party software is looking like your last resort.

1 more replies
Relevance 65.6%

This guide tells how to import contacts into the Windows Contacts folder:

Import, export, or change the format for contacts.

But "Import" is not available anywhere on the toolbar (running wab.exe). Am I missing something?

Any other ideas on how to import (or sync) Outlook 2010 contacts to Windows Contacts?

Answer:Import contacts into Windows Contacts folder

If you open the contacts folder in Explorer there is an import button on the task bar.

1 more replies
Relevance 65.6%

Hi,

I am an extremely basic user who has managed to get a basic macro together through multiple web searches and am now stuck...

I have dates entered into the following columns in excel: 14,15,16,26,27,28

I have managed to make the macro create appointments for 14,15,16 but not the rest. Also, every time i run the macro it creates a new appointment regardless if one already exists. I saw on this forum about adding a word to another column which the macro searches for and if found doesnt create a new appointment - or something to that extent. Here is what i have:

Sub POATEST()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")

' Start at row 7
r = 7

Do Until Trim(Cells(r, 1).Value) = ""
For Each cell In Range(Cells(r, 14), Cells(r, 16))
If cell.Value <> "" Or 0 Then

' Create the AppointmentItem
Set myApt = myOutlook.createitem(1)

' Set the appointment properties
myApt.Subject = Cells(r, 1).Value & " " & "Update Due"
myApt.Start = cell.Value
myApt.categories = "Yellow Category"
myApt.ReminderSet = True
myApt.Body = "blah blah blah"
myApt.Save
End If
Next cell
r = r + 1
Loop
End Sub

Please can someone assist by:
1. making it apply for all the columns originally mentioned
2. making it search if an appointment for that item (ie that row) exists - if not, create appt, if so, do not create appt and insert "Yes" in column 29

Thank... Read more

Answer:Excel Macro - Add Appointment To Outlook

HI,

Check this code you may be able to modify it.
Have not used it in a long time but....

Code:

Sub AddAppointmentsToCalendar()
Dim OLF As Outlook.MAPIFolder, objItem As Outlook.AppointmentItem
Dim i As Long, lngItemCount As Long, r As Long
On Error Resume Next
Set OLF = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderCalendar)
On Error GoTo 0
If OLF Is Nothing Then Exit Sub

Application.StatusBar = "Adding appointments to Outlook..."
With wsSheet1
.Activate
r = Range("NewAppointments").Row + 1
Do While Len(Range("A" & r).Formula) > 0
On Error Resume Next
Set objItem = OLF.Items.Add(olAppointmentItem)
On Error GoTo 0
If Not objItem Is Nothing Then
With objItem
.Start = Range("A" & r).Value
.End = Range("B" & r).Value
.Subject = Range("C" & r).Value
.Body = Range("D" & r).Value
.Categories = Range("E" & r).Value
.ReminderSet = False
.Save
End With
Set objItem = Nothing
End If
r = r + 1
Loop
End With
Application.StatusBar = False
Sheets("Appointments").Select
Range(&... Read more

1 more replies
Relevance 65.6%

How can I import an excel database of contacts into Outlook and then from Outlook into Agent Office?

Answer:Excel file to Outlook Contacts

In outlook, go to

File ->import & Export. Choose Another program of file. You will get list of file types and Microsoft Excel will be there. Use that to import sheet to Outlook.

In case you have an older version of Outlook or a version conflict (Shouldn't be as both are part of MS-Office), you can always export the excel file to csv and import it in outlook. In-fact, you can import the csv to most email clients.

Sorry cannot help you on Agent Office as never worked on that.

1 more replies
Relevance 65.6%

How do i export a public contact list into excel. I can export the private contacts with no problem but there is no choice for the public folder nor does it give you a browse option. If there is a way to fix this or get around it please let me know
 

Answer:exporting contacts outlook xp to excel xp

As I recall...

You must first download the global address list to your PC. Do this (somehow) through Tools-Services and choose something like "make available offline" or something like that.
 

3 more replies
Relevance 65.6%

Each time I try and do this it comes up with the error message

An error has occurred in the Microsoft Excel translator while getting the contents of a file system.

The Microsoft Excel file..........has no named ranges. Use Microsoft Excel to name the range of data you want to import.

I do not know how to do this, can someone help?

Thanks.
Miadelcara
 

Answer:exporting excel to outlook contacts

6 more replies
Relevance 64.78%

Hi guys,

I have been on the lookout for a macro that will compare 2 worksheets within MS Excel and output the differences on a third sheet.

I am being directed to the URL below but cannot for the life of me work out how to implement this:

http://exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html

There are two snippets of code which I will include here for convenience but not sure whether these should be pasted into Workbook Code (i.e. right-clicking Excel icon left of "File" - top-left), Worksheet Code (i.e. right-clicking worksheet tab) or inserting a new Module - or some other method. Is there anyone here that could guide me to how to implement this code?

Quote from webpage - "With the macro below it is possible to compare the content of two worksheets.
The result is displayed in a new workbook listing all cell differences. "

Code:
Sub CompareWorksheets(ws1 As Worksheet, ws2 As Worksheet)
Dim r As Long, c As Integer
Dim lr1 As Long, lr2 As Long, lc1 As Integer, lc2 As Integer
Dim maxR As Long, maxC As Integer, cf1 As String, cf2 As String
Dim rptWB As Workbook, DiffCount As Long
Application.ScreenUpdating = False
Application.StatusBar = "Creating the report..."
Set rptWB = Workbooks.Add
Application.DisplayAlerts = False
While Worksheets.Count > 1
Worksheets(2).Delete
Wend
Application.DisplayAlerts = True
With ws1.UsedRange
lr1 = .Rows.Count
lc1 = .Column... Read more

Answer:Solved: How to use this Macro in MS Excel (compare excel worksheets)

Apologies... I have sorted this... For those that might be looking at this for help here's what I missed:

These are both Sub's that should be created as a Module - both in the same module. I am just comparing worksheets within the Active Worksheet so just removed:

' compare two different worksheets in two different workbooks
CompareWorksheets ActiveWorkbook.Worksheets("Sheet1"), _
Workbooks("WorkBookName.xls").Worksheets("Sheet2")
Click to expand...

I was then able to run this from Macro's. All sorted.

Apologies again
 

1 more replies
Relevance 64.78%

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.
 

More replies
Relevance 64.78%

Hi all,

I'm looking to create an Excel document and I need to put cells with dates in that are linked to outlook calendar reminders.

I.e I need a macro that when I click the link it sets the reminder on outlook for the date allocated in the cell.

could anyone please help me with this as i have never created a macro and would greatly appreciate any help you could give me.

Thanks

More replies
Relevance 64.78%

I need a macro that will 1) create a new outlook folder, then 2) create new Outlook distribution lists from data in an Excel sheet.

The Excel sheet has columns:
A - ID
B - DEPARTMENT_DESC
C - STUDENT_LEVEL_DESC
D - MAJOR_DESC
E - PROGRAM_DESC
F - EMAIL_ADDRESS
G - LAST_NAME
H - FIRST_NAME

The first entry begins in row 2 with row 1 being the column title.

I need a new distribution list to be created for each department (column B) and each student level (column C). (Column B will only ever be one of 6 values, column C will only ever be one of 2 values. Therefore, the macro should create 8 distribution lists.)

I have looked at threads similar to this question but I can't seem to get anything working.
 

Answer:Macro from Excel to New Outlook Distribution List

I saw something you might could work with here: http://www.helenfeddema.com/CodeSamples.htm
scroll down for sample 61. I haven't used it but marked it one day. I'm assuming your wanting to make local distb list? Not in AD.
 

1 more replies
Relevance 64.78%

Hi

This is a tuffy........

I want a macro so that when i type a message into a cell it will put it into outlook as a reminder, or even a simple macro button that opens outlook in the scheduler.

Any ideas?

Thanks
 

Answer:Excel macro links to Outlook Reminder

Try this link.
 

1 more replies
Relevance 64.78%

I use a pda and have all my contacts and appointments on it and also syncronised on outlook on my desktop, I have now got a full customer listing in excel format and could do with a way of converting it into my contacts database.

Answer:can I convert excel data into outlook contacts ?

one for you VoG? regards.

10 more replies
Relevance 64.78%

I want to export all my contacts in Outlook 2010 to Excel. Suggestions?

Why: I am fairly sure my outlook file is corrupt. I cannot see my contacts in category view as I did when I had the same program in WinXP (I upgraded to Win7.) After 8 months, the first category appeared in the Current View box, but no others. I can see the categories in list view. I thought I would find some errors when I export them to a file I can edit.

Alternatively, is there any way to view the main Outlook file, (.pst?) in an external editor?

Answer:How to export Outlook 2010 contacts to Excel?

Sorry folks, found the export under "open."

2 more replies