I am sending out a oft to a changing set of email addresses. I may send out 5 email ofts to a list of people and than 30 email ofts to different list of people the next day. I need to help with code that will automatically know how many emails to create. Below is the spreadsheet I use
<TABLE style="WIDTH: 425pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=568><COLGROUP><COL style="WIDTH: 108pt; mso-width-source: userset; mso-width-alt: 2560" width=144><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 2872" width=162><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 1336" width=75><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 3328" width=187><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; WIDTH: 108pt; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ece9d8 0.5pt" class=xl69 height=20 width=144>Rep Name</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; WIDTH: 121pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ece9d8" class=xl75 width=162>John Smith</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" vAlign=top width=75 align=left><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 1; POSITION: absolute; MARGIN-TOP: 6.6pt; WIDTH: 20.4pt; HEIGHT: 25.8pt; VISIBILITY: visible; MARGIN-LEFT: 45.6pt; mso-wrap-style: square; v-text-anchor: top" id=FirmPerformanceReports o:insetmode="auto" o:button="t" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSF
dyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAsduM3DQDAACHDQAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWzUl11P2zAUhu8n7T9Yvp2gTZo2oSJF
GgNuYKB2/ADPcdpojh3Zbmn363f8kQ+6jUnbzXoDjc/xm/McO/Gby6t9zdGOKV1JkePofIwRE1QW
lVjn+PnL7VmGkTZEFIRLwXJ8YBpfLd6/uyTztSLNpqIIFISekxxvjGnmo5GmG1YTfS4bJiBWSlUT
A5dqPSoUeQHlmo/i8Xg2qkkl8KKX+kQMQVtV/YUUl/QbK66J2BENkpzOhyOhRk7/XZnMxe5ONavm
SdnK6efdk0JVkWPonCA1tAiPQiCkweXoaNa6F9iXqrb5sizRPseTWTyZRKB1gNUYJ2k69XJsbxC1
8cwGKUTjLJ1NQ5RuHt+eTjc3bwhAeb4M+DEoTTe2MLH7mTVuWW8rVT8x5dZYULZkjVRGdx2wM1v8
VkWHzh2BJ0k2i4H2d+DRbJpOpi37xdTmeulWqFHa3DFZI/sjx4pR4zYX2d1r41PbFMulJa+K24pz
d2H3LLvmCu0Iz/HXdeym8m39IAs/Fk/H43G4pdviNt0t7UAJGtjymf3K9c/sP8riYG/yFf7DZoGn
zTzCn5LLlxxTXjUYKcOvJdwY+IigG6kgYJTvI9dmZQ6cWQm+4xH0D9VE3bvsShRMAO3Y1VuwcglR
/R02TwTV/omTm6glGnaDE1MJZA4NKwmFHf2hFmfc+GoYOQow4gNUHwWo2wfQEV+Va1WoP6DEPUoy
TeGVgNHp8ViIwDPpeS6iJDlNHgsReJKeJ5qk0ew0gSxFAJoOgLI4y04TyFIEoFkPFMcZLNBJPkKW
IgClA6A0mZzoO8FSBKCsB7I0J/pSsBQB6GIABGfyib4ULIU/kQanqzuve7xXzxIifA0OuTuVXTsU
HLacWKvMxNnzCqzy/3XyQn121cxiuRVoxUSBbsBzc/RAqJLWlRrXA98JoLcjnV3ZarZqluCivHdq
/YzuvIhYshKsL7hS75Y6V+QNE6EUrEmEbQV6Qwrmh62N+rWP4lbQZpfgyjrtIPDaoLXavrSQb6ey
soSKu8nBAr01uZvh7ixFP7muhFS+/NcCvW0qfb7rXGiMs4AwcPQJ4lLCJ5P9zhleL34AAAD//wMA
UEsDBBQABgAIAAAAIQCLZi1ovAYAAOkbAAAaAAAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWzs
WU9vHDUUvyPxHay5t9n/zUbdVNnNbgtt2ijZFvXonfHOuPGMR7Y36d5Qe0RCQhTEBYkbBwRUaiUu
5dMEiqBI/Qo82zOz4+wsSUoEAppDdubNz+/5/fWzffXaw5ihQyIk5UnPq1+ueYgkPg9oEva8u+PR
pXUPSYWTADOekJ43J9K7tvnuO1fxhs9oOuFYBOOIxAQBo0Ru4J4XKZVurK1JH8hYXuYpSeDblIsY
K3gV4Vog8BEIiNlao1brrMWYJt4mcFSa0ZDBv0RJTfCZ2NdsCEpwDNLvTKfUJwYbHNQ1Qs7lgAl0
iFnPA54BPxqTh8pDDEsFH3pezfx5a5tX1/BGNoipFWNL40bmLxuXDQgOGkamCCeF0Pqo1b2yXfA3
AKaWccPhcDCsF/wMAPs+aGrnUubZGq3X+znPEsg+LvMe1Nq1losv8W8uzbnb7/fb3WwulqkB2cfW
En691mltNRy8AVl8ewnf6m8NBh0Hb0AW31nCj650Oy0Xb0ARo8nBElo7dDTKuBeQKWc3KuHrAF+v
ZfAFCqKhiC4tYsoTtSrWYvyAixEANJBhRROk5imZYh9icoDjiaBYC8AbBJe+WJIvl0haFpK+oKnq
ee+nOPFKkNcvvn394hl6/eLp8aPnx49+OH78+PjR95aXM/AGTsLywFdff/L7lx+i35599erJZ9V4
Wcb//N1HP/34aTUQMmih4cvPn/7y/OnLLz7+9ZsnFfAtgSdl+JjGRKLb5Ajt8Rh0M4ZxZ04m4nwj
xhGmzggcAe8K1kMVOcDbc8yqcH3iGu+egOJRBbw+e+DMdT8SM0UrJN+MYge4wznrc1FpgJtaVsnC
41kSVgsXszJuD+PDKtkDnDiuHc5SqJp5UDq2H0TEmeYuw4nCIUmIQvobPyCkQrv7lDp23aG+4JJP
FbpPUR/TSpOM6cQJpMWgGzQGv8yrdAZXO7bZuYf6nFVpvU0OXSQkBGYVkx8T5pjxOp4pHFexHOOY
lQ1+C6uoapL7c+GXcUOpwNMhYRwNAyJl1Zg7AvQtOf0mhnpV6fYdNo9dpFD0oIrnLcx5GbnNDwYR
jtMq7D5NojL2PXkAIYrRLldV8B3uZoh+Bz/gZKW771HiuPv0QnCXhs6UFgGiv8yE9iUUaqf+xjT5
s2LMKFRjGwNvi3HP24KlqSolbpwowatw/8LCu41nyS6BWF9eeN7W3bd11/vP191VuXzWarsosFB7
dfNg+2LTJccrm+QpZWxfzRm5JU2fLGGxCEZA1OPMZpAUm6Y0gsesuDu4UGAzBgmuPqAq2o9wCj12
3dNMQpmxDiVKuYS9nSFX8tZ46NOV3Rm29Z7B1gOJ1Q4PLLmpyfnWoGBjlpzQ7D9zQU3N4KzCmlcy
pqD2mwir60mdWVrdTM2UOkdaoTL4cFk1IBbWhC4EQe8CVu7AdlyLhr0JZiTQdrcLcO4W44WLdJGM
cEAyH2m9l31UN07KY8UcBkDsVPhI7/NOsVpJWlez/QvSzuKksrjWCnG59/6Kl/IIXnhJ5+2JdGRJ
OTlZgo56XrfdaHvIx2nPm8K2Fh7jFLwudeOHWQgHQr4SNuxPTWaT5QtvdnPF3CSow0mFtfuSwk4d
SIVU21hGNjTMpywEWKIl2fk32mDWi1LARvobzKK5DsHwj80C7Oi6lkynxFdlZ5co2nb2NSulfKaI
2I+CIzRhM7GHwf06VEGfgEo4nTAVQb/AUZq2tvnkFucs6coHWAZn6ZilEc7KrU7RPJMt3ORxMQfz
Vpoe6FY5d6Pc+VUxKX9BqpTD+H+mil5P4LigGWgP+HAuKzDS+drzuFARhyqURtQfCWgcTO2AaIHj
WPgMQQWHyOZXkEP9a3PO8jBpDbs+tUdDJCisRyoShOxCWTLRdwqzerZ2WZYsY2QiqjRdmdppT8gh
YWNdAzt6bfdQBKFuqklWBgzuZPy571kGTULd5JTzzakhxdprc+Dv7nxsMoNSbh02DU1u/2KKFauq
HW+G52tvWRH9YdFmtfKsAGGlpaCbpf0bTuGcS62tWEsaN9r55MCLyxoDsWiIUjj0QfofrH9U+Mxe
OOgFdcz3oLYiuGvQzCBsIKov2cYD6QJpiRNonCzRBpNmZU2btU7aavlifcGdbiH3hLH1zM7i73Ma
u2jOXHFOLl6ksTMLO7a2tJWmBs+eTFEgTfONjHFM1cXTDk7RJKz3PLj8AUc/hCe4PvKA1tC0hqbB
E9wJQbNkL3J6XvaQU+C7pRSYZk5p5phWTmnllHZOgeYsuzLJKR2oVPqWA27Z9I+H8gsN6OCyC5C8
qDq3c5t/AAAA//8DAFBLAwQUAAYACAAAACEAnGZGQbsAAAAkAQAAKgAAAGNsaXBib2FyZC9kcmF3
aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc4SPzQrCMBCE74LvEPZu0noQkSa9iNCr1AcIyTYt
Nj8kUezbG+hFQfCyMLPsN7NN+7IzeWJMk3ccaloBQae8npzhcOsvuyOQlKXTcvYOOSyYoBXbTXPF
WeZylMYpJFIoLnEYcw4nxpIa0cpEfUBXNoOPVuYio2FBqrs0yPZVdWDxkwHii0k6zSF2ugbSL6Ek
/2f7YZgUnr16WHT5RwTLpRcWoIwGMwdKV2edNS1dgYmGff0m3gAAAP//AwBQSwECLQAUAAYACAAA
ACEAu+VIlAUBAAAeAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIt
ABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAADYBAABfcmVscy8ucmVsc1BLAQIt
ABQABgAIAAAAIQCx24zcNAMAAIcNAAAfAAAAAAAAAAAAAAAAACACAABjbGlwYm9hcmQvZHJhd2lu
Z3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAAAAAAAAAAAAAAAA
kQUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhAJxmRkG7AAAAJAEA
ACoAAAAAAAAAAAAAAAAAhQwAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwu
cmVsc1BLBQYAAAAABQAFAGcBAACIDQAAAAA=
" type="#_x0000_t75" o:spid="_x0000_s1025"><v:fill o:detectmouseclick="t"></v:fill><v:imagedata src="file:///C:\DOCUME~1\U0045046\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.png" o:title=""></v:imagedata><o:lock aspectratio="f" v:ext="edit"></o:lock><?xml:namespace prefix = x ns = "urn:schemas-microsoft-comffice:excel" /><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Bitmap</x:CF> <x:AutoPict></x:AutoPict></x:ClientData></v:shape><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 56pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=75></TD></TR></TBODY></TABLE></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 140pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=187></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #376091; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl80 height=19>RepTitle</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8 0.5pt; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ece9d8" class=xl75>Client Services</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8 0.5pt" class=xl70 height=19>Rep Phone</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76>(888) 888-8888</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8 0.5pt" class=xl71 height=20>Rep Email</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl77>john.smith@test.com</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl81 height=20>=COUNTA(A7:A205)</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; HEIGHT: 15pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8 0.5pt" class=xl71 height=20>Name1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl78>User_Number</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>Password1</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #4a452a; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>Client Email Address</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Julie</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8" class=xl79>1111111</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>ABCD</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Julie.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Heather</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111113</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>IJKL</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Heather.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Kalen</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111114</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>MNOP</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Kalen.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Steve</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111115</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>QRST</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Steve.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Chris</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111116</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>UVWX</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Chris.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Tim</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111117</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>YYYYY</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Tim.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Scott</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111118</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>AAAA</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Scott.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Kelly</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111119</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>BBBB</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Kelly.smith@test.com</TD></TR></TBODY></TABLE>
The macro currently opens the oft and populates the rep name, rep title, rep phone, rep email, and password. But I want the code to be able to automically read the number of emails it needs to create. Can anyone help? The first Column is A and the last year in this instance is 14.
<TABLE style="WIDTH: 425pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=568><COLGROUP><COL style="WIDTH: 108pt; mso-width-source: userset; mso-width-alt: 2560" width=144><COL style="WIDTH: 121pt; mso-width-source: userset; mso-width-alt: 2872" width=162><COL style="WIDTH: 56pt; mso-width-source: userset; mso-width-alt: 1336" width=75><COL style="WIDTH: 140pt; mso-width-source: userset; mso-width-alt: 3328" width=187><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; WIDTH: 108pt; HEIGHT: 15pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ece9d8 0.5pt" class=xl69 height=20 width=144>Rep Name</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; WIDTH: 121pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ece9d8" class=xl75 width=162>John Smith</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 56pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" vAlign=top width=75 align=left><?xml:namespace prefix = v ns = "urn:schemas-microsoft-com:vml" /><v:shapetype id=_x0000_t75 stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" o
referrelative="t" o:spt="75" coordsize="21600,21600"><v:stroke joinstyle="miter"></v:stroke><v:formulas><v:f eqn="if lineDrawn pixelLineWidth 0"></v:f><v:f eqn="sum @0 1 0"></v:f><v:f eqn="sum 0 0 @1"></v:f><v:f eqn="prod @2 1 2"></v:f><v:f eqn="prod @3 21600 pixelWidth"></v:f><v:f eqn="prod @3 21600 pixelHeight"></v:f><v:f eqn="sum @0 0 1"></v:f><v:f eqn="prod @6 1 2"></v:f><v:f eqn="prod @7 21600 pixelWidth"></v:f><v:f eqn="sum @8 21600 0"></v:f><v:f eqn="prod @7 21600 pixelHeight"></v:f><v:f eqn="sum @10 21600 0"></v:f></v:formulas><vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"></vath><?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o:lock aspectratio="t" v:ext="edit"></o:lock></v:shapetype><v:shape style="Z-INDEX: 1; POSITION: absolute; MARGIN-TOP: 6.6pt; WIDTH: 20.4pt; HEIGHT: 25.8pt; VISIBILITY: visible; MARGIN-LEFT: 45.6pt; mso-wrap-style: square; v-text-anchor: top" id=FirmPerformanceReports o:insetmode="auto" o:button="t" o:gfxdata="UEsDBBQABgAIAAAAIQC75UiUBQEAAB4CAAATAAAAW0NvbnRlbnRfVHlwZXNdLnhtbKSRvU7DMBSFdyTewfKKEqcMCKEmHfgZgaE8wMW+SSwc27JvS/v23KTJgkoXFsu+P+c7Ol5vDoMTe0zZBl/LVVlJ
gV4HY31Xy4/tS3EvRSbwBlzwWMsjZrlprq/W22PELHjb51r2RPFBqax7HCCXIaLnThvSAMTP1KkI
+gs6VLdVdad08ISeCho1ZLN+whZ2jsTzgcsnJwldluLxNDiyagkxOquB2Knae/OLUsyEkjenmdzb
mG/YhlRnCWPnb8C898bRJGtQvEOiVxjYhtLOxs8AySiT4JuDystlVV4WPeM6tK3VaILeDZxIOSsu
ti/jidNGNZ3/J08yC1dNv9v8AAAA//8DAFBLAwQUAAYACAAAACEArTA/8cEAAAAyAQAACwAAAF9y
ZWxzLy5yZWxzhI/NCsIwEITvgu8Q9m7TehCRpr2I4FX0AdZk2wbbJGTj39ubi6AgeJtl2G9m6vYx
jeJGka13CqqiBEFOe2Ndr+B03C3WIDihMzh6RwqexNA281l9oBFTfuLBBhaZ4ljBkFLYSMl6oAm5
8IFcdjofJ0z5jL0MqC/Yk1yW5UrGTwY0X0yxNwri3lQgjs+Qk/+zfddZTVuvrxO59CNCmoj3vCwj
MfaUFOjRhrPHaN4Wv0VV5OYgm1p+LW1eAAAA//8DAFBLAwQUAAYACAAAACEAsduM3DQDAACHDQAA
HwAAAGNsaXBib2FyZC9kcmF3aW5ncy9kcmF3aW5nMS54bWzUl11P2zAUhu8n7T9Yvp2gTZo2oSJF
GgNuYKB2/ADPcdpojh3Zbmn363f8kQ+6jUnbzXoDjc/xm/McO/Gby6t9zdGOKV1JkePofIwRE1QW
lVjn+PnL7VmGkTZEFIRLwXJ8YBpfLd6/uyTztSLNpqIIFISekxxvjGnmo5GmG1YTfS4bJiBWSlUT
A5dqPSoUeQHlmo/i8Xg2qkkl8KKX+kQMQVtV/YUUl/QbK66J2BENkpzOhyOhRk7/XZnMxe5ONavm
SdnK6efdk0JVkWPonCA1tAiPQiCkweXoaNa6F9iXqrb5sizRPseTWTyZRKB1gNUYJ2k69XJsbxC1
8cwGKUTjLJ1NQ5RuHt+eTjc3bwhAeb4M+DEoTTe2MLH7mTVuWW8rVT8x5dZYULZkjVRGdx2wM1v8
VkWHzh2BJ0k2i4H2d+DRbJpOpi37xdTmeulWqFHa3DFZI/sjx4pR4zYX2d1r41PbFMulJa+K24pz
d2H3LLvmCu0Iz/HXdeym8m39IAs/Fk/H43G4pdviNt0t7UAJGtjymf3K9c/sP8riYG/yFf7DZoGn
zTzCn5LLlxxTXjUYKcOvJdwY+IigG6kgYJTvI9dmZQ6cWQm+4xH0D9VE3bvsShRMAO3Y1VuwcglR
/R02TwTV/omTm6glGnaDE1MJZA4NKwmFHf2hFmfc+GoYOQow4gNUHwWo2wfQEV+Va1WoP6DEPUoy
TeGVgNHp8ViIwDPpeS6iJDlNHgsReJKeJ5qk0ew0gSxFAJoOgLI4y04TyFIEoFkPFMcZLNBJPkKW
IgClA6A0mZzoO8FSBKCsB7I0J/pSsBQB6GIABGfyib4ULIU/kQanqzuve7xXzxIifA0OuTuVXTsU
HLacWKvMxNnzCqzy/3XyQn121cxiuRVoxUSBbsBzc/RAqJLWlRrXA98JoLcjnV3ZarZqluCivHdq
/YzuvIhYshKsL7hS75Y6V+QNE6EUrEmEbQV6Qwrmh62N+rWP4lbQZpfgyjrtIPDaoLXavrSQb6ey
soSKu8nBAr01uZvh7ixFP7muhFS+/NcCvW0qfb7rXGiMs4AwcPQJ4lLCJ5P9zhleL34AAAD//wMA
UEsDBBQABgAIAAAAIQCLZi1ovAYAAOkbAAAaAAAAY2xpcGJvYXJkL3RoZW1lL3RoZW1lMS54bWzs
WU9vHDUUvyPxHay5t9n/zUbdVNnNbgtt2ijZFvXonfHOuPGMR7Y36d5Qe0RCQhTEBYkbBwRUaiUu
5dMEiqBI/Qo82zOz4+wsSUoEAppDdubNz+/5/fWzffXaw5ihQyIk5UnPq1+ueYgkPg9oEva8u+PR
pXUPSYWTADOekJ43J9K7tvnuO1fxhs9oOuFYBOOIxAQBo0Ru4J4XKZVurK1JH8hYXuYpSeDblIsY
K3gV4Vog8BEIiNlao1brrMWYJt4mcFSa0ZDBv0RJTfCZ2NdsCEpwDNLvTKfUJwYbHNQ1Qs7lgAl0
iFnPA54BPxqTh8pDDEsFH3pezfx5a5tX1/BGNoipFWNL40bmLxuXDQgOGkamCCeF0Pqo1b2yXfA3
AKaWccPhcDCsF/wMAPs+aGrnUubZGq3X+znPEsg+LvMe1Nq1losv8W8uzbnb7/fb3WwulqkB2cfW
En691mltNRy8AVl8ewnf6m8NBh0Hb0AW31nCj650Oy0Xb0ARo8nBElo7dDTKuBeQKWc3KuHrAF+v
ZfAFCqKhiC4tYsoTtSrWYvyAixEANJBhRROk5imZYh9icoDjiaBYC8AbBJe+WJIvl0haFpK+oKnq
ee+nOPFKkNcvvn394hl6/eLp8aPnx49+OH78+PjR95aXM/AGTsLywFdff/L7lx+i35599erJZ9V4
Wcb//N1HP/34aTUQMmih4cvPn/7y/OnLLz7+9ZsnFfAtgSdl+JjGRKLb5Ajt8Rh0M4ZxZ04m4nwj
xhGmzggcAe8K1kMVOcDbc8yqcH3iGu+egOJRBbw+e+DMdT8SM0UrJN+MYge4wznrc1FpgJtaVsnC
41kSVgsXszJuD+PDKtkDnDiuHc5SqJp5UDq2H0TEmeYuw4nCIUmIQvobPyCkQrv7lDp23aG+4JJP
FbpPUR/TSpOM6cQJpMWgGzQGv8yrdAZXO7bZuYf6nFVpvU0OXSQkBGYVkx8T5pjxOp4pHFexHOOY
lQ1+C6uoapL7c+GXcUOpwNMhYRwNAyJl1Zg7AvQtOf0mhnpV6fYdNo9dpFD0oIrnLcx5GbnNDwYR
jtMq7D5NojL2PXkAIYrRLldV8B3uZoh+Bz/gZKW771HiuPv0QnCXhs6UFgGiv8yE9iUUaqf+xjT5
s2LMKFRjGwNvi3HP24KlqSolbpwowatw/8LCu41nyS6BWF9eeN7W3bd11/vP191VuXzWarsosFB7
dfNg+2LTJccrm+QpZWxfzRm5JU2fLGGxCEZA1OPMZpAUm6Y0gsesuDu4UGAzBgmuPqAq2o9wCj12
3dNMQpmxDiVKuYS9nSFX8tZ46NOV3Rm29Z7B1gOJ1Q4PLLmpyfnWoGBjlpzQ7D9zQU3N4KzCmlcy
pqD2mwir60mdWVrdTM2UOkdaoTL4cFk1IBbWhC4EQe8CVu7AdlyLhr0JZiTQdrcLcO4W44WLdJGM
cEAyH2m9l31UN07KY8UcBkDsVPhI7/NOsVpJWlez/QvSzuKksrjWCnG59/6Kl/IIXnhJ5+2JdGRJ
OTlZgo56XrfdaHvIx2nPm8K2Fh7jFLwudeOHWQgHQr4SNuxPTWaT5QtvdnPF3CSow0mFtfuSwk4d
SIVU21hGNjTMpywEWKIl2fk32mDWi1LARvobzKK5DsHwj80C7Oi6lkynxFdlZ5co2nb2NSulfKaI
2I+CIzRhM7GHwf06VEGfgEo4nTAVQb/AUZq2tvnkFucs6coHWAZn6ZilEc7KrU7RPJMt3ORxMQfz
Vpoe6FY5d6Pc+VUxKX9BqpTD+H+mil5P4LigGWgP+HAuKzDS+drzuFARhyqURtQfCWgcTO2AaIHj
WPgMQQWHyOZXkEP9a3PO8jBpDbs+tUdDJCisRyoShOxCWTLRdwqzerZ2WZYsY2QiqjRdmdppT8gh
YWNdAzt6bfdQBKFuqklWBgzuZPy571kGTULd5JTzzakhxdprc+Dv7nxsMoNSbh02DU1u/2KKFauq
HW+G52tvWRH9YdFmtfKsAGGlpaCbpf0bTuGcS62tWEsaN9r55MCLyxoDsWiIUjj0QfofrH9U+Mxe
OOgFdcz3oLYiuGvQzCBsIKov2cYD6QJpiRNonCzRBpNmZU2btU7aavlifcGdbiH3hLH1zM7i73Ma
u2jOXHFOLl6ksTMLO7a2tJWmBs+eTFEgTfONjHFM1cXTDk7RJKz3PLj8AUc/hCe4PvKA1tC0hqbB
E9wJQbNkL3J6XvaQU+C7pRSYZk5p5phWTmnllHZOgeYsuzLJKR2oVPqWA27Z9I+H8gsN6OCyC5C8
qDq3c5t/AAAA//8DAFBLAwQUAAYACAAAACEAnGZGQbsAAAAkAQAAKgAAAGNsaXBib2FyZC9kcmF3
aW5ncy9fcmVscy9kcmF3aW5nMS54bWwucmVsc4SPzQrCMBCE74LvEPZu0noQkSa9iNCr1AcIyTYt
Nj8kUezbG+hFQfCyMLPsN7NN+7IzeWJMk3ccaloBQae8npzhcOsvuyOQlKXTcvYOOSyYoBXbTXPF
WeZylMYpJFIoLnEYcw4nxpIa0cpEfUBXNoOPVuYio2FBqrs0yPZVdWDxkwHii0k6zSF2ugbSL6Ek
/2f7YZgUnr16WHT5RwTLpRcWoIwGMwdKV2edNS1dgYmGff0m3gAAAP//AwBQSwECLQAUAAYACAAA
ACEAu+VIlAUBAAAeAgAAEwAAAAAAAAAAAAAAAAAAAAAAW0NvbnRlbnRfVHlwZXNdLnhtbFBLAQIt
ABQABgAIAAAAIQCtMD/xwQAAADIBAAALAAAAAAAAAAAAAAAAADYBAABfcmVscy8ucmVsc1BLAQIt
ABQABgAIAAAAIQCx24zcNAMAAIcNAAAfAAAAAAAAAAAAAAAAACACAABjbGlwYm9hcmQvZHJhd2lu
Z3MvZHJhd2luZzEueG1sUEsBAi0AFAAGAAgAAAAhAItmLWi8BgAA6RsAABoAAAAAAAAAAAAAAAAA
kQUAAGNsaXBib2FyZC90aGVtZS90aGVtZTEueG1sUEsBAi0AFAAGAAgAAAAhAJxmRkG7AAAAJAEA
ACoAAAAAAAAAAAAAAAAAhQwAAGNsaXBib2FyZC9kcmF3aW5ncy9fcmVscy9kcmF3aW5nMS54bWwu
cmVsc1BLBQYAAAAABQAFAGcBAACIDQAAAAA=
" type="#_x0000_t75" o:spid="_x0000_s1025"><v:fill o:detectmouseclick="t"></v:fill><v:imagedata src="file:///C:\DOCUME~1\U0045046\LOCALS~1\Temp\msohtmlclip1\01\clip_image001.png" o:title=""></v:imagedata><o:lock aspectratio="f" v:ext="edit"></o:lock><?xml:namespace prefix = x ns = "urn:schemas-microsoft-com
ffice:excel" /><x:ClientData ObjectType="Pict"><x:SizeWithCells></x:SizeWithCells><x:CF>Bitmap</x:CF> <x:AutoPict></x:AutoPict></x:ClientData></v:shape><TABLE cellSpacing=0 cellPadding=0><TBODY><TR><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 56pt; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" height=20 width=75></TD></TR></TBODY></TABLE></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; WIDTH: 140pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" width=187></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #376091; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl80 height=19>RepTitle</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8 0.5pt; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #ece9d8" class=xl75>Client Services</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8 0.5pt" class=xl70 height=19>Rep Phone</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl76>(888) 888-8888</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8 0.5pt" class=xl71 height=20>Rep Email</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #d8d8d8; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl77>john.smith@test.com</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl81 height=20>=COUNTA(A7:A205)</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl66></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8"></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; HEIGHT: 15pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8 0.5pt" class=xl71 height=20>Name1</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #376091; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl78>User_Number</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #7f7f7f; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl72>Password1</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #4a452a; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl73>Client Email Address</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Julie</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8 0.5pt; BORDER-RIGHT: #ece9d8" class=xl79>1111111</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>ABCD</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Julie.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Heather</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111113</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>IJKL</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Heather.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Kalen</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111114</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>MNOP</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Kalen.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Steve</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111115</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>QRST</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Steve.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Chris</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111116</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>UVWX</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Chris.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Tim</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111117</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>YYYYY</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Tim.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Scott</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111118</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>AAAA</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Scott.smith@test.com</TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #dbe5f1; HEIGHT: 14.4pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=19>Kelly</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: #dbe5f1; BORDER-TOP: #ece9d8; BORDER-RIGHT: #ece9d8" class=xl79>1111119</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2f2f2; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 1pt solid" class=xl68>BBBB</TD><TD style="BORDER-BOTTOM: #ece9d8 0.5pt; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #ddd9c3; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl74>Kelly.smith@test.com</TD></TR></TBODY></TABLE>The macro currently opens the oft and populates the rep name, rep title, rep phone, rep email, and password. But I want the code to be able to automically read the number of emails it needs to create. Can anyone help? The first Column is A and the last year in this instance is 14.
