You need to call this procedure with in another procedure with all parameters Sub sendMymail() SendNotesMail(Subject , attachment, ReceipentEmailID, bodytext, ,True) End Sub -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prakash Gusain Sent: Dec/Fri/2011 02:53 To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Send Personalized emails in Lotus Notes
Rajan Thanks for your reply. but sorry to say bro it's not working. On Dec 30, 1:28 pm, "Rajan_Verma" <rajanverma1...@gmail.com> wrote: > Hi, > See the link.. you can modify as per your requirement.. > > http://www.fabalou.com/VBandVBA/lotusnotesmail.asp > > -----Original Message----- > From: excel-macros@googlegroups.com > [mailto:excel-macros@googlegroups.com] > > On Behalf Of Prakash Gusain > Sent: Dec/Fri/2011 01:56 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Send Personalized emails in Lotus Notes > > Hi > > I want to send emails with constant subject but with variable matter > to people in the my list. I am using Lotus notes as email client. > > For example: > > Column A has my mail matter. A1: xcvb, A2: assd A3: qwer A4: poiu > Column B has email addresses. B1: x...@gmail.com B2: a...@gmail.com > B3: q...@gmail.com B4: p...@gmail.com > > Can you help me create such code? > > Thanks in advance to all experts. > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like > Please Help, Urgent, Need Help, Formula Problem, Code Problem, and > Need Advice will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum > in signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. > Forum owners and members are not responsible for any loss. > > ---------------------------------------------------------------------- > ------ > -------------------------- > To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ---------------------------------------------------------------------------- -------------------------- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
