Recent content by jazminecat23

Sweet- that is exactly the bit I was missing. I will work with this tonight and see what I can accomplish. Thank you!

Hi all - how do i reference the button and form location which opens a particular form? I have a form NameDataEntry which can be opened from 3 different places on my database. Depending on where it's opened from, I want to change certain characteristics of the form, mainly it's caption and...

Duane, it works great. thanks for your help!

LOL. Me too Skip. I will give that a try, and see what happens. Thank you so much for all your suggestions though! :)

Data. I highlighted only the data, and pasted it into a new workbook.

Duane - haven't had a chance to try this yet, but it makes sense and I"ll give it a shot later tonight and let you know. Just wanted to say thanks for your response.

I have tried it both as selecting the print area in the mail merge wizard, and selecting the entire sheet in the mail merge wizard. It shows everything except the supervisor column in *both* instances. It's like that column just doesn't exist to MSWord for some reason. And it has no...

oh, and the range is A1:G19. and that is the only data in the worksheet, and the only worksheet in the workbook.

column headings: Supervisor Customer No. Customer Name Department Invoice Date Description Amount the data is contiguous. All rows have something in every column. there are no empty cells in the print area. There are no empty columns, cell A1 contains the word Supervisor above.

Hi - I am doing a mailmerge from excel to word, and when I go to insert the merge fields, it doesn't show all the columns in my worksheet. I have cleared and reset the print area, rearranged the columns, copied the data in to a NEW workbook, and even renamed the area I wanted (and it didn't...

Thanks for all your replies. I like Markus' idea, but lack the expertise in Excel to try it out right now. I'll give it a shot sometime when things are more settled here. What I ended up doing was just sorting the data by name, doing the merge, and just cutting and pasting the info for the...

Hello all - I have a query I use to populate a subform. This subform lists all charges against a client, by case. Currently, if one case has multiple charges, it lists them each individually. What I would like it to do is this - if there is only one charge on the case, list the chargetype...

ugh. so in a word, I can't do it in Word, and use my word templates, which have all of our letterhead and stuff on them, right? Because it's not a huge thing, and I won't have to do it often enough to spend hours trying to set up a memo document in Excel. thanks tho.

Hi, I have a data set with names and charges. Some names have many charges, some names have one charge. I need to send out a word document to each name listing their charges. Can anyone tell me how to do a merge and have it create one document per person, listing all of that person's charges...

:lightbulb: Ah, they were indeed formatted as text! Thanks y'all!! You saved me yet again.