Search results for query: *

Hi I'm supposed to be calculating the sum of cells based on their font colour. i'm working in excel 2003, and i've got the Vba module code for the process - Function ColorFunction(rColor As Range, rRange As Range, Optional SUM As Boolean) Dim rCell As Range Dim lCol As Long Dim...

thats absolutely top class brilliant - thanks a load. just what i needed

i read it, but i still arent sure how to save exactly how i want. here is the folder i want it to save into S:\Finance\LettersToClients\ and it would be «Name» as the first part - that is the field for company name and then i want the date the letter was saved as at the end.

also, doesnt your code tell me to print it out rather than save? im basically completely new to vba as its been so long. the closest i've had is the one i mentioned on my second post - but that saves it as pagexofmm2.doc mm2 is the mailmerged filename the company field in the Mail Merge is...

i get a compile error method or data member not found

what i've done is moved the mailmerge so it shows as 67 pages long with each merge able to edit individually. im sorry to be a pain, but, could you show me what the entire code should look like that i would paste into the vba. from start to finish the whole code. thanks

thanks - its been a long time since i looked at vb and by now i've forgotten how to link to mailmerge and everything. would i just copy that code exactly? and that would work?

well i found one just after posting that seems to work but it saves as in the format page15ofmm2 mm2 being the original file name what i really need - is to have the company name, and date in the file name - eg ABCCompany_25/5/07 i have the mail merge field for company name. is there...

Hi, im trying to separate mail merge documents into separate files so i can save each letter in a mail merge as a separate file. Save each merged letter as a separate file Normally, the mail merge result to a new document is one long file which can be edited and printed. Using the Master...