Send ranges from excel to outlook

CepheiMD

New Member
Joined
Apr 1, 2016
Messages
10
Please help with the following.

I have an excel file with employees information and I need to send it to all the employees (each employee should receive his information).

There a more than 500 employees so send to each person with copy-paste its unreal.

For example, first email will be sent with range A1:C3 to the person from A2 (by viewing the mini sheet attached you can understand better my task)

salary ex.xlsx
ABCDEFGHIJKL
1InfoExample (message 1)
2John Johnson, ID 100to:John.Johnson@yahoo.com
3Salary 5 USDSubjectSalary info for last year
4BodyHello, please see your salary info from last year
5Info
6Mr. Bob Moore, id 200Info
7Salary3 USDMr. John Johnson
8Salary 5 USD
9Info
10Mr. Jack Grealish, id
11Salary4 USDExample (message 2)
12to:Bob.Moore@yahoo.com
13***SubjectSalary info for last year
14BodyHello, please see your salary info from last year
15
16Info
17Mr. Bob Moore, id 200
18Salary3 USD
19
20
21***
22
23General
24SubjectSalary info for last year
25BodyHello, please see your salary info from last year
26
Sheet1
 
Still not in table format...
 
Upvote 0

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Still not in table format...

Hello again.

I formated the table with employees data as table.
My boss asked to review each message before submit it, so if its possible to make not to send it but just to create new message with all data completed. In this case, for so much amount of data I'm afraid that Outlook will crash. As a solution I see to create by 100 message (I understand that I'll have to adjust the range in the VBA code).

P.S. Sorry if not provided data in correct format again

model info.xls
BCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAH
1Outlook TemplateComments:
2to:john.johnson@yahoo.comemail from the table
3SubjectInfo 2021static text
4Body:Hello, please see below the information about salary for 2021static text
5
6
7Anexa nr.5 la
8Ordinul Ministerului Finanțelor nr. 135 din 06 noiembrie 2017
9NameIDSalaryemailMonths worked
10Приложение № 5John Johnson12525 USDjohn.johnson@yahoo.com5
11к Приказу Министерствa финансов № 135 от 06 ноября 2017 г.Fred Andrew13553 USDfred.andrew@yahoo.com3
12Jack Wilfred12204 USDjack.wilfred@yahoo.com8
13
14INFORMAŢIE
15nr.1 din 31.12.2021 cell I15 = counter from 1 to …
16privind salariul şi alte plăţi efectuate de către rezidentul parcului pentru tehnologia informaţiei in folosul angajatului
17ИНФОРМАЦИЯ
181 от 31.12.2021I18 =I15
19о заработной плате и о других выплатах, осуществленных резидентом информационно - теxнологического парка в пользу работника
20
21ÎCS "" SRL, cod fiscal
22Prin prezenta / Настоящим,
23(denumirea rezidentului parcului IT, codul fiscal)
24(наименование резидента информационно - технологического парка, фискальный код)
25
26confirmă că, / подтверждает что,John Johnson, 1252E26 = Name + Id from the table
27(numele, prenumele şi codul fiscal al angajatului în folosul căruia au fost efectuate platile)
28(фамилия,имя и фискальный код работника, в пользу которого были произведены выплаты)
29
30pe parcursul anului 2 021 a beneficiat de urmatorul venit pentru activitatea desfasurata in parcul pentru tehnologia informatiei: / в течение года получил следующий доход за осуществленную деятельность в информационно - технологическогом парке:
31
32Suma venitului sub forma de salariu, plati de stimulare si compensare (lei)Nr. de luni in care angajatul a activat in parcul pentru tehnologia informatiei
33Сумма дохода, в виде заработной платы, поощрительных выплат и компенсации (в леях)№ месяцев, в котором работник работал информационно - технологическогом парке
3412
355 USD5D35 = Salary from table
36Q35 = Months worked from table
37Notă/Примечания:
38La persoana care este obligata sa prezinte informatia respectiva este necesar sa ramina confirmarea precum ca aceasta a remis sau a inminat informatia persoanei in folosul careia au fost efectuate platile.
39
40У лица, обязанного предоставить информацию, должно остаться подтверждение о том, что данная информация отправлена или вручена лицу, в пользу которoго произведена выплата.
41
42
43
44Conducatorul Contabil-sef
45Руководитель(semnatura \ подпись)Главный бухгалтер(semnatura \ подпись)
46
47
48
49
50[Outlook default signature]
51
52
53
54
55
56
TDSheet
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top