addresses

Hello I have a large database of orders that need to be sent out to various email addresses and wondered; if one column contains company numbers, is it possible for a macro to filter the data into separate tabs (grouped by the company) and email out to specified addresses? I’ve seen something...

Hello, we are running 3 surveys and we would like to compare how many new participants we are getting each time. We have 3 sets of email addresses from each survey. I will really appreciate your help on that, Thanks!

I have a spreadsheet where I manually enter URL's and/or an IP addresses which I later need to manually do a WHOIS lookup to obtain the abuse or admin email. I tried using a macro to do this but the only one I found is specifically written to use a particular WHOIS site which masks the email...

Hello , I have searched the forum to see if I can find what I wanted but it seems my request is a bit different. I have a code to create my pdf files already. I may not send them immediately after creation. Now what I need is a code to send the email using the files in a folder as...

MS Excel 2007 and MS Word 2007. I have created an address data base in Excel containing headers like:A1 name;A2 Door No; A3 Street; A4 City; A5 Postal code; and A6 State. Then address data entered from A2 onwards. I am able to create mailing address labels through MS Word using Mailings...

I have two columns of data in Column A and B. In column A, each cell could contain one to ten e-mail addresses. In Column B, each cell could contain one to ten e-mail addresses that could be the same or different. So A1 could be as@hotmail.com, as@gmail.com, as@yahoo.com B1 could be...

I have a userform that sends a copy of the workbook via email. The primary goal is to send the form back to me (or my counterpart) but it could be useful to send within the company as well. I want to ensure that any email addresses entered have a company domain. I'm not worried about actually...

In this code, the script will exclude duplicate email addresses. I want the opposite, as I want to include duplicate email addresses and send them each a separate e-mail. I do not know what part of the code to modify to get the intended result. '--- Begin looping through all the e-mail...

The scenario I have is a list (Column A) of IP addresses that will be scanned/pinged. Then I have a list (Column B) of IP addresses that came back with a response. I would like Excel to compare the two lists and return the addresses that DO NOT match, the ones that did not come back with a...

Hi, Sorry for all of the pics but if I can't figure this out I surely can't explain it very well! I'm trying to copy the hyperlink ADDRESSES and have them increase. Not working! I'm trying to avoid having to go into each and every hyperlink and edit the address since I will have well over...

Hello! I tried to find the best board, so I hope this one is ok. I currently have a column composed entirely of image addresses. I need to convert them all to images using =image("**") I really don't want to have to go an add =image("") to all of the links and would really appreciate it if...

Hi, I hope someone can help me. I have 2 columns on my spread sheet with lists of addresses in them. These addresses are for the same property (in adjacent cells) but sometimes one address has more info in it than the other. If the addresses in either are different to their counterpart, I...

I have a list of just over 6,200 names and addresses that I need to separate into their respective community subdivision, but I need to keep the owners names with those addresses. This is in order to add postal/zip codes and cities to the addresses. Is there a way to do this? For example, I need...

I'm using Excel 2003, and I'm trying to go from address labels to a single line per household. I have nearly 10,000 lines to go through. Is there any way of doing it faster than copy/paste/delete ad nauseum. The original one looks like this |Jane Doe |123 Any Street and I need it to be: Jane...

Hi I am completely lost with the following and really need some help please, not even sure where to start! I am trying to create a macro which based on a set parameter (the date specified in a cell being within 3 days of todays date) that an email is generated. This email would have the same...

Hi everyone I’m trying to write a program and I’d like to know if what I’d like to do is possible. A program that contains an address book worksheet that allows for multiple addresses, phone #s and emails. I’d like to have only one record per person and an in cell dropdown lists for those...

I have a spreadsheet that contains names in one column (C) and email addresses in another column (D). Each person/row is a part of one or more of six groups. I have captured their group information in columns G-L which are titled simply 1-6, and then if a person is part of group 1 they get a 1...

Good morning, Our office recently upgraded Office to 2016 and will also be converting to Microsoft 365. Because of this, I have lost the auto complete list for Outlook. Prior to the change, I did copy and rename the txt file containing all the entries, but I am unable to reintroduce it to the...

I have no experience with VBA Goto although it seems like this is my only option. I am trying to use a series of cell addresses to enter a value "RTS" in the cell next to the cell addresses. I was wondering how I can achieve this. Thanks in advance

There must be a technique of which i am ignorant to preserve the addresses or the formulas a range name refers to. A workbook has been returned from coworkers with unexplained #REF # errors in some range name addresses. So, how is this best fixed, that is, where and how should this...