Computer Support Forum

Macro from Excel to New Outlook Distribution List

Question: Macro from Excel to New Outlook Distribution List

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.

Relevance 100%
Preferred Solution: Macro from Excel to New Outlook Distribution List

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

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 96.35%

Hi,

I have a shared distribution list in Outlook. Those people included are selected from a global address book. I have a list of people I need to add currently in excel (not their email addresses, just their names as they would appear in the global address book).

Outlook will only let me add one name at a time, and I have to add it manually (it won't even let me cut and paste then Ctrl+K).

Is there any way to add all of these new people in one go, or will i just have to trudge through manually?

Many thanks

Dave
 

Answer:Adding to an existing outlook distribution list from excel

6 more replies
Relevance 84.05%

I've used the following from Rollin_Again, but the macro stops at the first bit of code. My Excel Spreadsheet has only the three columns, first name, last name, and email, but I can;t get past Public Sub....

I sure need to do this, would evveen buy software if available.

Help???

Public Sub DistributionList()

Dim objOutlook As New Outlook.Application
Dim objNameSpace As Outlook.Namespace
Dim objDistList As Outlook.DistListItem
Dim objMail As Outlook.MailItem
Dim objRecipients As Outlook.Recipients
Set objNameSpace = objOutlook.GetNamespace("MAPI")
Set objDistList = objOutlook.CreateItem(olDistributionListItem)
Set objMail = objOutlook.CreateItem(olMailItem)
Set objRecipients = objMail.Recipients
objDistList.DLName = InputBox("Enter name of Distribution List")

For i = 1 To Cells(ActiveSheet.Rows.Count, 1).End(xlUp).Row
objRecipients.Add (Range("C" & i).Value)
Next i

objDistList.AddMembers objRecipients
objDistList.Display
objRecipients.ResolveAll

Set objOutlook = Nothing
Set objNameSpace = Nothing
Set objDistList = Nothing
Set objMail = Nothing
Set objRecipients = Nothing

End Sub

 

Answer:Macro Excel to Distribution in Outllok

By the way I'm on Vista 32 bit, 4GB RAM
 

1 more replies
Relevance 84.05%

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 81.18%

I need to find out how to export ONLY the contact names and email addresses from a specific outlook distribution list into excel.Is there a way to do this WITHOUT exporting all of the contacts? Any help is appreciated!

Answer:How to export a distribution list to Excel

I don't know if there is an Outlook-specific process to do this but here is what just worked for me:1 - Open the Distribution List2 - Print it to a PDF (You can download free PDF creators from various websites - CutePDF & PDFCamp are just 2 examples. They install as "printers" on your system. When you "print" to them, they create a PDF file.)3 - Copy all of the text from the PDF and paste it into Excel.4 - In my case, it put both the names and the email addresses in Column A.5 - Use Data...Text to Columns...Delimited...Space to leave the names in Column A and move the email addresses to Column B.Hope that helps.

3 more replies
Relevance 81.18%

I am looking for a way to make a email distribution list in excel. The information in the sheets is a follows. Name, Group, and up to 10 email addresses for each person. what I need to do is have 1 button to click on and have an email composed with all the email addresses on that sheet put into an email. I have found a post on the forums that does almost this but I don't know how to change it to what I need. I have attached it so you can look at it.
 

Answer:Excel email distribution list

11 more replies
Relevance 81.18%

Hello,

I have an Excell sheet that I have entered many email addresses into as well as the persons name and area they reside in - all in different columns. I need to be able to send a mass email to all the addresses and then also be able to filter the addresses by the different areas the people live in. Example- send all the area 1 people an email. I understand I can copy the addresses into Text and paste them into the BCC of my email; however, I want to be able to use the Excel sheet to filter the addresses down and just clik on something and have the addresses appear in my Outlook BCC email area. I am trying to avoid having to create Text lists every time I want to send out emails to multiple addresses. How best can I use my Excell sheet as a one stop Emailer?? I have a basic understanding of Excel and any help and your patience - is appreciated.

thank you
 

Answer:Excel email distribution list

16 more replies
Relevance 81.18%

I have a rather long list of email addresses in an excel spreadsheet. Is there some simple and quick technique to pull or import these into Outlook?
I am being lazy I suppose.
 

Answer:Creating a distribution list from excel

Save your spreadsheet XLS file as plain-text file with TAB(or comma or semi-colon) delimiters, then use it as a source file.
 

1 more replies
Relevance 81.18%

Hi, I need some help from you guys to clarify some issues in Outlook 2003.
I have added some contacts, catagorised them, eg. Colleagues, Friends, Family. Now that I want to send e-mails to all my colleagues.

I opened the "New Message to Contact" then clicked on the "To" button and waited to see the list of my contacts show up, however, it shows a dialog box saying:

"The address list could not be displayed (not including the smiley ofcourse). The contacts folder associated with this address list could not be opened; it may have been moved or deleted... blah blah blah"

Knowing that nothing is deleted or damaged, I ignored it, and tried to create distribution list, gave it a name and clicked on "Select Members" then the same messsage box appears (as above).

I've been told that it uses contacts in the "Address Book" of Windows (to my knowledge, when you back up Outlook 2003 .pst files, these entried aren't backup too) and I would liek to keep my contacts in one place, in the .pst that is, so does this mean, to have distribution list (mailing list) to mass mail to my colleagues, I must use Windows's Address Book ? This has also been an issue with my clients who use Outlook.

How does all these contacts thingy work ? I would like to get my head around it, gimme a hand guys
 

Answer:Outlook Mailing-List / Distribution List

You need to set up Outlook to use your Contacts as an address book. Go to Tols > Options and click the Mail Setup tab and select the Mail Options button. Select the radio button for View or Change Existing directories or Address books. Click next and see if there is an entry for Outlook Address book and if it isn't there add it. If it is there it may be corrupted thus your message so delete it and recreate it. Once it is in there open your contacts folder and in the Outlook bar on the left right click on the contact item and select properties. select the Outlook Address Book tab and put a check in "Show this Folder as an Address Book" Should work after that.
 

2 more replies
Relevance 79.13%

Hi,

i was trying yesterday to find out for several hours how to create in Outlook 2000 distribution list with names chosen upon one, specific outlook "category"... I know how to create distribution list itself... I know how to make outlook to show me all names in my address book with this specific category... BUT, how mix it together and in the end receive distribution list with all names of this category included, I cant do it, i am too big idiot comparing to MS coders.... ((

Yours, but very sad and disappointed about my mental possibilities

Jazzek
 

Answer:Outlook 2K: How to create distribution list based upon certain outlook category???

Hi Jazzek -- I just did this, with the help of Russ Valentine at the MS Outlook newsgroups. Here are the instructions he sent me (and I used successfully):

"Change the Contacts Folder View to Categories. Right click and drag the
desired Category to
a newly created sub folder then choose Copy. Make sure the new sub folder
has been enabled as an email address book by right clicking on it and
choosing Properties and Outlook Address Book Tab and checking the box to
enable
as email address book. Create your Distribution List but make sure the Show
Names drop down field points to the new sub folder then shift select all the
contacts and voila."

I hate cruising the MS Newsgroups, as the interface is so weird and searching the archives is a total pain on their site (and incomplete in my newsreader), but I DO occasionally get help there.

Hope this helps. If I've misunderstood your problem, post me back.
Carol
 

1 more replies
Relevance 79.13%

Hi, how can i convert an Access Form into a webpage where i need users input using the webpage in our company intranet.
 

Answer:Outlook Distribution List

The title of your post is Outlook Distribution List.

I'm not sure what it has to do with Access.

Depending on the version of Access, you should have "Pages" available. Check out the help file on Data Access Pages.
 

1 more replies
Relevance 79.13%

Can anyone tell me If I send out a news letter to say 20 people, and one of the recipients clicks "Reply" does everybody on the ditribution list get that response.

Answer:Outlook distribution list

Only if the recipient "accidentally" clicks on reply to all. You could obviate this problem by putting all your recipients into the BCC box, they will then not be able to see each other's e-mail address.

2 more replies
Relevance 79.13%

How do I print members' names in a distribution list from an address book in Outlook 2003?

More replies
Relevance 79.13%

Hi.

I know how to create a distribution list. I want to know how I can keep each individual private from each other on that distribution list.

It wouldn't look to professional to have a bunch of individuals see they are part of a marketing mailing.

Any suggestions??

Thanks.
 

Answer:Outlook distribution list

16 more replies
Relevance 79.13%

Hi
I had a look at a previous thread but i didn't understand it!!
I am trying to copy a DL that someone has sent me to my contacts. I need really simple instructions....I undertand that the format it has been sent in has some impact but i can't work out how to see the format...it was sent to me in an email and opens up as a distribution list in outlook
pls be patient and help me!!
chrissie
 

More replies
Relevance 79.13%

I'm trying to build a distribution list in outlook 2000 and when I send it I don't want it to disply every single name in the list. I just want it to show:

To: [email protected]
From [email protected]

That way they don't see the 50 other people I'm sending it to. Is this even the best way to do this? It's important that when they respond it comes back to me. TIA!
 

Answer:Outlook Distribution list

Create your Group just as you normally would.

If you just use the BCC function, no one will see the others addresses. When you create your email, add your group to the BCC: field instead of the regular To: field.

When they receive the email it reads "Undisclosed Recipient" in the To: field and your display name in the From: field. The reply function will send it to whatever address you sent it from.

I think that addresses all of your issues. HTH.
 

2 more replies
Relevance 78.72%

I am currently receiving 27 reports that I have to compile into a master list on a daily basis. I tried creating an .bat file using notes to copy these lists into a master list but it is not working (please see code below).

copy *.xls importfile.xls

When I run this file it only copies one of the 27 files. Is there a way that I can run a macro to do this for me. I am really not familiar with macro's and am hoping that someone can point me in the right direction.

The files in question are all identical except that each file pertains to a different Div in our company.
Thanks,

 

Answer:Solved: Using a macro to copy several excel list into one master list

7 more replies
Relevance 78.31%

I have searched and found a slight answer to this question (which seems to be "no way"), and have searched many other forums for information, however . . . thought I'd post it here too to see if there is any new info on this problem.

In Outlook Express, I can view .any single contact's membership in various groups/distribution lists on the "other" tab . However, in OE I cannot sort or view this information in very meaningful ways, nor view those various memberships in any of the main contact pane views.

In Outlook 2000, by sharing the OE address book, I can view and sort much contact information in more meaningful ways, but there seems to be NO way to see how many distribution lists/groups a single contact belongs to.

SURELY SURELY SURELY there must be a code or patch to create a field to show this info in Outlook 2000! If anyone has a hint -- even a book to refer me to that I would wade through (and I would), please repond.

Thanks for the help
dukster
 

Answer:Outlook Express Groups to Outlook Distribution LIst

7 more replies
Relevance 78.31%

Does anyone know how I can set up a distribution list in Outlook 2002 so that recipients can see only the name of the distribution list in the TO box and not the names of the list members? I think that this is a new Outlook 2002 feature.
 

Answer:Outlook 2002 Distribution List

Generally, everyone puts "themselves" in the TO box, and the distribution list goes into the BCC.
 

3 more replies
Relevance 78.31%

Is there anyway to merge my outlook's memory to a contact list?

What I mean is like, I have entered in so many e-mails manually not knowing that in the future I would need them to be all in a contact list. But they are still stored some how, as in when I begin to type the first 2 letters or numbers of the e-mail address, Outlook automatically knows which one it is and inputs the rest of the address for me.

Is there anyway to get those moved into an address book / contact list of some sort?

If not, no worries.

Additionally, wether I get these imported to a contact list by some feature or if I have to manually input each e-mail address, is there a way I can send a mass e-mail to all of them at the same time, but without anyone knowing that I sent it to 100 other people? Is there a way to hide everyon else's e-mail addresses?
 

Answer:Outlook 2003 Distribution List Help

You might give this utility a try. See what type of file it creates, and then see if you can import that into your Contacts.

http://software.techrepublic.com.com/download.aspx?docid=283533

I'm not aware of a feature in Outlook that allows sending to all Contacts. Most people use Distribution Lists with Outlook. To send a message to people without knowing who else received it, enter the addresses into the BCC (blind carbon copy) field.
 

2 more replies
Relevance 78.31%

Hello!
I am using Outlook 2003 and have a problem with editing Distribution lists.
Two of them that I have created work fine. Right click>properties>add and remove users etc appears.
With one list, however, there is a problem - Right click and properties gives only general tab with the members and no option to add/remove etc.
I have tried removing Outlook contacts and adding them again, also creating new Outlook profile. No help. Outlook is not using cached mode at the moment.
Any help would be greatly appreciated.
Thank you all in advance,

Maardsha

 

Answer:Outlook Distribution list problem.

Are you on an Exchange Server?
 

3 more replies
Relevance 78.31%

Is it possible to print out a distribution list (all the email addresses) in Outlook XP?
 

More replies
Relevance 78.31%

How can I create a distribution list based on senders of messages in a particular folder? I have sent out an e-mail with voting buttons Yes & No, and want to be able to create a distribution list of all the "Yes" people without having to manually add them one by one...

Any suggestions?
 

Answer:Outlook: creating a distribution list

Create a Contacts folder and drag those emails into the contacts folder...I think.

That's how I keep my newsletter subscribers. I drag the received email into that folder, and its a contacts folder.
 

1 more replies
Relevance 78.31%

Thanks in advance for any replies.

I'm using OE 5.5 to send an announcement to a large group of business associates & friends. I'd like to be able to send this announcement email without the recipients seeing a long list of names & email addresses in the "To" subject line of the email when they receive it. Is there any way under OE 5.5 to send an email without the email itself showing all the names of the recipients in the "To" field? In other email clients that I've used in the past, you can create a distribution list, and tell the email client program to suppress the showing of individual names on the list, and just show in the "To" subject line, for example, "My Business Associates & Friends". Have not been able to determine if OE 5.5 can do this. Thanks.

Tony
 

Answer:Outlook Express 5.5 Distribution List

Open your Address Book and create a new group using "My Business Associates & Friends" as the name of the group. Select the recipients for the group. In the box at the bottom of the screen for Name: paste "My Business Associates & Friends" again and insert your email address in the E-Mail: field.

When you are ready to send your message, click on the To: field, select the Contact "My Business Associates & Friends" and for the Bcc: field, select the Group "My Business Associates & Friends".

Your recipients will see only your email address if they double click on the "My Business Associates & Friends" title.

You will receive at least one copy of your message.
 

1 more replies
Relevance 78.31%

I recently bought a new computer with Windows XP and Office 2002.

I successfully transfered data for contact folders. When creating distribution lists, I noticed that in the distribution list, the "NAME" column listed the e-mail addresses as did the "EMAIL ADDRESS COLUMN"

Yet the fields in my contact address books are all correctly filled in (just as I had in Outlook 98)

Now the distribution list works, but it is annoying to not be able to see names so I can keep the list updated. A number of the e-mail addresses are difficult to decipher.

I have gone to Microsoft - do details on sorting the fields within the distribution list. Microsoft won't talk to me because software was OEM with Dell. Dell says they don't support software. No documentation I have looked for addresses this issue. It is frustrating. Anyone with a solution??
Thanks
 

Answer:Help-outlook 2002 distribution list

JoeE.

In the words of a famous politician "I feel your pain".

I think Outlook Express was wheeey easier. I dunno how I got roped into Outlook other than its got some god features like calendar that you dont have to revert to another calender for (eg everything is supoededly in one place)

Also I think its bogus how MS shifts the blame to others. MS made teh softwere the dealer only sells it. If you blow up a tire on your GM car, you can still talk to Firestone about it.

In business, obviously large companies only want to sell more stuff they realise that fixing stuff is generally costing them money (unless you pay for it).

Anyway, I have a office Im associated with. Most people dont go there so we all use outlook.

In the "contacts area" under "actions" you can see "create new distribution list:

Under select members you should be able to highlight the ones you want in that list.

Then, when you want to send to those, you type the group name and it send to all of them.

To review them you can go back to the original box and add, delelte, or modify them.

Lemme know if that helps.

best,
 

2 more replies
Relevance 78.31%

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.
 

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

1 more replies
Relevance 78.31%

I use Outlook 2003 and have created a distribution list for 860 recipients utilizing excel. The distribution list works fine, however when it lists the members of the list it has the email in both the Name and E-mail columns. This makes it very difficult for me to determine which member it is that the email refers to.

It currently looks something like this
Name Email
[email protected] [email protected]

I want it to look like this:
Name Email
Smith, Andrew [email protected]

Can this be done automatically without me having to go in manually to every contact and edit the "Display As" field?

Thanks,
Barbara
 

More replies
Relevance 78.31%

My boss asked me to put together a mailing list of clients to whom we could send various newsletters etc, so I created a distribution list in Outlook 2000. She (my boss) added, however, that she wanted the email to include an option which allowed the recipients to "opt out," or remove themselves from the list. I have no idea how to even start with this part of the project and could use a little guidance either in actually setting up the e-mail, or in finding someone who could tell me how. Any input would be greatly appreciated!
 

Answer:Solved: Outlook Distribution list

bump
 

3 more replies
Relevance 78.31%

I am having a distribution list problem and I will try and explain as best I can.

It started out as a shared distribution list(called UBB), and normally when you would go to add it to an email where most distribution lists or contacts show up with the name and a line under it (ex: UBB), and you can click on that contact/list and open up their information.
Well whenever I add UBB, it does not link to the distribution list and in the "To:" text box, it only shows up as UBB, not underlined or anything.

So, I made a local distribution list and added the contacts to it. Still when I go to add the list as the contact of the email, and type in UBB or try to link it in there, it still will not work. So what do I need to change to get this to work?

Thanks for any help, and if you need more information I will gladly give it to you.
 

Answer:Distribution List Problem in Outlook

8 more replies
Relevance 78.31%

I find myself frequently deleting one of my distribution lists in Outlook XP when I only intended to delete one member. Is there a way I can create a cuplicate of this list under a different name as a backup (without having to re-create the list member by member)?
 

Answer:Copying Outlook XP Distribution List

9 more replies
Relevance 78.31%

I am a new user to Outlook 2003. I need to sort distribution list by last name and cannot find out how or if it can be down. I can sort the contact list by last name, as well as first, but the distribution list only sorts by first name which does not help me with a couple thousand entries.
 

More replies
Relevance 78.31%

Hello!
I wonder if anyone can help with a problem I've been having with a distribution list in Outlook. I've been using this list for months with no issue but around a month ago one of the members is not always receiving emails. They are still showing on the list in my contacts, but something seems to be happening between me sending the email as when I open the list in the sent email, they are not there! I've tried deleting them from the list and adding them again but it doesn't appear to have helped. Does anyone have any advice?
Thanks in advance!
 

Answer:Outlook Distribution List Error

Hello, you can try this: remove all the members from the DL, then delete it, also delete the contact that was not getting the messages, reboot the machine and restart Outlook, re-create the deleted contact, re-create the DL and add all the original members to it. (I am hoping it is a short list)
 

2 more replies
Relevance 78.31%

Dear all,

I'm trying to create a distribution lists from my contact in Outlook 2003 but cannot find the option for cc or bcc. Is there such an option?
 

Answer:Outlook 2003 distribution list

6 more replies
Relevance 78.31%

A friend has sent me a distribution list in a folder called 'Newsletter.msg'How can I get that list into the Contacts section of Outlook? I have tried sending myself an email with the file as an attachment and then dragging the file into Contacts but that does not seem to work unless I'm doing something wrong!I've also tried opening the file and highlighting one name but I then the find 'Select All' of View is not available so I cannot copy and paste into a new Distribution List opened in Outlook!!Any suggestions would be appreciated

Answer:Outlook - Distribution List Problem

I think that the problem may lie with the fact that it is in a folder. What format is it in?

2 more replies
Relevance 78.31%

How do I restore a distribution list deleted in Vista Contacts?
 

Answer:Distribution list in Outlook Contacts

As far as I know you don't unless you have a backup of the PST file!
 

1 more replies
Relevance 78.31%

Iím having trouble creating a distribution list with Outlook 2003 on XP Pro SP3. I know how to do it, have done it before, and just did it with the same rev Office on our laptop under Win7. When I try to create one, I get the attached error msg. My outlook.pst file is not on the C partition (on purpose), but this is nothing new and Outlook knows where it is. Email works fine and the contacts list works fine. I donít use the address book. Any ideas?

Thanks in advance.
 

More replies
Relevance 78.31%

I've problem sharing a folder that contains an address book (& deleted items).

Sharing individual contact is fine, but when I've created several distribution lists, other authorised sharing users have problem viewing/using these lists. Contacts in the list are shown with "unknown email address" and outllook cannot update contact's details (message showing "cannot find contact").

Can anyone please help?
 

Answer:Outlook 2K Sharing Distribution List

6 more replies
Relevance 78.31%

Hello

I have recently upgraded to office 2003 . However when I try to send an email through outlook using one of my distribution lists it tells me that "an internal support function returned an error" I would appreciate any help on this.

Paul
 

Answer:Can't use distribution list in outlook 2003

Do a detect and repair from the help menu.
 

3 more replies
Relevance 78.31%

Is there a way to copy and paste e-mails to an Outlook 2002 distribution list?  Is there a maximum number of e-mails you can put in a distribution list?  I have been able to copy and paste a large number of e-mails from my other e-mail account to the "copy" portion of my outgoing e-mail (without using the distribution list), but it will not send the e-mail. Is there a mazimum number of e-mails you can paste into the "copy" section of the e-mail?I am trying to find a quick way to start sending out newsletters from Outlook until I can enter each address in seperately from my Netscape account.Thank you.

More replies
Relevance 78.31%

I have been trying to send out a newsletter to a couple of hundred customers (NOT spam!) and set up a distribution list to do it. Upon sending, about 80% came back on an error message saying "couldn't find any host named" beside each in a listing of over a 150. My domain server investigated and concluded that it was not their server at fault. So, I tried setting it up as a mail merge so they would go out one at a time. Finally, after a gruesome time doing that I discover that bloody Outlook will not allow you an attachment on a mail merge e-mail! I KNOW many of the domains were good and active - like Dow & Dupont. Any thoughts as to why all of these may have been bounced? A workaround for mail merge attachments - I do NOT want to just include a link - I want the pdf to be attached? Another program for e-mailing that is more functional than MS xxxx? I will have to do this every few months and maintain the list etc. Many thanks for any responses.

Answer:Outlook 2003 distribution list

Multiple recipient emails are going to be bounced by many many servers.  You need a list server, or a mailing list set up with your ISP.  Do you run your own server?  If not, speak to your ISP about this.  A decent ISP will let you have this as part of your email service.

4 more replies
Relevance 77.49%

Greetings,

I have recently created a distribution list of about 700 contacts in Microsoft Outlook 2003. When I attempt to send a message to this list I get back an error message that says:

Your message did not reach some or all of the intended recipients.

Subject: XXXXXXXXXXXXXXXX
Sent: 11/14/2003 5:39 PM

The following recipient(s) could not be reached:

XXXXXXXXXXXX (deleted email address) on 11/14/2003 5:40 PM
452 too many recipients
The error message continues, listing every contact in the distribution list. I am aware of distribution lists in Outlook that have thousands of contacts without experiencing this problem. Any ideas as to what the problem may be/how to fix this problem?

Thanks.
 

Answer:Outlook 2003 distribution list problem

I would be interested in knowing this too. I have the exact same problem. My thought is that it is a problem with the 2003 version as I did not have this happen in XP version.
 

1 more replies
Relevance 77.49%

Hello everyone, I have to send news on our new products prior to a trade fair to all our customers. We use a Distribution List to maintain contact with all our customers. The problem is the distribution list is getting larger each day, so when I send a general communication using this list I get half a page of email addresses listed in the received message header. Is it possible to hide these addresses and just for example show the name of the Distribution List?

More replies
Relevance 77.49%

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?

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

2 more replies
Relevance 77.49%

Outlook Distribution list and disappearing address

Hi there,

We are on Microsoft Exchange. We have a global distribution list as well as our personal distribution lists. From time to time, when using the list and sending an email, one particular contact drops from this list. However, when we go to the distribution list she is there? It's very strange and it doesn't happen every day, just one in a while. It's happen with both Outlook 2003 and 2007. Any ideas on a fix? We've tried deleting her and adding her back but that doesn't seem to fix the problem. Any insight would be greatly appreciated.

Have a great day,
JC
 

Answer:Outlook Distribution list and disappearing adress

A shot in dark:
delete her and add her back by manually typing her details, do not copy paste anything.
 

3 more replies
Relevance 77.49%

when I correct an email in a distribution list and press"update" it appears to update to the new info but when I use the distribution list for an email the old info appears.

Answer:corrections to distribution list in outlook do not update

Where are you clicking "Update." Normally, you would click Save and Close.

2 more replies
Relevance 77.49%

When I try to send an e-mail distribution list I get the following message: "An internal support function returned an error".
 

More replies
Relevance 77.49%

I'm using Outlook 2003, and have discovered that a couple of the distribution lists I have set up have stopped working (turns out it's been a problem for a few weeks now).

I send off a message to one of these lists and the message seems to send okay (no error message). But then it just vanishes into the void. Nobody is receiving it. I can send to individuals no problem, but the groups never get the message. I haven't changed anything with the security settings recently.

I've checked with my ISP, and they can't find anything strange happening on their end.

I suspect it's an Outlook issue, but who knows.

I already tried deleting the group and recreating it, but it still doesn't work.

Any ideas?
 

More replies
Relevance 77.49%

Can anybody tell me how to increase the number of contacts I can save to a distribution list in Microsoft Outlook 2010? At the moment it seems to default at 60. Making more than 1 distribution list does not solve my problem...I need to be able to change that number of contacts I can save???? I am running on Windows 7!
Thanks
 

Answer:Outlook 2010 distribution list sizes

If this is a company with an Exchange server, they may be limiting the number of members in the distribution list.

If this is on your own, 2010 shouldn't restrict the size.

An alternate method of making a larger distro list is to break them up into groups and add the groups to another distro list:

group 1 members - Members 1-30
group 2 members - Members 31-60
group 3 members - Members 61-90
group 4 members - group 1, group 2, group 3
Kevin
 

1 more replies
Relevance 77.49%

Is it possible to transfer one person's distribution list within Outlook Web Access to another person?
 

More replies
Relevance 77.49%

Hello,I am wondering if there is an easy way to email, or create a distibution list for all contacts under a certian category without having to select each member one at a time?Need help!

Answer:Outlook Distribution list/categories question

Looking at Outlook 2003 Contacts here.  Click on the drop arrow next to New and select Distribution List.  

4 more replies
Relevance 77.49%

1) We've created a distribution list in Outlook 2002 that only the one user can access because it's in her Contacts tab. How can we get that distribution list into, say, the Global Address List so everyone on the network can use it? Is there a way to transfer or otherwise duplicate the list into the Global Address List?

2) (EDIT-) Got #2 figured out, now there's just the first question remaining.

Thanks,
m19
 

Answer:Moving an Outlook distribution list so other users can use it

Dunno wether this stuff will help... I have Outlook but dont use it,

http://www.outlook.unh.edu/tutorial/tutorial2002/address.html
http://support.its.ied.edu.hk/stufaq/2.7.html
http://www.slipstick.com/contacts/dl.htm
 

2 more replies
Relevance 77.49%

I created a distribution list not too long ago in outlook, and the first time I sent a message to the group, everything worked just fine. But the second time I tried to send a message and so on, outlook is saying that it does not recognize the list. If anyone else has ran into this problem and knows a fix, please let me know.

B.T.W. All of our software is up to date with service packs and everything else.
 

Answer:Outlook distribution list not sending messages

7 more replies
Relevance 77.49%

Can anybody tell me how to increase the number of contacts I can save to a distribution list in Microsoft Outlook 2010? At the moment it seems to default at 60. Making more than 1 distribution list does not solve my problem...I need to be able to change that number of contacts I can save???? I am running on Windows 7!
Thanks
 

More replies
Relevance 77.49%

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?
 

More replies
Relevance 77.49%

How do I migrate a user's distribution list created in Outlook to another machine?
 

Answer:Solved: How do I migrate distribution list in Outlook?

Looks like a distribution list sits in the default contacts folder and is indicated by its name in bold. So exporting the source contacts folder in PST format (for import elsewhere or migration) automatically includes the DLs. Didn't know that before. Hope that helps someone.
 

1 more replies
Relevance 77.49%

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.
 

More replies
Relevance 77.49%

We are using Outlook 2003 with Exchange 2007, i have my own personnel Exchange mailbox configured together with access to another generic mailbox shared with other people (which has been added via Tools -> email accounts -> Change or view existing email accounts -> Change -> More Settings -> Advanced, then Add)

We have created 10 or so distribution lists in the generic mailbox.

My problem is when i go to send to a distribution list from the generic mailbox account, I only have the option to send to contacts and distribution lists in my own personal account, the generic account contacts are not available.

Thanks for any help!!
 

Answer:Outlook 2003 Distribution List problem

9 more replies
Relevance 77.49%

I have a distribution list in Outlook an mistakenly deleted it yesterday, where does it go? I made a new distribution list with the same name and it would not work or send the email until I changed the name. How do I clean this up?
 

More replies
Relevance 77.49%

Hi everyone,

My colleagues and I use Outlook 2003, and connect via Microsoft Exchange Server.

Recently, some staff members have noticed that when they send an email to a distribution list, the email also gets sent to other random contacts who are not even added to the list.

Although these random contacts are definately not on the distribution list, they are added to the To box when the distribution list is added!

It is not one particular list - it has happened to different staff members with different lists, and on different computers. We have tried deleting the lists and starting again from scratch, but the same thing occured.

Does anyone know what could be causing this? Is it likely to be a network/server issue rather than Outlook?

Hope someone can help!

Thanks in advance!
 

More replies
Relevance 77.49%

I'm having a Problem Creating a Distribution List In Outlook. First, let me say, before someone asks...I have already completely un-installed, blown away all the old "pst" files (after first exporting all of the outlook data to a backup.pst file) then re-installed Outlook, imported my backup.pst file, so I'm working with a fresh install and still having the same problem.

Version: Outlook XP SP-1

Problem Description:

When I go into "Contacts", then click on "New" and select "Distribution List". The distribution list dialogue box comes up, but when I click on select members, the list that comes up, that should show everyone in "Contacts" is blank. As for as I know, I have checked every possible setting and drop down, trying to figure out how to get the list of Contacts to appear, but I've been completely unsuccessful. Hence, the decision to do a complete re-install of Outlook.

Has anyone seen this problem before...does anyone know the cause?
 

Answer:Problem Creating a Distribution List In Outlook

Thanks for making me do that. Same thing was happening to me.

Go to Tools-Email accounts. Use Change existing address book(s). If you've got any in there, remove them.

Create a new Outlook address book.
Create a new Personal address book.
Right-click your contacts; properties. Tell it to be an outlook address book.
Now, it becomes an option in the dropdown when you select a new distribution list.

Whew.

It was a little tedious, so I'm not sure if I forgot any steps.
 

2 more replies
Relevance 77.49%

I am using Outlook XP. I am trying to convert a list of Outlook contacts into a distribution list. Is there an easy way to do this without typing every entry in seperately? I have several hundreds saved so i need to keep them as a distribution list rather than individual names.ThanksFF

Answer:Outlook query -Distribution List/Contacts

You don't have to type the names in, just select them and add them to the list. You can even select them in blocks if you wish.

5 more replies
Relevance 76.26%

Please can anyone help with the following?Is it possible to set up a rule in Outlook based on a Distribution list, such that any emails sent to or received from a member of that distribution list is sent to a particular folder - without having to manually enter all the names of the people within that distribution list?Thus if I had a distribution list called sales (with the email [email protected]), with members alan, brian, carl and dave (email eg [email protected]). Is there any way that Outlook will know that alan, brian, carl, dave etc are members of sales and can be told to move emails to a particular folder?Hope that all makes sense. Thanks for your help

More replies
Relevance 76.26%

Hey all

I am having the following issue:

Running Windows XP SP3, Outlook 2003.

Now I when I try to send to a distribution list, it automatically comes back with the following error:

Undelivered Mail Returned to Sender - for all of the email addressess in the list, however if I manually add them all to the email, I can send it no problems.

Kind of butting my head against a wall here so if anyone can help that would be much appreciated!

regards
Neil
 

Answer:Issue with sending to a Distribution List in Outlook 2003

i'm guessing its a problem with the distribution list then. It may have the seperator wrong or something.

Try adding a single person to a distribution list and test mailing that. If it works add another and test that. Then try adding the names again and seeing if it works.
 

1 more replies
Relevance 76.26%

I need to send an email with a PDF attachment to all the members (200 or so) of an organization that I am a member of. I have an Excel file with the names and email addresses. I was even able to import the file to Outlook's Business Contact Manager. I have sent a couple of emails from the BCM, and it is SLOW. But now I need to send one with a PDF attachment and don't see a way to send an attachment. I would prefer to have the names in a distribution list in my address book, but can't figure out how to do that from either the excel fill or the BCM.

I have Windows XP and Microsoft Office 2007.

Rebecca
 

Answer:Outlook Distribution List from Business Contact Manager

DomLuc said:





http://www.tech-recipes.com/rx/2294/outlook_2007_create_distribution_list/Click to expand...

Nope, that's not what I'm asking. I need to know how to make a distribution list from the Business Contact Manager, not from contacts. I thought it would all be the same, too, but it didn't work that way.

Rebecca
 

8 more replies
Relevance 76.26%

Hi,

I tried Outlook help first and it suggested opening an email and then clicking on the Insert menu and choosing Item to insert a distribution list into an email. The problem is that there is no Item option on the insert menu! (unless I am blind)

I want to be able to share groups/distribution list with other colleagues. We do not have a server presently, our email is not currently managed in-house. Any suggestions? This would be especially helpful when setting up a new user.

Thanks!
-jlarson7000
 

Answer:Can I share my group/distribution list with another outlook user?

You could try exporting your Outlook contacts to a csv file.
The file could be emailed and then imported into the other user's Outlook.
 

1 more replies
Relevance 76.26%

I need to expand the distribution list(DL).. both DL in Exchange and private
contacts. I somewhat tried two ways of doing it but not successful in either
method.

I've Redemption installed with Outlook 2007.
Method 1: Using Redemption.RDOSession
I tried out the following code
using RDO. I knew there is strightforward API to achieve but in the
following code snippet, after the 6th line
"set Sesn = CreateObject("Redemption.RDOSession")"
, it doesn't work or throw any error message.

What else is required in addition to installing Redemption? Yours assistance
is much appreciated.

function TestRedemtionDL
MsgBox "in TestRedemtionDL"
set outlookObj=CreateObject("Outlook.Application")
set sessionObj = outlookObj.GetNameSpace("MAPI")
MsgBox "in TestRedemtionDL after app"
set Sesn = CreateObject("Redemption.RDOSession")
if Err.number <> 0 or Sesn = nothing then
MsgBox "in TestRedemtionDL after RDOSession"
end if
'Sesn.Logon
Sesn.MAPIOBJECT = sessionObj.MAPIOBJECT
MsgBox " Sesn.CurrentUser.Name " & Sesn.CurrentUser.Name
MsgBox "logging in"
set AB = Sesn.AddressBook
MsgBox "After AB "
set Recips = AB.ShowAddressBook
MsgBox Recips.Count
MsgBox "Err " & Err.Description
end function
Method 2 : Using Redemption.MAPIUtils. Partially working but not does what
exactly required.

I'm trying an VBS code to e... Read more

More replies
Relevance 76.26%

Hi,

sorry for stupid question, but I can't find out how to hide names (make invisible to other memebers of my list) on my distribution list in M$ Outlook 2000

Would be extremly grateful for help
 

Answer:(Solved) Outlook 2K: How to hide names on distribution list

14 more replies
Relevance 76.26%

I am trying to do this for my mother in law remotely and it is driving me mad.
She has a distribution list with about 100 email addresses in it in Outlook 2007. Her new computer does not have Outlook so she wants to export the list and import it into Hotmail.
Can it be done?
I have tried to export her contacts as a csv file adn then tried to import file into hotmail but hotmail keeps telling me the file is empty.
Any help would be gratefully appreciated.

Answer:Exporting a distribution list from Outlook 2007 to hotmail

See this

8 more replies
Relevance 76.26%

I've created a distribution list. I clicked the "Add Members/Add New E-Mail Contact". I put in the "Display name" and "E-mail address". I unchecked the "Add to Contacts" box and then I click the "OK" button. Now, I realized I've type in the wrong email address or if the user has changed his email address, I double click person's name and it didn't launch a window for me to edit but instead it opened a small window that display a summary of the person's information. I mouse over and click the "View more options for interacting with this person" icon and then click "Outlook Properties". Now, a window popup for me to edit this person's email address, "Display name", and a whole bunch of other information. I've made my changes and click the button "Save & Close". Now, I'm back to the Distribution window. In the "E-mail" column, it still shows the old email address and NOT the email address that I just finished modifying.


Here's what the actual email address is in the property window:

And noticed the E-mail address ([email protected]) above. Below is what is incorrect:


The email address showing here in the "E-mail" column shows "[email protected]" instead of "[email protected]". How do I fix this?

More replies
Relevance 76.26%

Hi
I am using winxp sp2 and outlook 2003. We have an exchange server. All of my distribution lists no longer show up as an email address nor do they have the plus sign. If i choose a single contact and "new message to contact" it works fine. if i go to a distribution list and choose "new message to contact" the distribution list comes up in my new message as text (no underline, no plus sign). I have tried making new test distribution lists with the same resuilts.

Help?????
 

Answer:Solved: Outlook 2003 Distribution List Problem

Try going into your address book via the icon on the standard toolbar and removing then readding the contacts folder. If that does not work we will look into readding the outlook address book and see if that fixes it, then we will look into scrubbing the folders.
 

3 more replies
Relevance 75.44%

Is it possible to create a distribution list in Outlook 2007, such that when one changes the email address in the underlying Outlook record, it automatically also updates within the distribution list? I believe the answer is "no," but don't know for sure. Perhaps a third-party add-on? Thank you. (I understand that in using the word "underlying," I'm suggesting that an Outlook 2007 record can actually talk to a distribution list, but that may not be true.)
 

Answer:Solved: Automatically update Outlook 2007 distribution list?

13 more replies
Relevance 75.44%

My Outlook 2003 is still sending to email addresses I have removed from a distribution list. Has anyone encountered this Outlook issue before? And how do I fix it??

Thanks for any suggestions!!
 

More replies
Relevance 75.44%

My Outlook 2003 is still sending to email addresses I have removed from a distribution list. Has anyone encountered this Outlook issue before? And how do I fix it??

Thanks for any suggestions!!
 

More replies
Relevance 75.44%

My mom works for the school district and received an email recently telling her that she needed to BCC all of the emails she sent to students. She uses Microsoft Office Outlook 2003 and needs to add a Distribution List of her 30 students, which she calls "2011-2012 Class." how can she do this. The help option on outlook has us very confused.

Thanks,
-James
 

Answer:Problems in Microsoft office Outlook adding Distribution List to BCC

The distribution list needs to be in her contacts list. She needs to be a separte entry in her contacts list.

Create the message to be sent.

Click the To button this will bring up the address book, be sure that the address book shows Contacts. In To select her own name/address. click the distribution list 2011-2012 Class and select the BCC tab.

Outlook as far I've run into wants to have a To address and a subject line, though you can send without a To - or subject (as long as the BCC has the distribution list) Outlook doesn't like it and I have had outlook fail when the To doesn't have a recipient.
 

1 more replies
Relevance 75.44%

Many of my contacts have multiple email addresses (work, personal, other). When I create a distribution list, how do I clarify which address I want to select for a particular distribution list? When adding someone to a distribution list, the only option I see... is to select a contact name. I'm not given a choice as to which email address I want inserted into the list. Thanks
 

More replies
Relevance 75.03%

In Outlook 2000, I displayed my contacts, I selected a distribution list and used drag and drop to the Inbox in an attempt to have Outlook create a new email and add the distribution list to the message header.Unfortunately, Outlook moved the dl to the inbox. I have restored the dl in my contacts.Question - how do I remove the dl from the Inbox? I am unable to delete the dl, I can't move it to another folder.Thank you for your help.Allison

More replies
Relevance 74.21%

In my Outlook 2010 I have set up a number of Contact Groups. I've named them A, B, C, D.............Z. In each one are the surnames of the recipients, e.g. in the A is Anderson, Addy, Apple, Adams, Aggenbach, etc., and likewise in B to Z. One of them (lets say the V's) have 35 addresses, and the A's have 6 addresses.

The problem I'm having is that when choosing the V Group (and some of the others), then when I click Send then it forever says Sending and never completes the task. So, it's impossible to send any other emails thereafter: they all then sit in the Outbox, waiting for the V task to finish. When I close and then re-open Outlook it just continues to send. I then have to delete some of the V recipients, until there are about 5 or so only, then it's works OK. Could the problem be, amongst others, the size in kB of the V Group, perhaps?

Please help!
 

Answer:Solved: Outlook 2010 unable to send contacts in distribution list successfully.

Just an idea, what email service are you using it with ?
is this a company exchange service or a home service
if home , and connected to one of the free mail providers (hotmail, gmail, yahoo etc)
perhaps there is a spam limit put on the number of email address you can send out on 1 email

although , I would expect 35 addresses to be OK
Gmail is 99
https://support.google.com/a/answer/166852?hl=en

outlook.com/hotmail
http://windows.microsoft.com/en-GB/windows/outlook/errors-sending-mail

Email Sending Limit and Send Rate - Gmail, Hotmail, Yahoo! Mail, AOL
http://www.yetesoft.com/free-email-marketing-resources/email-sending-limit/
 

3 more replies
Relevance 74.21%

Hello here's my situation..... I'm changing my email client from windows live mail 2012 to outlook 2010. I have several distribution lists in my contacts folder. How do i export those lists to outlook 2010? I noticed in outlook 2010 that there is an option when sending an attachment you can click outlook item then browse to contacts and then select the list - this option is not available in windows live mail .......any help would be greatly apprecitated thx
 

More replies
Relevance 73.8%

It there an easy way to create (import) an outlook distribution list from a list of names in excel.

Col 1 would have name <john doe> and col 2 would have e-mail address <[email protected]>

The distribution list would then have name and e-mail address.

Thanks in advance
 

Answer:Outlook distribution lists from excel

wakeolda said:


It there an easy way to create (import) an outlook distribution list from a list of names in excel.

Col 1 would have name <john doe> and col 2 would have e-mail address <[email protected]>

The distribution list would then have name and e-mail address.

Thanks in advanceClick to expand...

Hi Wakeolda,

did you ever find a solution to this problem??
Thanks
 

2 more replies
Relevance 72.16%

I have a statement I'd like to print, which has a validation drop down list. The statement goes through calculations every time a different item is selected on the validation drop down list.

I'd like to be able to create a macro that selects all the items on the drop down list and prints the statement/sheet every time a different item on the drop down list is selected through the macro.

Basically, a print all version and having it stop once all the items have been selected and reset to the top of the drop down list.

Very new to macros. Running Vista SP 1, Excel 2003 SP3.

Thanks
Jason
 

More replies
Relevance 71.34%

HiI am using this code below to create Excel sheets based off of a range of cells from a main sheet.I would like to do everything below but in addition when it creates the sheet and copies the row info, I would like it to make each row or cell on the main sheet link to each indivual sheet. Also within each individual sheet (that contains the one record info from the main sheet) to contain the link back to the main sheet. In other words, would like the hyperlinks to navigate back and forth when I have 75 sheets to work with. Any thoughts? thanks! BrahioSub AddMonthlySheets()Dim mMonth As Range For Each mMonth In Sheets(1).Range("A1:A12") ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count) ActiveSheet.Name = mMonth Sheets(1).Range(mMonth.Address).EntireRow.Copy Destination:=ActiveSheet.Range("A1") NextEnd Sub

Answer:Excel Macro to create worksheets from list with hyperlinks

First, a posting tip: Please click on the blue line at the end of this post and read the instructions on how to post VBA code in this forum. Thanks!As for your question, something seems a bit strange. You said:"...would like the hyperlinks to navigate back and forth when I have 75 sheets to work with."Yet your code only creates 12 sheets:For Each mMonth In Sheets(1).Range("A1:A12")Assuming that's just an example, I'll assume you can modify the code below to create as many sheets as you need.You didn't provide the Name of the main sheet, so I am going to be creative and use the name Main in my code below. Again, I assume that you can modify the code to meet your needs.This code will create a new sheet for each value in Main!A1:A12. It will also create links in Main!A1:A12 to the respective sheets. Finally, it will create a link in A1 of each new sheet back to Main!A1.Sub AddMonthlySheets()
Dim srcMonth, dstMonth As Range
'Loop Through A1:A12
For rw = 1 To 12
'Create Worksheets and Copy Row
Set srcMonth = Sheets("Main").Range("A" & rw)
ActiveWorkbook.Sheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = srcMonth
srcMonth.EntireRow.Copy Destination:=ActiveSheet.Range("A1")
'Create Hyperlink to new sheet
srcMonth.Hyperlinks.Add Anchor:=srcMonth, _
Address:="", SubAddress:=srcMonth & "!A1", _
TextToDisplay:=srcMonth.Value
'Create HyperLink back to Main sheet
Set dstMonth = ActiveSheet.Range("A1")
dstMon... Read more

4 more replies
Relevance 71.34%

I have a a list of forenames in B column and a list of surnames in C column. In the A column I need to display the first letter of the forename and the surname so for example andrew smith becomes asmith. I also need to prefix this with PADD1_ so i finish up with PADD1_asmith. An added difficulty is each name begins with a capital letter and it needs to be converted to lowercase in the process.

I have a list of approx thirty names to convert into the A column. Is this possible? thanks in advance
 

Answer:Excel Formula or Macro needed for names list.

Type this is in the first row and copy down
="PADD1_ " & LOWER(LEFT(B1,1)) & LOWER(C1)
 

2 more replies
Relevance 71.34%

I am trying to write a macro that calls up a named validation (drop down) list based in a particular cell based that cell is a certain value. For example, I have named the list "MailRef" and would like the drop down to appear in cell "B2" if the value of "B4" reads "Letter".

I am using excel 2003 - Any help on this would be much appreciated.

I have so far tried the following code:

Sub CallValidation()
With Sheets("Mail Out")
If Range("D2") = "Offer" Or Range("D2") = "Quote" Then

With Range("B2").Validation
.Delete
.Add Type:=x1ValidateList, Formula1:="=MailRef"

End With

End If
End With

End Sub


Thanks.
 

Answer:VBA Excel Macro to call drop down Validation List

Are you looking to have different lists show up if different things are put? What you could do in this instance, is Instead change the named list's name to "Letter" and have the conditional formatting for B2 be =B4
Then, when you put Letter in B4, it would refer to the named range "Letter" which should bring up your list. I'm doing this from memory, let me know if that isn't what your looking for, or doesn't work the way I think it will.
 

15 more replies
Relevance 71.34%

I require help on macro , couldnt find this issue anywhere else in this forum.

I have a list of names(around 500 mech parts) in excel 2003.Eg: "5922 X0E". These names can be converted to filenames if the spaces in between are removed. I have pooled all the files with these filenames in server directory(\\Server\ABC).

I need a macro which automatically hyperlinks the excel list to original files (which is .dwg). If i could assign a software with which the files would open, it would be added advantage.

have been searchin for solution since 1 week Pl give me some magic script.
 

Answer:Solved: Excel Macro for hyperlinking file list.

Please help me!
 

2 more replies
Relevance 70.52%

I have a macro that I recorded that does the following and I just need to change one thing for it to work the way I need it to do.

I select a list of cells in a different worksheet, and then run the macro.

This macro copies what I selected, goes to the worksheet named: Contact Fields Formulas. And then it pastes to Column D, starting in Row D4, the list of the cells that were copied.

Then, thru another macros I created before, when I am recording this macro, I run two other macros which one adds to the beginging of the words in the cells pasted, the " and the other macro I run while I am recording, adds to the end of the words in the cells pastd, the ".

Then the macro recorded goes to D4 and moves to E4, and makes E4 into E4=C4&D4, and it moves to E5 and then goes back up to E4, copies E4, moves to D4 and then down to the last cell with words that were pasted from D4 down, and then moves over to the cell to the right of the last cell in Column D that had the words as pasted, and then selects all cells going up to the E4, and pastes what was copied from E4.

Then, the E4 to the bottom of the last cell is still selected and it copies all of that, and then pastes it as a Paste Special with the concept Value, so that the Cells form E4 down, are the words of the two cells that were merged from the left of the E column cell.

So the question is, when I select another list of cells to copy and move over and do what the macro does, when in the area of

"moves... Read more

Answer:Excel Macro to Select Bottom Cell of LIst of Cells

8 more replies
Relevance 70.52%

Hello again!
I am having trouble with a macro that is supposed to perform the following tasks:

Prompt the user to input a cell where the drop down list is to be located
Prompt the user for a range of data to use in the drop down list values
Create drop down list
Hide the rows in which the drop down list values are located

I originally recorded a macro to do this, and then I am tweaking the code accordingly. What is troubling me is getting the macro to select a range from an input box, the using that input to create a list. It's the partcular language included in the .Add command that I do not understand I defined the input box as a range variable celRng, and I am trying to get Formula1: = celRng. But it is not working.

I have attached the code below, and marked in which lines the errors are located:


Code:
Sub CreatDropDownList()
'
' CreatDropDownList Macro
'
' Keyboard Shortcut: Ctrl+Shift+D
'
Dim celNm, celRng As Range
On Error Resume Next
Application.DisplayAlerts = False
Set celNm = Application.InputBox(Prompt:= _
"Please select a cell to create a list.", _
Title:="SPECIFY Cell", Type:=8)
On Error GoTo 0
Application.DisplayAlerts = True

If celNm Is Nothing Then
Exit Sub

Else
With Selection.Validation
.Delete
On Error Resume Next
Application.DisplayAlerts = False
... Read more

Answer:Excel Macro to Create a Drop Down List and Hide Cells

DJL,

It looks to me like you open the 'With Selection Validation' statement without closing it before the If statement.
Try adding End With before the If statement above your error, then add another 'With' Selection Validation' after the Else statement.

You can also put msgbox = celRng after the else statement to check the variable value before the error.

Stoneboysteve
 

5 more replies
Relevance 70.52%

Hi All,

I have a list of over 20 or so web sites and their corresponding advertisers and how much money they spend with each web site.

The list of web sites looks like this:
Weather Channel............Dollars..............About.com.......Dollars......etc...for 18 columns
IBM...............................$200,500..............Cingular...........$350,000
TMobile..........................$450,000..............Revlon............$275,000

My goal is to consolidate all the advertisers into a SINGLE COLUMN then to the right of it, have all my web sites across as COLULMNS reporting.

should look like this:

............................Travelocity.............. Expedia ....................Orbitz
ADVERTISERS
AT&T Corp...............$78,100................$94,700....................$271,200
Starwood Hotels.......$696,500...............$30,600....................$124,100
Hilton Hotels............$306,700................$900........................$64,200
Ramada...................$13,000.................$450,000...................$600,000
etc....(for at least 150 rows)

I'd like to be able to have the flexibility to add as many columns (Web sites with advertiser dollar amounts) as possible but have the macro paste the result to a NEW worksheet.

Does anyone know how to do this?

-bob
 

Answer:Consolidating list of web sites and their vendors into one column - EXCEL Macro

11 more replies
Relevance 69.7%

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
 

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

2 more replies
Relevance 69.7%

I am having difficulty adding myself to the Trusted developer list in Excel 2000.

I have a digital signature (unauthenticated) that I have used to sign the macro I recently developed.

The Security Level is set to High.

I am using MS IE6.0

When the Security Warning Dialogue Box comes up, the Always trust macros from this source check box is greyed out so I am unable to check it to add myself to the Trusted List.

Does anyone know how to get the Always trust macros from this source check box highlighted so it can be checked and the developer listed in the Security Warning Dialogue Box added to the Trusted list?

Thanks for any suggestions.

Linxis
 

More replies
Relevance 69.7%

Hi,I've got an Excel document with over 7K entries and I need to search the data to find where ever a certain keyword is mentioned and copy the entire row into a separate sheet within the same workbook. However, I have a list of around 50 keywords so doing this using Ctrl+F would take some time. I'm new to Macros but I think that a macro may be the best solution for this task.The data is in Sheet1 and the particular column that needs to be searched is "K". The contents of column "K" is made up of words and sentences. Sheet2 is where I would like the found results to be copied to. The list of Keywords that need to be searched for are located in Sheet3, starting from Cell A1. Below is a list of the sort of words that need to be searched for:JaguarLandroverTata MotorsVolvoAudiMazdaVauxhallOpelDoes anyone think they can help me create a macro to carry out this task or know of a better solution for doing it? Any help would be much appreciated.Thanks,

Answer:An Excel Macro to find & copy rows based on a keyword list

Isn't Land Rover 2 words? Do you really want to search for Landrover?Are any of the keywords found more than once in the same cell in Column K?e.g. "The Jaguar and Land Rover are both members of the Tata Motors family of vehicles."What do you want to happen if that's the case..copy the line each time any keyword is found (easy) or check to see if the line has already been copied and don't copy it again (tougher).Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 69.7%

Hello Everyone,

First time user of the forum here and it does seem everyone is very helpful! I did a search and could not find search macro for a list of values so I'm adding a new post. My apologies if this was answered before but hopefully someone can point me in the right direction.

Here's what I have:

I have 3 worksheets:
1. List of Search Criteria (List of 100 or so countries in column A)
2. Huge Data Set (Sales Data; column K, L, or M will contain country name)
3. Blank Output sheet

My goal is create a search button that will look in the Huge Data Set for sales transactions occuring in the list of countries specified on Sheet #1. The country info could be in any of the 3 rows (K, L, M) on Sheet #2. I would then like any row on the Huge Data Set with a matching country to be copied to the 3rd worksheet.

I hope my explanation makes sense.

Any help?

Simon
 

Answer:Solved: Excel Macro - Search List of Values, Copy, and Paste

13 more replies