Search results for query: *

I think the reason it wasn't working is because they were separate workbooks. When I figured out I had to add the data as a sheet to the form workbook it worked. And yes - he deserves a big star!

Thank you for all your patience and assistance. One last question - is it possible to have it sent to a file instead of the printer?

I swear the error was on that statement and I do Debug. I don't know what happened because it's on another one now and I didn't change anything. When I put the SET ws Form in front of the Set wsdata it says subscript out of range.

Function RangeName(sName As String) As String RangeName = Application.Substitute(sName, " ", "_") End Function Sub MergePrint() Dim wsForm As Worksheet, wsData As Worksheet Dim sRngName As String, r As Long, c As Integer Set wsData = Workbooks("Total Compensation...

Ok - got through that one. Now it says "Run time error 91: object variable or with block variable not set" on With wsdata.cells (1,1).current region.

I already had it in the letter but maybe I had something typed wrong. I copied and pasted it again and now it's giving me "run-time error '9': Supscript out of range". UGH! This is what I put in the letter: Function RangeName(sName As String) As String RangeName =...

I couldn't find the RangeName function in the FAQ - I just googled it. Can you help me with that? 1) Where do I put that code? 2) I removed the EMP_ID column. The reference from wsdata in that statement needs the .Value property, yielding the value 6133 - I have no idea what you're...

Yes. They're in the data file and the letter.

I already did the range names in my data file. I highlighted the column and clicked on Define Name and typed in a name. I double checked and they're all still there and there are no spaces in them. Holly

Thanks Skip. I got that one fixed. Now I'm getting: Compile error: sub or function not defined and it's highlighting RangeName.

Compile error: Ambiguous name detected: Mergeprint

I'm getting an ambiguous name error on MergePrint. Below is what I put in Visual. https://res.cloudinary.com/engineering-com/raw/upload/v1464192687/tips/Doc5_ib0bh8.docx

I'm trying to do total compensation report for our employees. I've created a database in Excel and I created the letter in excel. How can I merge the two files to create the letters? I have Excel 2013.

I'm trying to do total compensation report for our employees. I've created a database in Excel and I created the letter in excel. How can I merge the two files to create the letters? I have Excel 2013.

This is the Select Expert Record formula I'm using. {PS_HEALTH_BENEFIT.COVERAGE_ELECT} = "E" and {PS_ALL_EMPLOYEES.AL_EMPL_STATUS} = "A" and isnull({PS_HEALTH_BENEFIT.COVERAGE_END_DT})

Yes SkipVought. I have an Employee Status in the table.

I'm trying to create a report that will show the most current health and dental insurance coverage our employees have. The report is perfect except it is showing employees that no longer have coverage and I can't get it to eliminate these employees. I have a Database Field called Coverage End...

Hope someone out there can help me with this report. I'm trying to create a report that will show the most current health and dental insurance coverage our employees have. The report is ommitting coverage when there are diffferent effective dates i.e. when the health and dental insurance...

It worked!! You're wonderful!! Thank you soooooo much!!

Thank you soooo much for your help! It would have taken me three lifetimes to come up with that! I'm having a slight problem though. When I go into the Selection Criteria and change the criteria from data field to formula, it wants another field. It says "formula _____ is equal to text...