Miguel, further reqeust how to write a macro to join Emails address record from a Email Address Master[ per attached sample ] ie to join the "To" and "CC" email addresses and put ";" in between then place into the Email Macro A column for mass sending ?

Hello everyone,

I attached a file with changes as requested

on the sheet I added a new command button to update the list of email addresses to (send to & send CC) 
with all the lists you had on the demo sheet, the demo sheet is in this file too

there are two command buttons, one to update the list and the other to send, you can adapt to your needs

Miguel,

Really thanks Miguel, will try on that.

I click on hte update button, but no effect ?

ie seems the update Macro Button not working?

Hello everyone,

the file I attached works perfectly, I just downloaded it on 2 different computers (32-Bit & 64-Bit), and I did the tests

review everything you are doing wrong

_ the first time you open an excel file (either because it is new or because the name has been changed), excel disables editing and macros, if you ignore these alerts, nothing will work

_ you must allow editing

_ you have to allow macros

_ in some situations (such as company computers), there may be additional security protocols, in which if the excel file was not created on that computer, the macros will always be in "disable" mode, "enable" mode not being allowed . To get around these protocols, you need to click on "save as", with a new name, close the excel file, and open the newly created one, allow editing and macros, and everything works

attached images, illustrative

(compressed) test video in file

Miguel,

Will adjust the Macro security setting with my PC, but is the macro can work wih MsOffice 2010 version, I use Office 2010 to open the Macro file prompt some library files is missing

Hi Miguel, thanks the hints again.
So after adjust the Macro security level by the IT Administrator to my PC, now the Macro works with Ms.Office 2019 [Prof Version] wiht os Windows 10, but I did try an old office version, error crop-up prompting some Library files is missing, please help whcih library files must activate to enable Macro of this kind.

One more request how to add File Name in the Subject  Email body

for example  : Subject : AR Monthly report : 12349

Attachment : 12349.xls

for example  : Subject : AR Monthly report : 456789

Attachment : 456789.xls

The reason is easier to search from Outlook

In the Email Macro how to modify and include attachment File name in the Email Subject : 

(1) Monthly Report & 12349

attachment file is : 12349.xls

(2) Monthly Report & 456789

attachment file is : 456789.xls

(3) Monthly Report & 987654

attachment file is : 987654.xls

etc etc

Sorry I should have attached modified macro file for further modification...

Hello everyone,

in relation to your post 38, I think it is better to create a new topic for this purpose, just so as not to mix all the subjects in one topic ... it would be easier for others to help, because the title of the topic would be related to the subject, and for memory future, easier to find by searching in the forum...

about missing references, it's not easy, but you could tell which ones are missing!




_ To start with, you could access the Excel VBA editor

_ In VBA editor window, click the "Tools" button in the menu bar

_ Then, from the drop down list, see which of the references that were selected, has "missing", the word "missing", is at the beginning of the reference name

_ Finally, click "Cancel" button to exit


Miguel,

Hello,

I didn't understand what you meant in your posts 39,40,41

the path of the file to be attached must be complete (directory, name and extension), in your file, which I downloaded, the extensions for each file are missing

in my post 9, I already gave you a macro to get information about all the files in a folder, where in column ("B") the macro inserts the full path of the file

Miguel,

So Sorry causing too much confusion so far all my poblems in these posts has been clear and settled; except the last item we want to show in the File name of the attachment to be stated in the Email Subject, like belwo

for example : Subject : AR Monthly report - 12349

File path :CData12349.xlsx
File Name :12349.xlsx

for example : Subject : AR Monthly report - 456789

File path :CData456789.xlsx
File Name :456789.xlsx

for example : Subject : AR Monthly report - 789654

File path :CData789654.xlsx
File Name :789654.xlsx

In short in each mail item we want to show the attachment file name in the Subject, i hope I make clear myself for this request..

hello,

Attached file with requested changes

Changes: (in Module1)

_ function has been added to retain the name and extension of all files that will be attached to the email

_ changes made in the email macro (procedures for checking the files to be attached and subject to being inserted in the email)

_ the procedure for retaining the name and extension of the files, is prepared to retain the name of all the files that will be attached, but I just put a blank space between the names (highlighted in red in the line below), if you want a symbol to divide the names, just add where the blank space is in the middle of the quotes

attachName = attachName & " " & VBA.Right(checkD, VBA.Len(checkD) - getLastOcurrence(checkD, "") + 1)

Miguel,