How to send email through IBM Lotus Notes 8.5 using excel 2007

G

gpansari

New Member
Joined
May 23, 2013
Messages
1
Hi,

I have a worksheet, which I need to send to different areas of the business, where there are 2 businesses being handled by each area.
So for Area 1 the ranges A1:B6 and H1:H6 need to be send to the email id against Area1, i.e. cell B10 (Area1@xyz.com)

Mail subject: cell C10
Mail Body: Ranges A1:B6 and H1:H6
Mail to: cell B10
Mail CC: cell $B$16 (same for all mails)

Similiarly, for Area 2:
Mail subject: cell C11
Mail Body: Ranges A1:A6 and C1:C6 and J1:J6 (would be helpful if this can be sent as one table of 3 columns)
Mail to: cell B11
Mail CC: cell $B$16

Please help me with a macro for this (or recommend an available add in).


[TABLE="class: grid, width: 1475"]
<colgroup><col><col><col><col><col span="4"><col><col><col span="4"><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Division[/TD]
[TD]Business 1[/TD]
[TD]Business 1[/TD]
[TD]Business 1[/TD]
[TD]Business 1[/TD]
[TD]Business 1[/TD]
[TD]Business 1[/TD]
[TD]Business 2[/TD]
[TD]Business 2[/TD]
[TD]Business 2[/TD]
[TD]Business 2[/TD]
[TD]Business 2[/TD]
[TD]Business 2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Region[/TD]
[TD]Area 1[/TD]
[TD]Area 2[/TD]
[TD]Area 3[/TD]
[TD]Area 4[/TD]
[TD]Area 5[/TD]
[TD]Total[/TD]
[TD]Area 1[/TD]
[TD]Area 2[/TD]
[TD]Area 3[/TD]
[TD]Area 4[/TD]
[TD]Area 5[/TD]
[TD]Total[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD] [/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[TD]$[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Month Budget[/TD]
[TD] 12[/TD]
[TD] 18[/TD]
[TD] 18[/TD]
[TD] 35[/TD]
[TD] 14[/TD]
[TD] 97[/TD]
[TD] 0.39[/TD]
[TD] 0.76[/TD]
[TD] 1.97[/TD]
[TD] 2.11[/TD]
[TD] 1.70[/TD]
[TD] 6.94[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Spend[/TD]
[TD] 5[/TD]
[TD] 7[/TD]
[TD] 13[/TD]
[TD] 15[/TD]
[TD] 7[/TD]
[TD] 49[/TD]
[TD] 0.05[/TD]
[TD] 1.11[/TD]
[TD] 0.36[/TD]
[TD] 1.19[/TD]
[TD] 0.76[/TD]
[TD] 3.47[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Total Sale Value[/TD]
[TD] 229[/TD]
[TD] 582[/TD]
[TD] 351[/TD]
[TD] 577[/TD]
[TD] 266[/TD]
[TD] 2,006[/TD]
[TD] 2.51[/TD]
[TD] 11.68[/TD]
[TD] 39.68[/TD]
[TD] 28.74[/TD]
[TD] 11.49[/TD]
[TD] 94.10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Mailing List[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]Area[/TD]
[TD]email id[/TD]
[TD]Mail Subject[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Area 1[/TD]
[TD]Area1@xyz.com[/TD]
[TD]Sale update for the month - Area 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]Area 2[/TD]
[TD]Area2@xyz.com[/TD]
[TD]Sale update for the month - Area 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Area 3[/TD]
[TD]Area3@xyz.com[/TD]
[TD]Sale update for the month - Area 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]Area 4[/TD]
[TD]Area4@xyz.com[/TD]
[TD]Sale update for the month - Area 4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]Area 5[/TD]
[TD]Area5@xyz.com[/TD]
[TD]Sale update for the month - Area 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]CC:[/TD]
[TD]Total@xyz.com[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 
You must log in or register to reply here.

Similar threads

C
  • Question Question
Send e-mails selected from a list in excel
Replies
1
Views
288
Sequoyah
Sequoyah
J
  • Question Question
Send bulk email attachment error
Replies
3
Views
295
JOHATUP
J
B
  • Question Question
VBA Code to Send Mail to skip blank cells
Replies
1
Views
421
Micron
M
G
  • Question Question
Run macro after new email
Replies
1
Views
242
Peter_SSs
Peter_SSs
M
  • Solved
Optimizing my rows to send e-mail to different address
Replies
2
Views
218
MasterBash
M

Share this page

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