moving the email templates from Excel to Word document

[rk68]

Hi,

I have multiple Email templates in Excel. These templates are in each column.
I want this templates to be converted to Word document, so each template will fall in each page.

for e.g. if there are 5 templates in 5 columns (Column A - E). Content of column A will page 1 of Word doc,content of column B will be page 2 & so on. I have attached sample file for reference.

How can this be done using VBA.

TIA,
RAJ

 

[Andrzejek]

So you have an Excel file that looks like this:
[pre]
A B ...
1 Product sub-category
2 Health Appointment fixed
Checkups Cancelled
Rescheduled
3 ... [/pre]

How do you want it to have in Word?
Cells A1 and A2 on first page? B1 and B2 on second, and so on...?

And what does it have to do with "e-mail templates"?

BTW - If you are looking for a VBA solution, you should ask your question in forum707


---- Andy

There is a great need for a sarcasm font.

 

[rk68]

Hi Andy,
I have attached a doc file FYR.
It should something similar. If possible each of the column content can fall in separate page.


Thanks,
RAJ

 

[rk68]

I did manage it without VBA/macros.

Thanks.