Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
need help with a macro
Ok, I cannot seem to figure this out or at least get it to work right. What I
am doing is trying to bring a list customers from an excel sheet and have their lastname print on it with the proper salutation for them in a Word document. In the excel sheet, the columns are labeled as lastname then firstname then sex. When I use the mailmerge option, i get either the sex and lastname(F Martinez) or firstname lastname (Emilia Martinez). I want it to show Ms. Martinez.. I cannot do a substitutionon the Excel sheet. If I could, the problem would have been solved along time ago. I am a little frustrated by it. I have been working on it for 2 days now. I need the Word document to read " Dear Ms. Martinez,". Sorry for the whining. I am just aggravated at it now. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Button Won't Stay on Toolbar | Microsoft Word Help | |||
Possible bug when recording a Word Macro | Microsoft Word Help | |||
Running document macro from server | New Users | |||
Save As is not working due to macro security settings | Microsoft Word Help | |||
2000 to 2002 macro and "Could not open macro storage" | Mailmerge |