Merge Info from Excel to Publisher

[G33kman]

I'm trying take information the I type into Excel and have a macro drop it into Publisher in the spot where I have Text boxes setup. I work for a Car Audio Shop and I need to make up invoices to send back a bunch of equipment so that we can get it warrantied and I have to write up the same reciept with different information for about 35 different products so if I could use a macro it'd make this a lot smoother. Thanks If you have any quesition ask i'll answer them to the best of my knowledge

 

[Lilliabeth]

Have you considered mail merge?

--Lilliabeth

 

[G33kman]

LOL that's what I wanted to do I just for some reason got it mixed up with macros wow my apology's guys

 

[JPaules]

I'm a bit curious why you are using Publisher for the invoices. Wouldn't it be a lot easier to just use Excel and be done with it?

--
JP